DBA Data[Home] [Help]

APPS.IRC_OFFERS_API dependencies on HR_GENERAL

Line 1395: AND decode(hr_general.get_xbg_profile,'Y', otherasg.business_group_id , hr_general.get_business_group_id) = otherasg.business_group_id

1391: AND per.person_id = l_person_id
1392: AND linkper.party_id = per.party_id
1393: AND otheroffer.latest_offer = 'Y'
1394: AND otheroffer.applicant_assignment_id <> nvl(p_applicant_assignment_id, -1)
1395: AND decode(hr_general.get_xbg_profile,'Y', otherasg.business_group_id , hr_general.get_business_group_id) = otherasg.business_group_id
1396: AND otherhistory.offer_status_history_id = (select max(offer_status_history_id)
1397: from irc_offer_status_history
1398: where offer_id = otheroffer.offer_id );
1399: --