DBA Data[Home] [Help]

APPS.ZX_AR_ACTG_POPULATE_PKG dependencies on HZ_PARTY_SITES

Line 2209: FROM HZ_PARTY_SITES PARTY_SITE,

2205: LOC.ADDRESS3,
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:

Line 2243: FROM HZ_PARTY_SITES PARTY_SITE,

2239:
2240:
2241: CURSOR migrated_party_site_cur ( c_cust_acct_site_id ZX_REP_TRX_DETAIL_T.BILLING_TP_ADDRESS_ID%TYPE) IS
2242: SELECT PARTY_SITE.party_site_id
2243: FROM HZ_PARTY_SITES PARTY_SITE,
2244: hz_cust_acct_sites_all acct_site
2245: WHERE acct_site.cust_acct_site_id = c_cust_acct_site_id
2246: AND party_site.party_site_id = acct_site. party_site_id;
2247:

Line 2680: FROM HZ_PARTY_SITES PARTY_SITE,

2676: LOC.ADDRESS3,
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: