DBA Data[Home] [Help]

APPS.PAY_BALANCE_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 5520: l_consol_set_id pay_all_payrolls_f.payroll_id%type;

5516: p_balance_result number;
5517: --
5518: l_payroll_id per_all_assignments_f.payroll_id%type;
5519: l_bus_grp_id per_all_assignments_f.business_group_id%type;
5520: l_consol_set_id pay_all_payrolls_f.payroll_id%type;
5521: l_ass_action_id pay_assignment_actions.assignment_action_id%type;
5522: l_pay_action_id pay_payroll_actions.payroll_action_id%type;
5523: l_time_period_id per_time_periods.time_period_id%type;
5524: l_asg_lock boolean;

Line 5556: , pay_all_payrolls_f PAYROLL

5552: into l_payroll_id,
5553: l_bus_grp_id,
5554: l_consol_set_id
5555: from per_all_assignments_f ASSIGN
5556: , pay_all_payrolls_f PAYROLL
5557: where ASSIGN.assignment_id = p_assignment_id
5558: and p_virtual_date between ASSIGN.effective_start_date
5559: and ASSIGN.effective_end_date
5560: and PAYROLL.payroll_id = ASSIGN.payroll_id