APPS.IRC_OFFER_NOTIFICATIONS_PKG dependencies on HR_LOOKUPS

Line 920: from hr_lookups

916: order by creation_date desc;
917: --
918: cursor csr_get_decline_reason (p_decline_reason IN VARCHAR2) is
919: select meaning
920: from hr_lookups
921: where lookup_type = 'IRC_OFFER_DECLINE_REASON' and
922: lookup_code = p_decline_reason;
923: --
924: cursor csr_get_apl_referrer_id (p_offer_id in number) is

Line 1360: from hr_lookups

1356: order by creation_date desc;
1357: --
1358: cursor csr_get_withdrawal_reason (p_withdrawal_reason IN VARCHAR2) is
1359: select meaning
1360: from hr_lookups
1361: where lookup_type = 'IRC_OFFER_WITHDRAWAL_REASON' and
1362: lookup_code = p_withdrawal_reason;
1363: --
1364: cursor csr_get_prev_offer_details (p_offer_status_history_id IN NUMBER,p_offer_id IN NUMBER) is

Line 1666: from hr_lookups

1662: order by creation_date desc;
1663: --
1664: cursor csr_get_decline_reason (p_decline_reason IN VARCHAR2) is
1665: select meaning
1666: from hr_lookups
1667: where lookup_type = 'IRC_OFFER_DECLINE_REASON' and
1668: lookup_code = p_decline_reason;
1669: --
1670: cursor csr_get_prev_offer_details (p_offer_status_history_id IN NUMBER,p_offer_id IN NUMBER) is