DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on PAY_ALL_PAYROLLS_F

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

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

Line 6987: from pay_all_payrolls_f prl

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