238:
239: function CF_Effective_DateFormula return Date is
240:
241: lv_Effective_Date Pay_Payroll_Actions.Effective_Date%TYPE;
242: lv_Payroll_Name Pay_PAyrolls_F.Payroll_Name%TYPE;
243: lv_RunType_Period VARCHAR2(100);
244: lv_Bus_Place hr_organization_information.Org_Information1%TYPE;
245: lv_Assignment_Number Per_Assignments_F.Assignment_Number%TYPE;
246: lvnum NUMBER;
248: lvsort1 VARCHAR2(50);
249: lvsort2 VARCHAR2(50);
250: lvsort3 VARCHAR2(50);
251: lvsort4 VARCHAR2(50);
252: Cursor Cur_Pay_Payrolls_F is
253: Select Payroll_Name
254: From Pay_Payrolls_F
255: Where Payroll_Id = P_PAYROLL_ID;
256:
250: lvsort3 VARCHAR2(50);
251: lvsort4 VARCHAR2(50);
252: Cursor Cur_Pay_Payrolls_F is
253: Select Payroll_Name
254: From Pay_Payrolls_F
255: Where Payroll_Id = P_PAYROLL_ID;
256:
257: Cursor Cur_Per_Assignments_F is
258: Select Assignment_Number
261: begin
262:
263:
264: Begin
265: Open Cur_Pay_Payrolls_F;
266: Fetch Cur_Pay_Payrolls_F Into lv_Payroll_Name;
267: Close Cur_Pay_Payrolls_F;
268:
269: CP_Payroll_Name := lv_Payroll_Name;
262:
263:
264: Begin
265: Open Cur_Pay_Payrolls_F;
266: Fetch Cur_Pay_Payrolls_F Into lv_Payroll_Name;
267: Close Cur_Pay_Payrolls_F;
268:
269: CP_Payroll_Name := lv_Payroll_Name;
270: end;
263:
264: Begin
265: Open Cur_Pay_Payrolls_F;
266: Fetch Cur_Pay_Payrolls_F Into lv_Payroll_Name;
267: Close Cur_Pay_Payrolls_F;
268:
269: CP_Payroll_Name := lv_Payroll_Name;
270: end;
271: