APPS.ZX_TDS_PROCESS_CEC_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 36: tax_classification hz_cust_site_uses_all.tax_classification%type,

32: -------------------------------------------------
33: -- Creating Table structure for Statistics info
34: ------------------------------------------------
35: TYPE pr_site_use_rec_type is RECORD(
36: tax_classification hz_cust_site_uses_all.tax_classification%type,
37: cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%type,
38: site_use_id hz_cust_site_uses_all.site_use_id%type);
39:
40: pr_site_use_rec pr_site_use_rec_type;

Line 37: cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%type,

33: -- Creating Table structure for Statistics info
34: ------------------------------------------------
35: TYPE pr_site_use_rec_type is RECORD(
36: tax_classification hz_cust_site_uses_all.tax_classification%type,
37: cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%type,
38: site_use_id hz_cust_site_uses_all.site_use_id%type);
39:
40: pr_site_use_rec pr_site_use_rec_type;
41:

Line 38: site_use_id hz_cust_site_uses_all.site_use_id%type);

34: ------------------------------------------------
35: TYPE pr_site_use_rec_type is RECORD(
36: tax_classification hz_cust_site_uses_all.tax_classification%type,
37: cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%type,
38: site_use_id hz_cust_site_uses_all.site_use_id%type);
39:
40: pr_site_use_rec pr_site_use_rec_type;
41:
42: TYPE pr_site_loc_rec_type is RECORD(

Line 48: CUST_ACCT_SITE_ID HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE);

44: STATE HZ_LOCATIONS.STATE%TYPE,
45: COUNTY HZ_LOCATIONS.COUNTY%TYPE,
46: PROVINCE HZ_LOCATIONS.PROVINCE%TYPE,
47: CITY HZ_LOCATIONS.CITY%TYPE,
48: CUST_ACCT_SITE_ID HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE);
49:
50: pr_site_loc_rec pr_site_loc_rec_type;
51:
52: TYPE pr_org_loc_rec_type is RECORD(

Line 747: from HZ_CUST_SITE_USES_ALL site

743: cursor c_site_use_rec(c_site_use_id NUMBER) is
744: select site.TAX_CLASSIFICATION,
745: site.cust_acct_site_id,
746: site.site_use_id
747: from HZ_CUST_SITE_USES_ALL site
748: where site.site_use_id = c_site_use_id;
749:
750: cursor c_site_loc_rec(c_address_id number) is
751: select loc.COUNTRY,

Line 913: FROM HZ_CUST_SITE_USES_ALL SU,

909: and org.organization_id = g_cec_product_org_id;
910:
911: cursor get_vat_reg_num_site (c_site_use_id number) is
912: SELECT ZP.PARTY_TAX_PROFILE_ID,Upper(SU.TAX_REFERENCE)
913: FROM HZ_CUST_SITE_USES_ALL SU,
914: HZ_CUST_ACCT_SITES_ALL CAS,
915: HZ_PARTY_SITES PS,
916: ZX_PARTY_TAX_PROFILE ZP
917: WHERE SU.SITE_USE_ID = c_site_use_id AND