[Home] [Help]
1137: SELECT
1138: AMOUNT
1139: INTO L_AUTHORIZED_AMOUNT
1140: FROM
1141: IBY_TRXN_SUMMARIES_ALL
1142: WHERE TANGIBLEID = L_TANGIBLE_ID
1143: AND REQTYPE = 'ORAPMTREQ';
1144: ELSE
1145: L_AUTHORIZED_AMOUNT := 0;
1239: SELECT
1240: AMOUNT
1241: INTO L_AUTHORIZED_AMOUNT
1242: FROM
1243: IBY_TRXN_SUMMARIES_ALL
1244: WHERE TANGIBLEID = L_TANGIBLE_ID
1245: AND REQTYPE = 'ORAPMTREQ';
1246: ELSE
1247: L_AUTHORIZED_AMOUNT := 0;