APPS.JL_ZZ_AP_MONOTRIB_AWT_PKG dependencies on JL_ZZ_AP_AWT_TYPES

Line 182: FROM JL_ZZ_AP_AWT_TYPES awt,

178: -----------------------------------------------------------------------------------------------------------
179: BEGIN
180: SELECT 1
181: INTO v_flag
182: FROM JL_ZZ_AP_AWT_TYPES awt,
183: JL_ZZ_AP_SUPP_AWT_TYPES swt
184: WHERE swt.vendor_id = c_supp_rec(i_supp).SUPPLIER_ID
185: AND swt.awt_type_code = awt.awt_type_code
186: AND awt.simplified_regime_flag = 'Y'

Line 495: FROM JL_ZZ_AP_AWT_TYPES

491: Applicability_Chngd_flag OUT NOCOPY VARCHAR2)
492: IS
493: CURSOR awt_types IS
494: SELECT awt_type_code, description, supplier_exempt_level, multilat_contrib_flag
495: FROM JL_ZZ_AP_AWT_TYPES
496: WHERE Simplified_Regime_Flag = 'Y'
497: AND nvl(start_date_active, sysdate) <= sysdate
498: AND nvl(end_date_active, sysdate) >= sysdate;
499:

Line 747: jl_zz_ap_awt_types awt

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
751: AND swc.tax_id = tca.tax_id -- Join