APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on PAY_ALL_PAYROLLS_F

Line 6812: from pay_all_payrolls_f prl

6808: l_out_pr__result_id number(15);
6809: --
6810: cursor c_get_mapping_name12(p_id in number,p_date in date) is
6811: select prl.payroll_name dsp_payroll_name
6812: from pay_all_payrolls_f prl
6813: where prl.business_group_id = p_business_group_id
6814: and prl.payroll_id = p_id
6815: and p_date between prl.effective_start_date and prl.effective_end_date ;
6816: --

Line 6820: from pay_all_payrolls_f

6816: --
6817:
6818: cursor c_payroll_start_date(c_payroll_id number) is
6819: select min(effective_start_date) effective_start_date
6820: from pay_all_payrolls_f
6821: where payroll_id = c_payroll_id;
6822:
6823: l_payroll_start_date pay_all_payrolls_f.effective_start_date%type;
6824: ---------------------------------------------------------------

Line 6823: l_payroll_start_date pay_all_payrolls_f.effective_start_date%type;

6819: select min(effective_start_date) effective_start_date
6820: from pay_all_payrolls_f
6821: where payroll_id = c_payroll_id;
6822:
6823: l_payroll_start_date pay_all_payrolls_f.effective_start_date%type;
6824: ---------------------------------------------------------------
6825: -- END OF BEN_PYRL_RT_F ----------------------
6826: ---------------------------------------------------------------
6827: ---------------------------------------------------------------