DBA Data[Home] [Help]

APPS.PAY_PAYAUSOE_XMLP_PKG dependencies on PER_TIME_PERIODS

Line 61: PER_TIME_PERIODS TP

57: PAY_ELEMENT_ENTRIES_F EE,
58: PAY_ASSIGNMENT_ACTIONS AA,
59: PAY_PAYROLL_ACTIONS PA,
60: PER_ABSENCE_ATTENDANCE_TYPES PAAT,
61: PER_TIME_PERIODS TP
62: WHERE AA.ASSIGNMENT_ACTION_ID = R_ASG_ASSIGNMENT_ACTION_ID
63: AND AP.ACCRUAL_CATEGORY = 'AUAL'
64: AND ET.ELEMENT_TYPE_ID = AP.ACCRUAL_PLAN_ELEMENT_TYPE_ID
65: AND EL.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID

Line 302: PER_TIME_PERIODS PTP

298: PTP.START_DATE
299: FROM
300: PAY_ASSIGNMENT_ACTIONS PAC,
301: PAY_PAYROLL_ACTIONS PPA,
302: PER_TIME_PERIODS PTP
303: WHERE PPA.PAYROLL_ACTION_ID = PAC.PAYROLL_ACTION_ID
304: AND PAC.SOURCE_ACTION_ID is null
305: AND PTP.PAYROLL_ID = PPA.PAYROLL_ID
306: AND PPA.DATE_EARNED between PTP.START_DATE