DBA Data[Home] [Help]

APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PAY_SUB_CLASSIFICATION_RULES_F

Line 1228: ,pay_sub_classification_rules_f psr

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

Line 4105: ,pay_sub_classification_rules_f psc

4101: 'SELECT paf.person_id
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 ||' '||

Line 4213: ,pay_sub_classification_rules_f psc

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

Line 4298: ,pay_sub_classification_rules_f psc

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