APPS.IEX_SCORE_CASE_PVT dependencies on IEX_CASE_OBJECTS

Line 30: FROM IEX_CASE_OBJECTS

26: --
27: Function Calculate_Score(p_case_id IN NUMBER, p_score_component_id IN NUMBER) RETURN NUMBER IS
28: cursor c_caseobj(nCaseID NUMBER) IS
29: SELECT object_id
30: FROM IEX_CASE_OBJECTS
31: where CAS_ID = nCaseID;
32:
33: -- begin raverma 04172003
34: -- change join from IEX_CASES_ALL_B to IEX_CASES_VL

Line 46: -- IEX_CASE_OBJECTS CAO

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
50: -- CAS.CAS_ID = nCaseID AND

Line 57: IEX_CASE_OBJECTS CAO

53: FROM
54: AR_PAYMENT_SCHEDULES PS,
55: OKL_CNSLD_AR_STRMS_B ST,
56: OKC_K_HEADERS_B KH,
57: IEX_CASE_OBJECTS CAO
58: WHERE
59: PS.CUSTOMER_TRX_ID = ST.RECEIVABLES_INVOICE_ID
60: AND KH.ID = ST.KHR_ID
61: AND CAO.object_id =KH.ID