DBA Data[Home] [Help]

APPS.IRC_CMR_BUS dependencies on PER_ALL_PEOPLE_F

Line 361: l_recipient_id per_all_people_f.person_id%type;

357: p_communication_object_id in irc_comm_recipients.communication_object_id%type
358: ) is
359: --
360: l_proc varchar2(72) := g_package||'chk_recipient';
361: l_recipient_id per_all_people_f.person_id%type;
362: --
363: cursor csr_recipient_person is
364: select person_id
365: from per_all_people_f

Line 365: from per_all_people_f

361: l_recipient_id per_all_people_f.person_id%type;
362: --
363: cursor csr_recipient_person is
364: select person_id
365: from per_all_people_f
366: where person_id = p_recipient_id;
367: --
368: cursor csr_recipient_agency is
369: select vendor_id