APPS.JL_ZZ_AP_AWT_DEFAULT_PKG dependencies on DUAL

Line 85: FROM dual;

81:
82: -- Select next value from the sequence.
83: SELECT jl_zz_ap_inv_dis_wh_s.nextval
84: INTO Seq_Inv_Dis_Awt_Id
85: FROM dual;
86:
87: --
88: -- Insert into JL_ZZ_AP_INV_DIS_WH_ALL
89: --

Line 356: from DUAL;

352: and wh_agent_flag = 'Y'
353: and awt_type_code = P_Awt_Type_Code)
354: and ROWNUM=1), 'TRUE', 'TRUE','FALSE')
355: into V_FND_TYPE
356: from DUAL;
357:
358: IF (V_FND_TYPE = 'TRUE') THEN find_type := TRUE;
359: ELSE find_type := FALSE;
360: END IF;

Line 1468: From dual;

1464: l_invoice_type_lookup_code := C_Inv_Rec.invoice_type_lookup_code;
1465:
1466: Select JG_ZZ_SHARED_PKG.GET_COUNTRY(l_org_id, null)
1467: Into l_country_code
1468: From dual;
1469:
1470: If (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) Then
1471: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Upd_Dist_Gdf','Org Id : ' || l_org_id);
1472: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Upd_Dist_Gdf','Invoice Type Lookup Code : '||l_invoice_type_lookup_code);