APPS.OZF_FUND_UTILIZED_PVT dependencies on OZF_CLAIM_TYPES_ALL_B

Line 276: FROM ozf_claim_types_all_b

272:
273: --- Cursor to get the adjustment_type from adjustmentId
274: CURSOR c_adj_type (p_adj_type_id IN NUMBER) IS
275: SELECT adjustment_type
276: FROM ozf_claim_types_all_b
277: WHERE claim_type_id = p_adj_type_id;
278:
279: /* 10/20/2003 yzhao Fix TEVA bug - customer fully accrual budget committed amount is always 0 when third party accrual happens
280: update ozf_act_budgets REQUEST between fully accrual budget and its offer when accrual happens

Line 463: FROM ozf_claim_types_all_b

459: WHERE list_header_id = p_plan_id;
460:
461: CURSOR c_adj_org_id (p_adj_id IN NUMBER) IS
462: SELECT org_id
463: FROM ozf_claim_types_all_b
464: WHERE claim_type_id = p_adj_id;
465:
466: -- Cursor to get the org_id for cust acct
467: CURSOR c_cust_acct_org_id (p_site_use_id IN NUMBER) IS

Line 3222: 'ozf_claim_types_all_b'

3218:
3219: ----------------------- adjustment_id ------------------------
3220: IF p_utilization_rec.adjustment_type_id <> fnd_api.g_miss_num THEN
3221: IF ozf_utility_pvt.check_fk_exists (
3222: 'ozf_claim_types_all_b'
3223: , -- Parent schema object having the primary key
3224: 'claim_type_id'
3225: , -- Column name in the parent object that maps to the fk value
3226: p_utilization_rec.adjustment_type_id -- Value of fk to be validated against the parent object's pk column