40:
41: pr_site_use_rec pr_site_use_rec_type;
42:
43: TYPE pr_site_loc_rec_type is RECORD(
44: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
45: STATE HZ_LOCATIONS.STATE%TYPE,
46: COUNTY HZ_LOCATIONS.COUNTY%TYPE,
47: PROVINCE HZ_LOCATIONS.PROVINCE%TYPE,
48: CITY HZ_LOCATIONS.CITY%TYPE,
41: pr_site_use_rec pr_site_use_rec_type;
42:
43: TYPE pr_site_loc_rec_type is RECORD(
44: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
45: STATE HZ_LOCATIONS.STATE%TYPE,
46: COUNTY HZ_LOCATIONS.COUNTY%TYPE,
47: PROVINCE HZ_LOCATIONS.PROVINCE%TYPE,
48: CITY HZ_LOCATIONS.CITY%TYPE,
49: CUST_ACCT_SITE_ID HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE);
42:
43: TYPE pr_site_loc_rec_type is RECORD(
44: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
45: STATE HZ_LOCATIONS.STATE%TYPE,
46: COUNTY HZ_LOCATIONS.COUNTY%TYPE,
47: PROVINCE HZ_LOCATIONS.PROVINCE%TYPE,
48: CITY HZ_LOCATIONS.CITY%TYPE,
49: CUST_ACCT_SITE_ID HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE);
50:
43: TYPE pr_site_loc_rec_type is RECORD(
44: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
45: STATE HZ_LOCATIONS.STATE%TYPE,
46: COUNTY HZ_LOCATIONS.COUNTY%TYPE,
47: PROVINCE HZ_LOCATIONS.PROVINCE%TYPE,
48: CITY HZ_LOCATIONS.CITY%TYPE,
49: CUST_ACCT_SITE_ID HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE);
50:
51: pr_site_loc_rec pr_site_loc_rec_type;
44: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
45: STATE HZ_LOCATIONS.STATE%TYPE,
46: COUNTY HZ_LOCATIONS.COUNTY%TYPE,
47: PROVINCE HZ_LOCATIONS.PROVINCE%TYPE,
48: CITY HZ_LOCATIONS.CITY%TYPE,
49: CUST_ACCT_SITE_ID HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE);
50:
51: pr_site_loc_rec pr_site_loc_rec_type;
52:
756: loc.CITY,
757: acct_site.CUST_ACCT_SITE_ID
758: from HZ_PARTY_SITES PARTY_SITE,
759: -- HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
760: HZ_LOCATIONS LOC,
761: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
762: WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID AND
763: LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID AND
764: -- LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID AND