APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 1227: ,pay_element_classifications pec

1223: OR (eei_information1 = 'MX_IDWF' AND gv_IDW_calc_method <> 'B'))
1224: UNION ALL
1225: SELECT 'MX_IDWV'
1226: FROM pay_element_types_f pet
1227: ,pay_element_classifications pec
1228: ,pay_sub_classification_rules_f psr
1229: WHERE pet.element_type_id = cp_element_type_id
1230: AND cp_effective_date BETWEEN pet.effective_start_date
1231: AND pet.effective_end_date

Line 4106: ,pay_element_classifications pec

4102: FROM per_assignments_f paf
4103: ,pay_payroll_actions ppa
4104: ,pay_element_entries_f pee
4105: ,pay_sub_classification_rules_f psc
4106: ,pay_element_classifications pec
4107: ,pay_assignment_actions paa
4108: ,pay_payroll_actions ppa2
4109: WHERE ppa.payroll_action_id = '|| ln_pactid ||' '||
4110: 'AND paf.business_group_id = ppa.business_group_id

Line 4214: ,pay_element_classifications pec

4210: FROM per_assignments_f paf
4211: ,pay_payroll_actions ppa
4212: ,pay_element_entries_f pee
4213: ,pay_sub_classification_rules_f psc
4214: ,pay_element_classifications pec
4215: ,pay_assignment_actions paa
4216: ,pay_payroll_actions ppa2
4217: WHERE ppa.payroll_action_id = cp_payroll_action_id
4218: AND paf.business_group_id = ppa.business_group_id

Line 4299: ,pay_element_classifications pec

4295: ,per_assignments_f paf
4296: ,pay_population_ranges ppr
4297: ,pay_element_entries_f pee
4298: ,pay_sub_classification_rules_f psc
4299: ,pay_element_classifications pec
4300: ,pay_assignment_actions paa
4301: ,pay_payroll_actions ppa2
4302: WHERE ppa.payroll_action_id = cp_payroll_action_id
4303: AND ppr.payroll_action_id = ppa.payroll_action_id