APPS.ZX_AR_ACTG_POPULATE_PKG dependencies on HZ_PARTIES

Line 2195: FROM HZ_PARTIES PARTY

2191: 'ORGANIZATION',
2192: PARTY.SIC_CODE,
2193: NULL) ,
2194: PARTY.PARTY_NUMBER
2195: FROM HZ_PARTIES PARTY
2196: WHERE PARTY.PARTY_ID = c_party_id;
2197:
2198: CURSOR party_site_cur ( c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS
2199: select LOC.CITY,

Line 2235: FROM HZ_PARTIES PARTY,

2231: and site_use.site_use_code = c_ship_bill;
2232:
2233: CURSOR migrated_party_cur (c_cust_acct_id ZX_REP_TRX_DETAIL_T.BILLING_TRADING_PARTNER_ID%TYPE) IS
2234: SELECT party.party_id
2235: FROM HZ_PARTIES PARTY,
2236: hz_cust_accounts acct
2237: WHERE PARTY.PARTY_ID = acct.party_id
2238: And acct.cust_account_id = c_cust_acct_id;
2239:

Line 2666: FROM HZ_PARTIES PARTY

2662: NULL) ,
2663: PARTY.PARTY_NUMBER,
2664: PARTY.JGZZ_FISCAL_CODE,
2665: PARTY.TAX_REFERENCE
2666: FROM HZ_PARTIES PARTY
2667: WHERE PARTY.PARTY_ID = c_party_id;
2668:
2669: CURSOR party_site_cur ( c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS
2670: select LOC.CITY,