APPS.OZF_GL_INTERFACE_PVT dependencies on OZF_CLAIM_LINES_UTIL_ALL

Line 213: from ozf_claim_lines_util_all u

209: , f.product_level_type
210: , f.product_id
211: , f.price_adjustment_id
212: , f.cust_account_id
213: from ozf_claim_lines_util_all u
214: , ozf_claim_lines_all l
215: , ozf_claims_all c
216: , ozf_funds_utilized_all_b f
217: where u.claim_line_id = l.claim_line_id

Line 1550: FROM ozf_claim_lines_util_all u

1546: CURSOR get_fxgl_amt_csr( p_claim_id in number) IS
1547: SELECT SUM(u.amount)
1548: , SUM(u.fxgl_acctd_amount)
1549: , c.currency_code
1550: FROM ozf_claim_lines_util_all u
1551: , ozf_claim_lines_all l
1552: , ozf_claims_all c
1553: WHERE l.claim_id = c.claim_id
1554: AND l.earnings_associated_flag = 'T'

Line 2296: FROM ozf_claim_lines_util_all

2292: AND cla.org_id = osp.org_id;
2293:
2294: CURSOR c_count_claim_utils(p_id IN NUMBER) IS
2295: SELECT count(*)
2296: FROM ozf_claim_lines_util_all
2297: WHERE claim_line_id IN (SELECT claim_line_id
2298: FROM ozf_claim_lines_all
2299: WHERE claim_id = p_id);
2300:

Line 2303: FROM ozf_claim_lines_util_all clu,

2299: WHERE claim_id = p_id);
2300:
2301: CURSOR c_get_claim_line_util(p_claim_id IN NUMBER) IS
2302: SELECT clu.claim_line_util_id
2303: FROM ozf_claim_lines_util_all clu,
2304: ozf_claim_lines_all cln
2305: WHERE clu.claim_line_id = cln.claim_line_id
2306: AND cln.claim_id = p_claim_id;
2307: