APPS.JL_ZZ_AP_MONOTRIB_AWT_PKG dependencies on AP_TAX_CODES

Line 526: FROM AP_TAX_CODES

522:
523: FOR c_rec IN awt_types LOOP
524: SELECT tax_id, name
525: INTO v_tax_id, v_tax_name
526: FROM AP_TAX_CODES
527: WHERE global_attribute4 = c_rec.awt_type_code
528: AND inactive_date IS NULL
529: AND creation_date >= ( SELECT max(creation_date)
530: FROM AP_TAX_CODES --bug 14274573

Line 530: FROM AP_TAX_CODES --bug 14274573

526: FROM AP_TAX_CODES
527: WHERE global_attribute4 = c_rec.awt_type_code
528: AND inactive_date IS NULL
529: AND creation_date >= ( SELECT max(creation_date)
530: FROM AP_TAX_CODES --bug 14274573
531: WHERE global_attribute4 = c_rec.awt_type_code
532: AND inactive_date IS NULL
533: )
534: AND ROWNUM = 1;

Line 746: ap_tax_codes tca,

742: awt.province_code,
743: awt.city_code
744: FROM jl_zz_ap_supp_awt_types swt,
745: jl_zz_ap_sup_awt_cd swc,
746: ap_tax_codes tca,
747: jl_zz_ap_awt_types awt
748: WHERE swt.vendor_id = C_vendor_id -- Select only for this Supplier
749: AND swt.wh_subject_flag = 'Y' -- Supp subject to the withholding tax type
750: AND swc.supp_awt_type_id = swt.supp_awt_type_id -- Join

Line 836: -- The name of the zone is taken from AP_TAX_CODES Global Att 7

832:
833: END IF; -- PROVINCE Class
834: ELSIF db_reg.jurisdiction_type = 'ZONAL' THEN
835: ---------------------------------------------------------------
836: -- The name of the zone is taken from AP_TAX_CODES Global Att 7
837: ---------------------------------------------------------------
838: IF db_reg.global_attribute7 = v_hr_zone THEN
839: FND_FILE.put_line( FND_FILE.LOG, 'INSIDE "Monotrib_Wh_Def_Line" PROCEDURE - ZONAL Before Insert');
840: JL_ZZ_AP_AWT_DEFAULT_PKG.Insert_AWT_Default