APPS.PAY_VOID_REVERSAL_PKG dependencies on PAY_CONSOLIDATION_SETS

Line 68: consolidation_set_name pay_consolidation_sets.consolidation_set_name%TYPE,

64: start_cheque_number pay_payroll_actions.start_cheque_number%TYPE,
65: start_date pay_payroll_actions.start_date%TYPE,
66: consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
67: payroll_name pay_all_payrolls_f.payroll_name%TYPE,
68: consolidation_set_name pay_consolidation_sets.consolidation_set_name%TYPE,
69: business_group_id pay_all_payrolls_f.business_group_id%TYPE,
70: assignment_id pay_assignment_actions.assignment_id%TYPE
71: );
72: --

Line 152: ,pay_consolidation_sets pcs

148: INTO check_details_rec
149: FROM pay_payroll_actions ppa
150: ,pay_assignment_actions paa
151: ,pay_all_payrolls_f papf
152: ,pay_consolidation_sets pcs
153: ,pay_org_payment_methods_f popmf
154: ,pay_pre_payments ppp
155: WHERE paa.assignment_action_id = p_check_assignment_action
156: AND ppp.pre_payment_id = paa.pre_payment_id

Line 614: pay_all_payrolls_f papf, pay_consolidation_sets pcs

610: ppa.action_type, ppa.action_status,
611: ppa.action_population_status
612: into payroll_action_rec
613: from pay_payroll_actions ppa, pay_assignment_actions paa,
614: pay_all_payrolls_f papf, pay_consolidation_sets pcs
615: where paa.assignment_action_id = l_payroll_run_asg_action
616: and ppa.payroll_action_id = paa.payroll_action_id
617: and papf.payroll_id = ppa.payroll_id
618: and pcs.consolidation_set_id = ppa.consolidation_set_id