APPS.IEX_SCORE_CASE_PVT dependencies on IEX_BPD_CONTRACT_REMAINING_V

Line 45: -- from IEX_BPD_CONTRACT_REMAINING_V CON, IEX_CASES_VL CAS,

41:
42: cursor c_invamt(nCaseID NUMBER) IS
43: -- Begin fix bug #4932921-JYPARK-performance bug
44: -- select con.amount
45: -- from IEX_BPD_CONTRACT_REMAINING_V CON, IEX_CASES_VL CAS,
46: -- IEX_CASE_OBJECTS CAO
47: -- where CON.CONTRACT_ID = CAO.OBJECT_ID(+) AND
48: -- CAO.OBJECT_CODE(+) = 'CONTRACTS' AND
49: -- CAO.CAS_ID = CAS.CAS_ID(+) AND

Line 219: from IEX_BPD_CONTRACT_REMAINING_V

215:
216: -- begin raverma 04162003 -- trap no data found and assign 0 to Remaining amount
217: BEGIN
218: select amount into l_AmountOutstanding
219: from IEX_BPD_CONTRACT_REMAINING_V
220: where contract_id = l_ContractID;
221:
222: EXCEPTION
223: WHEN NO_DATA_FOUND THEN