APPS.ZX_TDS_PROCESS_CEC_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 37: tax_classification hz_cust_site_uses_all.tax_classification%type,

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

Line 38: cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%type,

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

Line 39: site_use_id hz_cust_site_uses_all.site_use_id%type);

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

Line 49: CUST_ACCT_SITE_ID HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%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:
53: TYPE pr_org_loc_rec_type is RECORD(

Line 748: from HZ_CUST_SITE_USES_ALL site

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

Line 914: FROM HZ_CUST_SITE_USES_ALL SU,

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