DBA Data[Home] [Help]

APPS.ZX_AR_ACTG_POPULATE_PKG dependencies on HZ_LOCATIONS

Line 2210: HZ_LOCATIONS LOC

2206: LOC.ADDRESS_LINES_PHONETIC,
2207: LOC.COUNTRY,
2208: LOC.POSTAL_CODE
2209: FROM HZ_PARTY_SITES PARTY_SITE,
2210: HZ_LOCATIONS LOC
2211: WHERE party_site.party_site_id = c_party_site_id
2212: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
2213:
2214: CURSOR cust_acct_cur (c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE,

Line 2681: HZ_LOCATIONS LOC

2677: LOC.ADDRESS_LINES_PHONETIC,
2678: LOC.COUNTRY,
2679: LOC.POSTAL_CODE
2680: FROM HZ_PARTY_SITES PARTY_SITE,
2681: HZ_LOCATIONS LOC
2682: WHERE party_site.party_site_id = c_party_site_id
2683: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
2684:
2685: CURSOR cust_acct_cur (c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE,