APPS.IRC_OFFER_NOTIFICATIONS_PKG dependencies on IRC_NOTES

Line 452: from irc_notes note

448: l_intial_set_lang varchar2(40);
449: --
450: cursor csr_offer_notes (p_offer_status_history_id IN NUMBER) is
451: select note.note_text
452: from irc_notes note
453: where note.offer_status_history_id = p_offer_status_history_id
454: order by creation_date desc;
455:
456: --

Line 1412: from irc_notes note

1408: l_ref_lang varchar2(40);
1409: --
1410: cursor csr_offer_notes (p_offer_status_history_id IN NUMBER) is
1411: select note.note_text
1412: from irc_notes note
1413: where note.offer_status_history_id = p_offer_status_history_id
1414: order by creation_date desc;
1415: --
1416: cursor csr_get_decline_reason (p_decline_reason IN VARCHAR2) is

Line 1975: from irc_notes note

1971: l_intial_set_lang varchar2(40);
1972: --
1973: cursor csr_offer_notes (p_offer_status_history_id IN NUMBER) is
1974: select note.note_text
1975: from irc_notes note
1976: where note.offer_status_history_id = p_offer_status_history_id
1977: order by creation_date desc;
1978: --
1979: cursor csr_get_withdrawal_reason (p_withdrawal_reason IN VARCHAR2) is

Line 2350: from irc_notes note

2346: l_intial_set_lang varchar2(40);
2347: --
2348: cursor csr_offer_notes (p_offer_status_history_id IN NUMBER) is
2349: select note.note_text
2350: from irc_notes note
2351: where note.offer_status_history_id = p_offer_status_history_id
2352: order by creation_date desc;
2353: --
2354: cursor csr_get_decline_reason (p_decline_reason IN VARCHAR2) is