APPS.IEX_CO_TRANSFER_EA_PVT dependencies on OKL_OPEN_INT

Line 98: FROM OKL_OPEN_INT

94:
95: BEGIN
96: SELECT external_agency_transfer_date
97: INTO l_date
98: FROM OKL_OPEN_INT
99: WHERE cas_id = p_cas_id
100: AND external_agency_transfer_date IS NOT NULL
101: AND rownum = 1;
102:

Line 113: FROM OKL_OPEN_INT a,

109: BEGIN
110: l_date := null;
111: SELECT trunc(b.review_date)
112: INTO l_date
113: FROM OKL_OPEN_INT a,
114: IEX_OPEN_INT_HST b
115: WHERE a.cas_id = p_cas_id
116: AND a.khr_id = to_number(b.object1_id1)
117: AND b.action = 'TRANSFER_EXT_AGNCY'

Line 130: FROM OKL_OPEN_INT a,

126:
127: BEGIN
128: SELECT c.external_agency_name
129: INTO l_ext_agncy_name
130: FROM OKL_OPEN_INT a,
131: IEX_OPEN_INT_HST b,
132: IEX_EXT_AGNCY_B c
133: WHERE a.cas_id = p_cas_id
134: AND a.khr_id = to_number(b.object1_id1)