DBA Data[Home] [Help]

APPS.PAY_PAYJPITT_XMLP_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 126: PAY_ASSIGNMENT_ACTIONS PAA,

122: INTO CP_TERM_COUNT,
123: CP_TERM_TAXABLE_INCOME,
124: CP_TERM_ITAX
125: FROM PAY_JP_PRE_TAX PPT,
126: PAY_ASSIGNMENT_ACTIONS PAA,
127: PAY_PAYROLL_ACTIONS PPA
128: WHERE PPA.EFFECTIVE_DATE
129: BETWEEN P_START_DATE AND P_END_DATE
130: AND PPA.BUSINESS_GROUP_ID + 0 = P_BUSINESS_GROUP_ID

Line 141: PAY_ASSIGNMENT_ACTIONS PAAV,

137: AND PPT.ITAX_ORGANIZATION_ID = P_ITAX_ORGANIZATION_ID
138: AND NOT EXISTS(
139: SELECT NULL
140: FROM PAY_PAYROLL_ACTIONS PPAV,
141: PAY_ASSIGNMENT_ACTIONS PAAV,
142: PAY_ACTION_INTERLOCKS PAI
143: WHERE PAI.LOCKED_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
144: AND PAAV.ASSIGNMENT_ACTION_ID = PAI.LOCKING_ACTION_ID
145: AND PPAV.PAYROLL_ACTION_ID = PAAV.PAYROLL_ACTION_ID