DBA Data[Home] [Help]

APPS.PAY_PAYKRSOE_XMLP_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 282: ,Pay_Action_Interlocks pai

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
285: And ppa.action_type IN ('U','P')
286: And ppa.action_status = 'C'

Line 294: From Pay_Action_Interlocks ai

290: And pai.Locking_Action_Id = paa.Assignment_Action_Id
291: And pai.Locked_Action_Id = rpaa.Assignment_Action_Id
292: And rpaa.Run_Type_Id = prt.Run_Type_Id
293: And pai.Locked_Action_Id = ( Select max(Locked_Action_Id) Locked_Action_Id
294: From Pay_Action_Interlocks ai
295: where ai.Locking_Action_Id = pai.Locking_Action_Id )
296: And rppa.Payroll_Id = ptp.Payroll_Id
297: And rppa.Effective_Date Between ptp.Start_Date
298: And ptp.End_Date

Line 339: ,Pay_Action_Interlocks pai

335: Select count(*)
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')