APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 1302: ,pay_element_classifications pec

1298: OR (eei_information1 = 'MX_IDWF' AND gv_IDW_calc_method <> 'B'))
1299: UNION ALL
1300: SELECT 'MX_IDWV'
1301: FROM pay_element_types_f pet
1302: ,pay_element_classifications pec
1303: ,pay_sub_classification_rules_f psr
1304: WHERE pet.element_type_id = cp_element_type_id
1305: AND cp_effective_date BETWEEN pet.effective_start_date
1306: AND pet.effective_end_date

Line 4239: ,pay_element_classifications pec

4235: CURSOR c_chk_elements IS
4236: select 'Y'
4237: from pay_element_entries_f pee
4238: ,pay_sub_classification_rules_f psc
4239: ,pay_element_classifications pec
4240: ,pay_assignment_actions paa
4241: ,pay_payroll_actions ppa2
4242: WHERE pee.assignment_id = p_assignment_id
4243: AND pee.effective_start_date <= p_periodic_end_date

Line 4545: ,pay_element_classifications pec

4541: FROM per_assignments_f paf
4542: ,pay_payroll_actions ppa
4543: ,pay_element_entries_f pee
4544: ,pay_sub_classification_rules_f psc
4545: ,pay_element_classifications pec
4546: ,pay_assignment_actions paa
4547: ,pay_payroll_actions ppa2
4548: WHERE ppa.payroll_action_id = cp_payroll_action_id
4549: AND paf.business_group_id = ppa.business_group_id

Line 4630: ,pay_element_classifications pec

4626: ,per_assignments_f paf
4627: ,pay_population_ranges ppr
4628: ,pay_element_entries_f pee
4629: ,pay_sub_classification_rules_f psc
4630: ,pay_element_classifications pec
4631: ,pay_assignment_actions paa
4632: ,pay_payroll_actions ppa2
4633: WHERE ppa.payroll_action_id = cp_payroll_action_id
4634: AND ppr.payroll_action_id = ppa.payroll_action_id