DBA Data[Home] [Help]

APPS.PQP_ABSVAL_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 106: FROM per_absence_attendances paa

102: )
103: IS
104: SELECT paa.date_start
105: ,paa.date_end
106: FROM per_absence_attendances paa
107: WHERE paa.absence_attendance_id = p_absence_attendance_id;
108: --
109: CURSOR csr_gap_absence_plan
110: (p_absence_attendance_id IN NUMBER

Line 180: ,per_absence_attendances paa

176: + 1
177: ) cnt
178: FROM hr_lookups hrl
179: ,ben_pl_f bp
180: ,per_absence_attendances paa
181: ,pqp_gap_absence_plans gap
182: WHERE hrl.lookup_type = p_lookup_type --'PQP_GAP_PLAN_TYPES_TO_EXTEND'
183: and (p_period_start_date between
184: NVL(hrl.start_date_active, p_period_start_date)