DBA Data[Home] [Help]

APPS.PAY_BALANCE_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 5822: l_consol_set_id pay_all_payrolls_f.payroll_id%type;

5818: p_balance_result number;
5819: --
5820: l_payroll_id per_all_assignments_f.payroll_id%type;
5821: l_bus_grp_id per_all_assignments_f.business_group_id%type;
5822: l_consol_set_id pay_all_payrolls_f.payroll_id%type;
5823: l_ass_action_id pay_assignment_actions.assignment_action_id%type;
5824: l_pay_action_id pay_payroll_actions.payroll_action_id%type;
5825: l_time_period_id per_time_periods.time_period_id%type;
5826: l_asg_lock boolean;

Line 5858: , pay_all_payrolls_f PAYROLL

5854: into l_payroll_id,
5855: l_bus_grp_id,
5856: l_consol_set_id
5857: from per_all_assignments_f ASSIGN
5858: , pay_all_payrolls_f PAYROLL
5859: where ASSIGN.assignment_id = p_assignment_id
5860: and p_virtual_date between ASSIGN.effective_start_date
5861: and ASSIGN.effective_end_date
5862: and PAYROLL.payroll_id = ASSIGN.payroll_id