DBA Data[Home] [Help]

APPS.IRC_COMMUNICATIONS_API dependencies on PO_VENDORS

Line 1542: Cursor cur_agency(l_recipient_id po_vendors.vendor_id%TYPE) is

1538: ppf.person_id = p_person_id
1539: and trunc(sysdate) between Effective_start_date and Effective_end_date;
1540: --
1541: --get agency name
1542: Cursor cur_agency(l_recipient_id po_vendors.vendor_id%TYPE) is
1543: select pov.vendor_name
1544: from
1545: po_vendors pov
1546: where

Line 1545: po_vendors pov

1541: --get agency name
1542: Cursor cur_agency(l_recipient_id po_vendors.vendor_id%TYPE) is
1543: select pov.vendor_name
1544: from
1545: po_vendors pov
1546: where
1547: pov.vendor_id = l_recipient_id;
1548: --
1549: l_list varchar2(32767);