APPS.PAY_NO_ARC_HOLIDAY_ENTITLEMENT dependencies on HR_ASSIGNMENT_SETS_V

Line 205: HR_ASSIGNMENT_SETS_V hasv

201: AND (csr_v_assignment_set_id is null
202: or exists(select hasav.assignment_id
203: from
204: HR_ASSIGNMENT_SET_AMENDMENTS_V hasav,
205: HR_ASSIGNMENT_SETS_V hasv
206: where
207: hasav.assignment_set_id = hasv.assignment_set_id
208: and hasv.assignment_set_id = csr_v_assignment_set_id
209: and hasav.assignment_id = paaf.assignment_id));

Line 345: HR_ASSIGNMENT_SETS_V hasv

341: AND (csr_v_assignment_set_id is null
342: or exists(select hasav.assignment_id
343: from
344: HR_ASSIGNMENT_SET_AMENDMENTS_V hasav,
345: HR_ASSIGNMENT_SETS_V hasv
346: where
347: hasav.assignment_set_id = hasv.assignment_set_id
348: and hasv.assignment_set_id = csr_v_assignment_set_id
349: and hasav.assignment_id = paaf.assignment_id));