APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on HZ_CUST_ACCT_SITES

Line 524: l_cust_id hz_cust_acct_sites.cust_account_id%type;

520: p_ship_to_cust_id IN NUMBER DEFAULT NULL,
521: p_bill_to_cust_id IN NUMBER DEFAULT NULL) IS
522:
523: l_site_use_id NUMBER;
524: l_cust_id hz_cust_acct_sites.cust_account_id%type;
525:
526: CURSOR ship_bill (l_site_use_code varchar2,
527: l_site_use_id number,
528: l_cust_id number) IS

Line 548: HZ_CUST_ACCT_SITES ACCT_SITE,

544: NVL(SYS.TAX_ROUNDING_RULE, 'NEAREST'))),
545: NVL(SYS.TAX_ROUNDING_RULE, 'NEAREST')) TAX_ROUNDING_RULE
546: FROM HZ_PARTY_SITES PARTY_SITE,
547: HZ_LOCATIONS LOC,
548: HZ_CUST_ACCT_SITES ACCT_SITE,
549: HZ_CUST_SITE_USES SITE,
550: HZ_PARTIES PARTY,
551: HZ_CUST_ACCOUNTS CUST_ACCT,
552: AR_SYSTEM_PARAMETERS SYS

Line 976: -- for storing value from HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE9 to check if

972:
973: -- ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4 will contain a value 'OE'/'AR' if calling
974: -- application is Order Management/Receivables respectively.
975: -- Assign this value locally, so that ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4 can be used
976: -- for storing value from HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE9 to check if
977: -- customer site profile has been overriden or not.
978: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 IN (1,2,3,4,5,8) THEN
979: l_application := 'AR';
980: ELSIF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 IN (6,7) THEN