APPS.IRC_OFFERS_API dependencies on PER_VAC_LINKED_ASSIGNMENTS

Line 427: from per_vac_linked_assignments

423: and BUSINESS_GROUP_ID = p_business_group_id));
424: --
425: cursor csr_linked_base_asg is
426: select src_apl_asg_id
427: from per_vac_linked_assignments
428: where tgt_apl_asg_id=p_applicant_assignment_id;
429: --
430: Begin
431: --

Line 1491: AND otheroffer.applicant_assignment_id <> nvl((select tgt_apl_asg_id from per_vac_linked_assignments where src_apl_asg_id=p_applicant_assignment_id and rownum<2), -1)

1487: AND per.person_id = l_person_id
1488: AND linkper.party_id = per.party_id
1489: AND otheroffer.latest_offer = 'Y'
1490: AND otheroffer.applicant_assignment_id <> nvl(p_applicant_assignment_id, -1)
1491: AND otheroffer.applicant_assignment_id <> nvl((select tgt_apl_asg_id from per_vac_linked_assignments where src_apl_asg_id=p_applicant_assignment_id and rownum<2), -1)
1492: AND decode(hr_general.get_xbg_profile,'Y', otherasg.business_group_id , hr_general.get_business_group_id) = otherasg.business_group_id
1493: AND otheroffer.offer_id = otherhistory.offer_id
1494: AND NOT EXISTS
1495: (SELECT 1

Line 1741: select tgt_apl_asg_id from per_vac_linked_assignments

1737: applicant_assignment_id = nvl(p_src_apl_asg_id,-1)
1738: OR
1739: applicant_assignment_id =
1740: (
1741: select tgt_apl_asg_id from per_vac_linked_assignments
1742: where src_apl_asg_id = p_src_apl_asg_id
1743: and sysdate between nvl(start_date,sysdate)
1744: and nvl(end_date,sysdate)
1745: )