DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on PAY_ALL_PAYROLLS_F

Line 2892: from pay_all_payrolls_f prl

2888: l_out_epy_result_id number(15);
2889: --
2890: cursor c_get_mapping_name9(p_id in number,p_date date) is
2891: select prl.payroll_name dsp_payroll_name
2892: from pay_all_payrolls_f prl
2893: where prl.business_group_id = p_business_group_id
2894: and prl.payroll_id = p_id
2895: and p_date between prl.effective_start_date and prl.effective_end_date ;
2896: --

Line 2900: from pay_all_payrolls_f

2896: --
2897:
2898: cursor c_payroll_start_date(c_payroll_id number) is
2899: select min(effective_start_date) effective_start_date
2900: from pay_all_payrolls_f
2901: where payroll_id = c_payroll_id;
2902:
2903: l_payroll_start_date pay_all_payrolls_f.effective_start_date%type;
2904: ---------------------------------------------------------------

Line 2903: l_payroll_start_date pay_all_payrolls_f.effective_start_date%type;

2899: select min(effective_start_date) effective_start_date
2900: from pay_all_payrolls_f
2901: where payroll_id = c_payroll_id;
2902:
2903: l_payroll_start_date pay_all_payrolls_f.effective_start_date%type;
2904: ---------------------------------------------------------------
2905: -- END OF BEN_ELIG_PYRL_PRTE_F ----------------------
2906: ---------------------------------------------------------------
2907: ---------------------------------------------------------------