512: p_sender_id in irc_comm_messages.sender_id%type
513: ) is
514: --
515: l_proc varchar2(72) := g_package||'chk_sender';
516: l_sender_id per_all_people_f.person_id%type;
517: --
518: cursor csr_sender is
519: select person_id
520: from per_all_people_f
516: l_sender_id per_all_people_f.person_id%type;
517: --
518: cursor csr_sender is
519: select person_id
520: from per_all_people_f
521: where person_id = p_sender_id;
522: --
523: cursor csr_sender_agency is
524: select vendor_id