1208: BEGIN
1209:
1210: SELECT 'x'
1211: INTO l_dummy
1212: FROM gl_code_combinations
1213: WHERE code_combination_id = P_Rec_ccid;
1214:
1215:
1216: /****
1220:
1221: if (P_UBR_ccid is not null) then
1222: SELECT 'x'
1223: INTO l_dummy
1224: FROM gl_code_combinations
1225: WHERE code_combination_id = P_UBR_ccid;
1226: end if;
1227:
1228: if (P_UER_ccid is not null) then
1227:
1228: if (P_UER_ccid is not null) then
1229: SELECT 'x'
1230: INTO l_dummy
1231: FROM gl_code_combinations
1232: WHERE code_combination_id = P_UER_ccid;
1233: end if;
1234:
1235:
1235:
1236: if (P_WO_ccid is not null) then
1237: SELECT 'x'
1238: INTO l_dummy
1239: FROM gl_code_combinations
1240: WHERE code_combination_id = P_WO_ccid;
1241: end if;
1242:
1243:
1242:
1243:
1244: SELECT 'x'
1245: INTO l_dummy
1246: FROM gl_code_combinations
1247: WHERE code_combination_id = P_RND_ccid;
1248:
1249:
1250: /* Retention Enhancement : Validating the unbilled retention cc id */
1253: IF (P_ou_retn_acct_flag = 'Y') and (P_UNB_ret_ccid IS NOT NULL) THEN
1254:
1255: SELECT 'x'
1256: INTO l_dummy
1257: FROM gl_code_combinations
1258: WHERE code_combination_id = P_UNB_ret_ccid;
1259:
1260: END IF;
1261: