APPS.IRC_OFFER_NOTIFICATIONS_PKG dependencies on IRC_NOTES

Line 312: from irc_notes note

308: l_proc varchar2(30) default '.send_rcvd_wf_notification';
309: --
310: cursor csr_offer_notes (p_offer_status_history_id IN NUMBER) is
311: select note.note_text
312: from irc_notes note
313: where note.offer_status_history_id = p_offer_status_history_id
314: order by creation_date desc;
315:
316: --

Line 914: from irc_notes note

910: l_proc varchar2(30) default '.send_applicant_response';
911: --
912: cursor csr_offer_notes (p_offer_status_history_id IN NUMBER) is
913: select note.note_text
914: from irc_notes note
915: where note.offer_status_history_id = p_offer_status_history_id
916: order by creation_date desc;
917: --
918: cursor csr_get_decline_reason (p_decline_reason IN VARCHAR2) is

Line 1354: from irc_notes note

1350: l_proc varchar2(30) default '.send_withdrawal_notification';
1351: --
1352: cursor csr_offer_notes (p_offer_status_history_id IN NUMBER) is
1353: select note.note_text
1354: from irc_notes note
1355: where note.offer_status_history_id = p_offer_status_history_id
1356: order by creation_date desc;
1357: --
1358: cursor csr_get_withdrawal_reason (p_withdrawal_reason IN VARCHAR2) is

Line 1660: from irc_notes note

1656: l_proc varchar2(30) default '.send_dcln_acptd_offer_notif';
1657: --
1658: cursor csr_offer_notes (p_offer_status_history_id IN NUMBER) is
1659: select note.note_text
1660: from irc_notes note
1661: where note.offer_status_history_id = p_offer_status_history_id
1662: order by creation_date desc;
1663: --
1664: cursor csr_get_decline_reason (p_decline_reason IN VARCHAR2) is