APPS.IEX_CASE_INFO_PUB dependencies on IEX_CASE_OBJECTS

Line 32: 'FROM IEX_CASE_OBJECTS ' ||

28: END IF;
29: end if;
30:
31: vPLSQL := 'SELECT OBJECT_ID ' ||
32: 'FROM IEX_CASE_OBJECTS ' ||
33: ' WHERE CAS_ID = ' || to_char(p_case_id) ||
34: ' AND OBJECT_CODE = ''CONTRACTS''' ||
35: ' AND ACTIVE_FLAG = ''Y''';
36: open object_cur for vPLSQL;

Line 75: FROM IEX_CASE_OBJECTS

71: l_rcvble_amt NUMBER ;
72:
73: CURSOR c_case(l_case_id NUMBER) IS
74: SELECT OBJECT_ID
75: FROM IEX_CASE_OBJECTS
76: WHERE CAS_ID = l_case_id
77: AND OBJECT_CODE = 'CONTRACTS'
78: AND ACTIVE_FLAG = 'Y';
79:

Line 196: FROM IEX_CASE_OBJECTS

192: l_nbook_amt NUMBER ;
193:
194: CURSOR c_case(l_case_id NUMBER) IS
195: SELECT OBJECT_ID
196: FROM IEX_CASE_OBJECTS
197: WHERE CAS_ID = l_case_id
198: AND OBJECT_CODE = 'CONTRACTS'
199: AND ACTIVE_FLAG = 'Y';
200:

Line 299: FROM IEX_CASE_OBJECTS

295: l_api_name VARCHAR2(30);
296:
297: CURSOR c_case(l_case_id NUMBER) IS
298: SELECT OBJECT_ID
299: FROM IEX_CASE_OBJECTS
300: WHERE CAS_ID = l_case_id
301: AND OBJECT_CODE = 'CONTRACTS'
302: AND ACTIVE_FLAG = 'Y';
303:

Line 402: FROM IEX_CASE_OBJECTS

398: l_api_name VARCHAR2(30);
399:
400: CURSOR c_case(l_case_id NUMBER) IS
401: SELECT OBJECT_ID
402: FROM IEX_CASE_OBJECTS
403: WHERE CAS_ID = l_case_id
404: AND OBJECT_CODE = 'CONTRACTS'
405: AND ACTIVE_FLAG = 'Y';
406:

Line 507: FROM IEX_CASE_OBJECTS

503: l_api_name VARCHAR2(30);
504:
505: CURSOR c_case(l_case_id NUMBER) IS
506: SELECT OBJECT_ID
507: FROM IEX_CASE_OBJECTS
508: WHERE CAS_ID = l_case_id
509: AND OBJECT_CODE = 'CONTRACTS'
510: AND ACTIVE_FLAG = 'Y';
511:

Line 607: FROM IEX_CASE_OBJECTS

603: l_api_name VARCHAR2(30);
604:
605: CURSOR c_case(l_case_id NUMBER) IS
606: SELECT OBJECT_ID
607: FROM IEX_CASE_OBJECTS
608: WHERE CAS_ID = l_case_id
609: AND OBJECT_CODE = 'CONTRACTS'
610: AND ACTIVE_FLAG = 'Y';
611:

Line 720: ,iex_case_objects icas

716: select nvl(sum(okl.oec) ,0)
717: from okc_k_lines_v okc
718: ,okl_k_lines okl
719: ,okc_line_styles_v lse
720: ,iex_case_objects icas
721: where okc.id=okl.id
722: and okc.lse_id = lse.id
723: and lse.lty_code='FREE_FORM1'
724: and okc.chr_id =icas.object_id