DBA Data[Home] [Help]

APPS.JA_JAINPRRG_XMLP_PKG dependencies on PO_VENDORS

Line 72: V_VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE;

68:
69: END P_ORG_ADDR1VALIDTRIGGER;
70:
71: FUNCTION CF_VENDOR_NAMEFORMULA(VENDOR_ID IN NUMBER) RETURN CHAR IS
72: V_VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE;
73: CURSOR C_VENDOR_NAME(P_VENDOR_ID IN NUMBER) IS
74: SELECT
75: VENDOR_NAME
76: FROM

Line 77: PO_VENDORS

73: CURSOR C_VENDOR_NAME(P_VENDOR_ID IN NUMBER) IS
74: SELECT
75: VENDOR_NAME
76: FROM
77: PO_VENDORS
78: WHERE VENDOR_ID = P_VENDOR_ID;
79: BEGIN
80: OPEN C_VENDOR_NAME(VENDOR_ID);
81: FETCH C_VENDOR_NAME