DBA Data[Home] [Help]

APPS.IRC_COMMUNICATIONS_API dependencies on IRC_COMM_TOPICS

Line 1473: Cursor cur_vac_id(p_topic_id irc_comm_topics.communication_topic_id%TYPE) is

1469: -- ----------------------------------------------------------------------------
1470: --
1471: function get_rcpt_list(p_object_id IN number,filter varchar2 ) return varchar2 is
1472: --
1473: Cursor cur_vac_id(p_topic_id irc_comm_topics.communication_topic_id%TYPE) is
1474: --get vacancy_id from topic_id
1475: select icp.object_id
1476: from
1477: irc_comm_properties icp,

Line 1479: irc_comm_topics ict

1475: select icp.object_id
1476: from
1477: irc_comm_properties icp,
1478: irc_communications ic,
1479: irc_comm_topics ict
1480: where
1481: ict.communication_topic_id = p_topic_id
1482: and ic.communication_id = ict.communication_id
1483: and icp.communication_property_id = ic.communication_property_id

Line 1503: Cursor cur_apl(p_topic_id irc_comm_topics.communication_topic_id%TYPE) is

1499: irc_rec_team_members team
1500: where
1501: team.vacancy_id = p_vacancy_id;
1502: --
1503: Cursor cur_apl(p_topic_id irc_comm_topics.communication_topic_id%TYPE) is
1504: --get applicant for application attached to the given topic
1505: select paf.person_id
1506: from
1507: per_all_assignments_f paf,

Line 1509: irc_comm_topics ict

1505: select paf.person_id
1506: from
1507: per_all_assignments_f paf,
1508: irc_communications ic,
1509: irc_comm_topics ict
1510: where
1511: ict.communication_topic_id = p_topic_id
1512: and ic.communication_id = ict.communication_id
1513: and paf.assignment_id = ic.object_id