APPS.IRC_OFFER_NOTIFICATIONS_PKG dependencies on PER_VAC_LINKED_ASSIGNMENTS

Line 277: select src_apl_asg_id from per_vac_linked_assignments

273: AND application_id = apl_id;
274: --
275: CURSOR csr_get_src_assignment
276: IS
277: select src_apl_asg_id from per_vac_linked_assignments
278: where tgt_apl_asg_id = p_apl_asg_id
279: and sysdate between nvl(start_date,sysdate) and
280: nvl(end_date,sysdate) ;
281: BEGIN

Line 337: select src_apl_asg_id from per_vac_linked_assignments

333: where function_name = p_function_name;
334: --
335: CURSOR csr_get_src_assignment
336: IS
337: select src_apl_asg_id from per_vac_linked_assignments
338: where tgt_apl_asg_id = p_apl_asg_id
339: and sysdate between nvl(start_date,sysdate) and
340: nvl(end_date,sysdate) ;
341: --