DBA Data[Home] [Help]

APPS.HXT_TIMECARD_API dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 178: PAY_ELEMENT_CLASSIFICATIONS PEC,

174: AND ELTV.EFFECTIVE_END_DATE
175: AND EXISTS
176: (SELECT 1
177: FROM PAY_ELEMENT_TYPES_F PETF1,
178: PAY_ELEMENT_CLASSIFICATIONS PEC,
179: PAY_ELEMENT_ENTRIES_F PEEF,
180: PAY_ELEMENT_LINKS_F PELF,
181: PAY_ACCRUAL_PLANS PAP1
182: WHERE

Line 318: PAY_ELEMENT_CLASSIFICATIONS PEC,

314: -- Begin ER180, to find accrual plan assigned for an emp.
315: AND PAP.ACCRUAL_PLAN_NAME IN
316: (SELECT PAP1.ACCRUAL_PLAN_NAME
317: FROM PAY_ELEMENT_TYPES_F PETF1,
318: PAY_ELEMENT_CLASSIFICATIONS PEC,
319: PAY_ELEMENT_ENTRIES_F PEEF,
320: PAY_ELEMENT_LINKS_F PELF,
321: PAY_ACCRUAL_PLANS PAP1
322: WHERE PEEF.ASSIGNMENT_ID = sm.assignment_id

Line 368: ,PAY_ELEMENT_CLASSIFICATIONS PEC

364: -- Begin ER180, to find accrual plan assigned for an emp
365: AND PAP.ACCRUAL_PLAN_NAME IN
366: (SELECT PAP1.ACCRUAL_PLAN_NAME
367: FROM PAY_ELEMENT_TYPES_F PETF1
368: ,PAY_ELEMENT_CLASSIFICATIONS PEC
369: ,PAY_ELEMENT_ENTRIES_F PEEF
370: ,PAY_ELEMENT_LINKS_F PELF
371: ,PAY_ACCRUAL_PLANS PAP1
372: WHERE PEEF.ASSIGNMENT_ID = sm.assignment_id