DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PAY_PAYROLLS_F

Line 2917: from pay_payrolls_f pay

2913: l_payroll_id number;
2914: begin
2915: select pay.payroll_id
2916: into l_payroll_id
2917: from pay_payrolls_f pay
2918: where pay.payroll_name = p_payroll_name
2919: and pay.business_group_id + 0 = p_business_group_id
2920: and p_effective_date between
2921: pay.effective_start_date and pay.effective_end_date;