DBA Data[Home] [Help]

APPS.PAY_PAYKRSOE_XMLP_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 277: ,Pay_Assignment_Actions paa

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
281: ,Pay_Assignment_Actions rpaa

Line 281: ,Pay_Assignment_Actions rpaa

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

Line 338: From Pay_Assignment_Actions paa

334: Begin
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

Line 341: ,Pay_Assignment_Actions aa

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
345: And pai.Locking_Action_Id = aa.Assignment_Action_Id