APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on HZ_CUST_ACCT_SITES

Line 534: l_cust_id hz_cust_acct_sites.cust_account_id%type;

530: p_ship_to_cust_id IN NUMBER DEFAULT NULL,
531: p_bill_to_cust_id IN NUMBER DEFAULT NULL) IS
532:
533: l_site_use_id NUMBER;
534: l_cust_id hz_cust_acct_sites.cust_account_id%type;
535:
536: CURSOR ship_bill (l_site_use_code varchar2,
537: l_site_use_id number,
538: l_cust_id number) IS

Line 558: HZ_CUST_ACCT_SITES ACCT_SITE,

554: NVL(SYS.TAX_ROUNDING_RULE, 'NEAREST'))),
555: NVL(SYS.TAX_ROUNDING_RULE, 'NEAREST')) TAX_ROUNDING_RULE
556: FROM HZ_PARTY_SITES PARTY_SITE,
557: HZ_LOCATIONS LOC,
558: HZ_CUST_ACCT_SITES ACCT_SITE,
559: HZ_CUST_SITE_USES SITE,
560: HZ_PARTIES PARTY,
561: HZ_CUST_ACCOUNTS CUST_ACCT,
562: AR_SYSTEM_PARAMETERS SYS

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

988:
989: -- ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4 will contain a value 'OE'/'AR' if calling
990: -- application is Order Management/Receivables respectively.
991: -- Assign this value locally, so that ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4 can be used
992: -- for storing value from HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE9 to check if
993: -- customer site profile has been overriden or not.
994: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 IN (1,2,3,4,5,8) THEN
995: l_application := 'AR';
996: ELSIF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern7 IN (6,7) THEN