DBA Data[Home] [Help]

APPS.IRC_OFFERS_API dependencies on HR_GENERAL

Line 1492: AND decode(hr_general.get_xbg_profile,'Y', otherasg.business_group_id , hr_general.get_business_group_id) = otherasg.business_group_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
1496: FROM irc_offer_status_history iosh1