APPS.PAY_VOID_REVERSAL_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 67: payroll_name pay_all_payrolls_f.payroll_name%TYPE,

63: cheque_report pay_payroll_actions.cheque_report%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: );

Line 69: business_group_id pay_all_payrolls_f.business_group_id%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: --
73: check_details_rec check_details_rectype;

Line 151: ,pay_all_payrolls_f papf

147: -- ,popmf.org_payment_method_name
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

Line 474: pay_assignment_actions paa2, pay_all_payrolls_f papf,

470: paa.assignment_id, ppp.pre_payment_id, paa2.serial_number
471: into l_prepayment_asg_action, l_payroll_id, l_assignment_id,
472: l_pre_payment_id, l_serial_number
473: from pay_payroll_actions ppa, pay_assignment_actions paa,
474: pay_assignment_actions paa2, pay_all_payrolls_f papf,
475: pay_pre_payments ppp, pay_action_interlocks pal
476: where pal.locking_action_id = p_check_assignment_action
477: and paa2.assignment_action_id = p_check_assignment_action
478: and paa.assignment_action_id = pal.locked_action_id

Line 546: business_group_id pay_all_payrolls_f.business_group_id%TYPE,

542:
543: TYPE payroll_action_rectype IS RECORD
544: ( payroll_id pay_payroll_actions.payroll_id%TYPE,
545: consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
546: business_group_id pay_all_payrolls_f.business_group_id%TYPE,
547: action_type pay_payroll_actions.action_type%TYPE,
548: action_status pay_payroll_actions.action_status%TYPE,
549: action_population_status pay_payroll_actions.action_population_status%TYPE
550: );

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