APPS.IRC_COMMUNICATIONS_API dependencies on IRC_COMM_RECIPIENTS

Line 1524: Cursor cur_tpc_frm_rcpt(p_recipient_id irc_comm_recipients.recipient_id%TYPE) is

1520: irc_comm_messages msg
1521: where
1522: msg.communication_message_id = p_message_id;
1523: --
1524: Cursor cur_tpc_frm_rcpt(p_recipient_id irc_comm_recipients.recipient_id%TYPE) is
1525: --get topic_id from recipient_id
1526: select icr.communication_object_id
1527: from
1528: irc_comm_recipients icr

Line 1528: irc_comm_recipients icr

1524: Cursor cur_tpc_frm_rcpt(p_recipient_id irc_comm_recipients.recipient_id%TYPE) is
1525: --get topic_id from recipient_id
1526: select icr.communication_object_id
1527: from
1528: irc_comm_recipients icr
1529: where
1530: icr.communication_recipient_id = p_recipient_id
1531: and icr.communication_object_type = 'TOPIC';
1532: --

Line 1586: ' irc_comm_recipients icr'||

1582:
1583: --get recipients for a given topic_id
1584: query_str := ' select icr.recipient_id, icr.recipient_type' ||
1585: ' from' ||
1586: ' irc_comm_recipients icr'||
1587: ' where icr.communication_object_id = :1' ||
1588: ' and icr.communication_object_type= ''TOPIC''';
1589:
1590: ----------Fetch only selected recipients of a topic

Line 1619: ' irc_comm_recipients icr' ||

1615:
1616: query_str :=' select icr.recipient_id,icr.recipient_type' ||
1617: ' from' ||
1618: ' irc_comm_messages icm,' ||
1619: ' irc_comm_recipients icr' ||
1620: ' where' ||
1621: ' icm.communication_message_id= :1' ||
1622: ' and icr.communication_object_id = icm.communication_topic_id' ||
1623: ' and icr.communication_object_type = ''TOPIC''' ||

Line 1636: ' irc_comm_recipients icr' ||

1632:
1633: if filter = 'ROLE' then
1634: query_str :=' select icr.recipient_id,icr.recipient_type' ||
1635: ' from' ||
1636: ' irc_comm_recipients icr' ||
1637: ' where' ||
1638: ' icr.communication_recipient_id =:1';
1639: end if;
1640: -----------------------Recipient query making finish------------------------------