DBA Data[Home] [Help]

APPS.OKL_CURE_WF dependencies on PO_VENDORS

Line 144: po_vendors pov

140: cursor c_get_ref_details (p_cure_report_id IN NUMBER)
141: is select crt.report_number
142: ,pov.vendor_name
143: from okl_cure_reports crt,
144: po_vendors pov
145: where crt.vendor_id =pov.vendor_id
146: and crt.cure_report_id =p_cure_report_id;
147:
148: l_report_number okl_cure_reports.report_number%TYPE;

Line 150: l_vendor_name po_vendors.vendor_name%TYPE;

146: and crt.cure_report_id =p_cure_report_id;
147:
148: l_report_number okl_cure_reports.report_number%TYPE;
149:
150: l_vendor_name po_vendors.vendor_name%TYPE;
151: l_notification_agent varchar2(100);
152:
153: cursor c_get_agent(p_user_id IN NUMBER) is
154: select wfr.name