DBA Data[Home] [Help]

APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PAY_SUB_CLASSIFICATION_RULES_F

Line 1303: ,pay_sub_classification_rules_f psr

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
1307: AND psr.element_type_id = pet.element_type_id

Line 4238: ,pay_sub_classification_rules_f psc

4234:
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

Line 4544: ,pay_sub_classification_rules_f psc

4540: ,'Y' variable_idw
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

Line 4629: ,pay_sub_classification_rules_f psc

4625: FROM pay_payroll_actions ppa
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