[Home] [Help]
237: end;
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;
272:
273: Begin
274: Select distinct Run_Type_Name||'-'||Period_Name||'-'||ppa.Payroll_Action_Id
275: Into lv_RunType_Period
276: From Pay_Payroll_Actions ppa
277: ,Pay_Assignment_Actions paa
278: ,Pay_Run_Types_F prt
279: ,Per_Time_Periods ptp
280: ,Pay_Payroll_Actions rppa
276: From Pay_Payroll_Actions ppa
277: ,Pay_Assignment_Actions paa
278: ,Pay_Run_Types_F prt
279: ,Per_Time_Periods ptp
280: ,Pay_Payroll_Actions rppa
281: ,Pay_Assignment_Actions rpaa
282: ,Pay_Action_Interlocks pai
283: Where ppa.Payroll_Action_Id = P_TIME_PERIOD_ID And rppa.Payroll_Id = P_PAYROLL_ID
284: And ppa.Payroll_Action_Id = paa.Payroll_Action_Id
336: Into lvnum
337: From ( Select distinct paa.Run_Type_Id
338: From Pay_Assignment_Actions paa
339: ,Pay_Action_Interlocks pai
340: ,Pay_Payroll_Actions pa
341: ,Pay_Assignment_Actions aa
342: Where pa.Payroll_Action_Id = aa.Payroll_Action_Id
343: And pa.Action_Type IN ('P','U')
344: And pai.Locked_Action_Id = paa.Assignment_Action_Id
382:
383: Begin
384: Select Effective_Date
385: Into lv_Effective_Date
386: From Pay_Payroll_Actions
387: Where Payroll_Action_Id = P_TIME_PERIOD_ID;
388: return ( lv_Effective_Date );
389: Exception
390: When Others Then
398: lvFlagNum NUMBER := 0;
399: begin
400: Select decode(Pay_Advice_Message,null,0,1)
401: Into lvFlagNum
402: From Pay_Payroll_Actions
403: Where Payroll_Action_Id = Payroll_Action_Id_Payroll;
404:
405: return ( lvFlagNum );
406: exception