DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PAY_PAYROLLS_F

Line 2890: from pay_payrolls_f pay

2886: l_payroll_id number;
2887: begin
2888: select pay.payroll_id
2889: into l_payroll_id
2890: from pay_payrolls_f pay
2891: where pay.payroll_name = p_payroll_name
2892: and pay.business_group_id + 0 = p_business_group_id
2893: and p_effective_date between
2894: pay.effective_start_date and pay.effective_end_date;