APPS.JL_ZZ_AP_MONOTRIB_AWT_PKG dependencies on JL_ZZ_AP_SUPP_AWT_TYPES_S

Line 183: JL_ZZ_AP_SUPP_AWT_TYPES swt

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'
187: AND swt.wh_subject_flag = 'Y'

Line 543: SELECT jl_zz_ap_supp_awt_types_s.nextval

539: WHERE awt_type_code = c_rec.awt_type_code
540: AND vendor_id = P_Supplier_Id;
541:
542: IF v_flag = 0 THEN
543: SELECT jl_zz_ap_supp_awt_types_s.nextval
544: INTO v_supp_awt_type_id
545: FROM dual;
546: SELECT jl_zz_ap_sup_awt_cd_s.nextval
547: INTO v_supp_awt_code_id

Line 602: UPDATE JL_ZZ_AP_SUPP_AWT_TYPES SET WH_SUBJECT_FLAG = 'Y'

598: FND_FILE.put_line( FND_FILE.LOG, 'SUPPLIER APPLICABILITY UPDATED SUCCESSFULLY FOR SUPPLIER ID : '|| P_Supplier_Id);
599: END IF;
600:
601: ELSE
602: UPDATE JL_ZZ_AP_SUPP_AWT_TYPES SET WH_SUBJECT_FLAG = 'Y'
603: WHERE awt_type_code = c_rec.awt_type_code
604: AND vendor_id = P_Supplier_Id;
605:
606: SELECT SUPP_AWT_TYPE_ID INTO v_temp1

Line 744: FROM jl_zz_ap_supp_awt_types swt,

740: tca.global_attribute7, -- Zone
741: awt.jurisdiction_type,
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