eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_OFFER_NOTIFICATIONS_PKG dependencies on HR_LOOKUPS

Line 1418: from hr_lookups

1414: order by creation_date desc;
1415: --
1416: cursor csr_get_decline_reason (p_decline_reason IN VARCHAR2) is
1417: select meaning
1418: from hr_lookups
1419: where lookup_type = 'IRC_OFFER_DECLINE_REASON' and
1420: lookup_code = p_decline_reason;
1421: --
1422: cursor csr_get_apl_referrer_id (p_offer_id in number) is

Line 1981: from hr_lookups

1977: order by creation_date desc;
1978: --
1979: cursor csr_get_withdrawal_reason (p_withdrawal_reason IN VARCHAR2) is
1980: select meaning
1981: from hr_lookups
1982: where lookup_type = 'IRC_OFFER_WITHDRAWAL_REASON' and
1983: lookup_code = p_withdrawal_reason;
1984: --
1985: cursor csr_get_prev_offer_details (p_offer_status_history_id IN NUMBER,p_offer_id IN NUMBER) is

Line 2356: from hr_lookups

2352: order by creation_date desc;
2353: --
2354: cursor csr_get_decline_reason (p_decline_reason IN VARCHAR2) is
2355: select meaning
2356: from hr_lookups
2357: where lookup_type = 'IRC_OFFER_DECLINE_REASON' and
2358: lookup_code = p_decline_reason;
2359: --
2360: cursor csr_get_prev_offer_details (p_offer_status_history_id IN NUMBER,p_offer_id IN NUMBER) is