DBA Data[Home] [Help]

APPS.JA_JAIN57F4_XMLP_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 94: V_EC_CODE JAI_CMN_VENDOR_SITES.EC_CODE%TYPE;

90: END BEFOREREPORT;
91:
92: FUNCTION CF_VENDOR_SITE_NAMEFORMULA(VENDOR_ID_v IN NUMBER
93: ,VENDOR_SITE_ID_v IN NUMBER) RETURN CHAR IS
94: V_EC_CODE JAI_CMN_VENDOR_SITES.EC_CODE%TYPE;
95: BEGIN
96: FOR c_fetch_ec_code IN (SELECT
97: EC_CODE
98: FROM

Line 99: JAI_CMN_VENDOR_SITES

95: BEGIN
96: FOR c_fetch_ec_code IN (SELECT
97: EC_CODE
98: FROM
99: JAI_CMN_VENDOR_SITES
100: WHERE VENDOR_ID = VENDOR_ID_v
101: AND VENDOR_SITE_ID = VENDOR_SITE_ID_v) LOOP
102: V_EC_CODE := C_FETCH_EC_CODE.EC_CODE;
103: END LOOP;