DBA Data[Home] [Help]

APPS.PAY_PAYAUSOE_XMLP_PKG dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 60: PER_ABSENCE_ATTENDANCE_TYPES PAAT,

56: PAY_ELEMENT_LINKS_F EL,
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

Line 77: PER_ABSENCE_ATTENDANCE_TYPES PAAT1

73: AND PAAT.ABSENCE_ATTENDANCE_TYPE_ID = (
74: SELECT
75: MAX(PAAT1.ABSENCE_ATTENDANCE_TYPE_ID)
76: FROM
77: PER_ABSENCE_ATTENDANCE_TYPES PAAT1
78: WHERE PAAT1.INPUT_VALUE_ID = AP.PTO_INPUT_VALUE_ID )
79: AND PA.EFFECTIVE_DATE between ET.EFFECTIVE_START_DATE
80: AND ET.EFFECTIVE_END_DATE
81: AND PA.EFFECTIVE_DATE between EL.EFFECTIVE_START_DATE