DBA Data[Home] [Help]

APPS.PAY_MX_PAYREG_PKG dependencies on PAY_CONSOLIDATION_SETS

Line 1016: ,pay_consolidation_sets pcs

1012: ,pcs.consolidation_set_name
1013: FROM pay_payroll_actions ppa
1014: ,pay_assignment_actions paa
1015: ,pay_payrolls_f ppf
1016: ,pay_consolidation_sets pcs
1017: WHERE ppa.payroll_action_id = paa.payroll_action_id
1018: AND ppa.payroll_id = ppf.payroll_id
1019: AND ppa.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
1020: AND ppf.consolidation_set_id = pcs.consolidation_set_id

Line 1215: FROM pay_consolidation_sets

1211: WHERE payroll_id = cp_payroll_id;
1212:
1213: CURSOR c_get_consolidation_set_name (cp_consolidation_set_id number) IS
1214: SELECT consolidation_set_name
1215: FROM pay_consolidation_sets
1216: WHERE consolidation_set_id = cp_consolidation_set_id;
1217:
1218: CURSOR c_get_gre_name (cp_tax_unit_id NUMBER) IS
1219: SELECT hou.name