DBA Data[Home] [Help]

APPS.OZF_FUND_UTILIZED_PUB dependencies on OZF_CLAIM_TYPES_ALL_VL

Line 179: FROM ozf_claim_types_all_vl

175: AND concatenated_segments = p_prod_name; --AMITAMKU Bug fix-14248296
176:
177: CURSOR c_adj_type_id (p_adj_type IN VARCHAR2, p_org_id IN NUMBER) IS
178: SELECT max(claim_type_id)
179: FROM ozf_claim_types_all_vl
180: WHERE adjustment_type = p_adj_type
181: AND claim_class = 'ADJ'
182: AND claim_type_id > -1
183: AND org_id = p_org_id;

Line 187: FROM ozf_claim_types_all_vl

183: AND org_id = p_org_id;
184: --nirprasa,ER 8399134
185: CURSOR c_adj_type (p_adj_type_id IN NUMBER, p_org_id IN NUMBER) IS
186: SELECT adjustment_type
187: FROM ozf_claim_types_all_vl
188: WHERE claim_type_id = p_adj_type_id
189: AND claim_class = 'ADJ'
190: AND org_id = p_org_id;
191: