APPS.JE_JEHUIAGE_XMLP_PKG dependencies on PO_VENDORS

Line 44: L_VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE;

40: L_SUMMARY_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
41: L_FORMAT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
42: L_NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
43: L_INVOICE_TYPE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
44: L_VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE;
45: BEGIN
46: /*SRW.MESSAGE('260974'
47: ,'One')*/NULL;
48: BEGIN

Line 119: PO_VENDORS

115: SELECT
116: VENDOR_NAME
117: INTO L_VENDOR_NAME
118: FROM
119: PO_VENDORS
120: WHERE VENDOR_ID = P_VENDOR_ID;
121: C_VENDOR_NAME_SELECT := L_VENDOR_NAME;
122: C_HEAD_VENDOR_NAME := L_VENDOR_NAME;
123: P_VENDOR_PREDICATE := 'AND V.vendor_id = ' || P_VENDOR_ID;