DBA Data[Home] [Help]

APPS.PAY_PAYJPITT_XMLP_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 127: PAY_PAYROLL_ACTIONS PPA

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
131: AND PPA.ACTION_TYPE IN ('R', 'Q', 'B', 'I')

Line 140: FROM PAY_PAYROLL_ACTIONS PPAV,

136: AND PPT.SALARY_CATEGORY = 'TERM'
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