DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on PAY_ALL_PAYROLLS_F

Line 6984: l_payroll_name pay_all_payrolls_f.payroll_name%type := null;

6980: p_payroll_id in number
6981: ,p_effective_date in date
6982: ) return varchar2 is
6983:
6984: l_payroll_name pay_all_payrolls_f.payroll_name%type := null;
6985:
6986: cursor c_payroll_name is
6987: select prl.payroll_name
6988: from pay_all_payrolls_f prl

Line 6988: from pay_all_payrolls_f prl

6984: l_payroll_name pay_all_payrolls_f.payroll_name%type := null;
6985:
6986: cursor c_payroll_name is
6987: select prl.payroll_name
6988: from pay_all_payrolls_f prl
6989: where prl.payroll_id = p_payroll_id
6990: and p_effective_date between prl.effective_start_date
6991: and prl.effective_end_date;
6992: