DBA Data[Home] [Help]

APPS.PAY_NO_ARC_HOLIDAY_ENTITLEMENT dependencies on HR_ASSIGNMENT_SET_AMENDMENTS_V

Line 204: HR_ASSIGNMENT_SET_AMENDMENTS_V hasav,

200: AND paaf.effective_end_date
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

Line 344: HR_ASSIGNMENT_SET_AMENDMENTS_V hasav,

340: AND csr_v_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
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