APPS.JL_ZZ_AP_MONOTRIB_AWT_PKG dependencies on JL_ZZ_AP_SUP_AWT_CD

Line 546: SELECT jl_zz_ap_sup_awt_cd_s.nextval

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
548: FROM dual;
549:
550: ---- Inserting into Supplier Applicability table

Line 572: INSERT INTO JL_ZZ_AP_SUP_AWT_CD_ALL (SUPP_AWT_CODE_ID,

568: v_last_update_login
569: );
570:
571: ---- Defaulting Tax Code for Special AWT Type
572: INSERT INTO JL_ZZ_AP_SUP_AWT_CD_ALL (SUPP_AWT_CODE_ID,
573: SUPP_AWT_TYPE_ID,
574: TAX_ID,
575: PRIMARY_TAX_FLAG,
576: CREATED_BY,

Line 612: UPDATE JL_ZZ_AP_SUP_AWT_CD SET PRIMARY_TAX_FLAG = 'N'

608: WHERE awt_type_code = c_rec.awt_type_code
609: AND vendor_id = P_Supplier_Id
610: AND ROWNUM = 1;
611:
612: UPDATE JL_ZZ_AP_SUP_AWT_CD SET PRIMARY_TAX_FLAG = 'N'
613: WHERE SUPP_AWT_TYPE_ID = v_temp1;
614:
615: SELECT count(*) INTO v_temp2
616: FROM JL_ZZ_AP_SUP_AWT_CD

Line 616: FROM JL_ZZ_AP_SUP_AWT_CD

612: UPDATE JL_ZZ_AP_SUP_AWT_CD SET PRIMARY_TAX_FLAG = 'N'
613: WHERE SUPP_AWT_TYPE_ID = v_temp1;
614:
615: SELECT count(*) INTO v_temp2
616: FROM JL_ZZ_AP_SUP_AWT_CD
617: WHERE TAX_ID = v_tax_id
618: AND SUPP_AWT_TYPE_ID = v_temp1;
619:
620: IF v_temp2 > 0 THEN

Line 621: UPDATE JL_ZZ_AP_SUP_AWT_CD SET PRIMARY_TAX_FLAG = 'Y'

617: WHERE TAX_ID = v_tax_id
618: AND SUPP_AWT_TYPE_ID = v_temp1;
619:
620: IF v_temp2 > 0 THEN
621: UPDATE JL_ZZ_AP_SUP_AWT_CD SET PRIMARY_TAX_FLAG = 'Y'
622: WHERE TAX_ID = v_tax_id
623: AND SUPP_AWT_TYPE_ID = v_temp1;
624: ELSE
625: SELECT jl_zz_ap_sup_awt_cd_s.nextval

Line 625: SELECT jl_zz_ap_sup_awt_cd_s.nextval

621: UPDATE JL_ZZ_AP_SUP_AWT_CD SET PRIMARY_TAX_FLAG = 'Y'
622: WHERE TAX_ID = v_tax_id
623: AND SUPP_AWT_TYPE_ID = v_temp1;
624: ELSE
625: SELECT jl_zz_ap_sup_awt_cd_s.nextval
626: INTO v_supp_awt_code_id
627: FROM dual;
628: INSERT INTO JL_ZZ_AP_SUP_AWT_CD_ALL(SUPP_AWT_CODE_ID,
629: SUPP_AWT_TYPE_ID,

Line 628: INSERT INTO JL_ZZ_AP_SUP_AWT_CD_ALL(SUPP_AWT_CODE_ID,

624: ELSE
625: SELECT jl_zz_ap_sup_awt_cd_s.nextval
626: INTO v_supp_awt_code_id
627: FROM dual;
628: INSERT INTO JL_ZZ_AP_SUP_AWT_CD_ALL(SUPP_AWT_CODE_ID,
629: SUPP_AWT_TYPE_ID,
630: TAX_ID,
631: PRIMARY_TAX_FLAG,
632: CREATED_BY,

Line 745: jl_zz_ap_sup_awt_cd swc,

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
749: AND swt.wh_subject_flag = 'Y' -- Supp subject to the withholding tax type