1. Tables and Views for HCM
  2. PAY_AMER_W4_LOC_ADDRESS_V

PAY_AMER_W4_LOC_ADDRESS_V

Details

  • Schema: FUSION

  • Object owner: HRX

  • Object type: VIEW

Columns

Name

STATE

DIR_CARD_COMP_ID

Query

SQL_Statement

SELECT DISTINCT paf.region_2 State,rep.dir_card_comp_id

/*LocationAddress*/

FROM per_all_assignments_m hra ,

PAY_REL_GROUPS_DN pa ,

PAY_REL_GROUPS_f paaf ,

per_addresses_f paf ,

per_loc_address_usages_f loc ,

pay_dir_rep_card_usages_f prepu ,

pay_dir_rep_cards_f rep

/*,pay_dir_card_comp_defs_f sc, pay_dir_card_components_f tc*/

WHERE /*rep.dir_card_comp_id =100000042961022

AND*/ prepu.dir_rep_card_id =rep.dir_rep_card_id

AND pa.parent_rel_group_id =prepu.relationship_group_id

AND paaf.relationship_group_id= pa.relationship_group_id

AND prepu.effective_start_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date

AND hra.assignment_id =pa.assignment_id

AND loc.location_id =hra.location_id

AND paF.address_id = loc.address_id

AND upper(loc.address_usage_type) IN ('US_LOC_OVERRIDE','MAIN')

/*and rep.dir_card_comp_id=tc.dir_card_comp_id and sc.base_component_name like 'US_WTH_TAXATION' and tc.dir_card_comp_def_id= tc.dir_card_comp_def_id*/