DBA Data[Home] [Help]

APPS.JA_JAIN23D_XMLP_PKG dependencies on HZ_CUST_ACCOUNTS

Line 15: HZ_CUST_ACCOUNTS HZCA,

11: ,1
12: ,255)
13: FROM
14: HZ_PARTIES E,
15: HZ_CUST_ACCOUNTS HZCA,
16: JAI_CMN_CUS_ADDRESSES F,
17: HZ_LOCATIONS G,
18: HZ_PARTY_SITES HZPS,
19: HZ_CUST_ACCT_SITES_ALL HZCAS,

Line 34: HZ_CUST_ACCOUNTS HZCA

30: SELECT
31: PARTY_NAME CUSTOMER_NAME
32: FROM
33: HZ_PARTIES HZP,
34: HZ_CUST_ACCOUNTS HZCA
35: WHERE HZP.PARTY_ID = HZCA.PARTY_ID
36: AND HZCA.CUST_ACCOUNT_ID = P_CUSTOMER_ID;
37: CURSOR C_VEND_ADDRESS(P_VENDOR_ID IN NUMBER,P_VENDOR_SITE_ID IN NUMBER) IS
38: SELECT

Line 98: HZ_CUST_ACCOUNTS HZCA,

94: ,1
95: ,255)
96: FROM
97: HZ_PARTIES E,
98: HZ_CUST_ACCOUNTS HZCA,
99: JAI_CMN_CUS_ADDRESSES F,
100: HZ_LOCATIONS G,
101: HZ_PARTY_SITES HZPS,
102: HZ_CUST_ACCT_SITES_ALL HZCAS,

Line 206: HZ_CUST_ACCOUNTS HZCA,

202: ,1
203: ,255)
204: FROM
205: HZ_PARTIES E,
206: HZ_CUST_ACCOUNTS HZCA,
207: JAI_CMN_CUS_ADDRESSES F,
208: HZ_LOCATIONS G,
209: HZ_PARTY_SITES HZPS,
210: HZ_CUST_ACCT_SITES_ALL HZCAS,

Line 465: HZ_CUST_ACCOUNTS HZCA,

461: ,1
462: ,255)
463: FROM
464: HZ_PARTIES E,
465: HZ_CUST_ACCOUNTS HZCA,
466: JAI_CMN_CUS_ADDRESSES F,
467: HZ_LOCATIONS G,
468: HZ_PARTY_SITES HZPS,
469: HZ_CUST_ACCT_SITES_ALL HZCAS,