APPS.JL_ZZ_AP_MONOTRIB_AWT_PKG dependencies on DUAL

Line 17: NVL(individual_1099,num_1099)||'-'||global_attribute12 taxpayer_id,

13:
14: CURSOR MonoTrib_Suppliers (p_supplier_id NUMBER) IS
15: SELECT vendor_name supplier_name,
16: vendor_id supplier_id,
17: NVL(individual_1099,num_1099)||'-'||global_attribute12 taxpayer_id,
18: global_attribute8 simplif_regime_cont_type
19: FROM ap_suppliers
20: WHERE global_attribute1 = '06'
21: AND global_attribute8 IN ('GOODS','SERVICES')

Line 545: FROM dual;

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
548: FROM dual;
549:

Line 548: FROM dual;

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
551: INSERT INTO JL_ZZ_AP_SUPP_AWT_TYPES (SUPP_AWT_TYPE_ID,
552: VENDOR_ID,

Line 627: FROM dual;

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,
630: TAX_ID,
631: PRIMARY_TAX_FLAG,