21: And Effective_Start_Date = ES_Date
22: And Effective_End_Date = EE_Date;
23:
24:
25: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
26: EStart_Date pay_payrolls_f.Effective_Start_Date%Type;
27: EEnd_Date pay_payrolls_f.Effective_Start_Date%Type;
28:
29: BEGIN
22: And Effective_End_Date = EE_Date;
23:
24:
25: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
26: EStart_Date pay_payrolls_f.Effective_Start_Date%Type;
27: EEnd_Date pay_payrolls_f.Effective_Start_Date%Type;
28:
29: BEGIN
30: Open Dates_Cur;
23:
24:
25: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
26: EStart_Date pay_payrolls_f.Effective_Start_Date%Type;
27: EEnd_Date pay_payrolls_f.Effective_Start_Date%Type;
28:
29: BEGIN
30: Open Dates_Cur;
31: If Dates_Cur%NotFound Then