APPS.OZF_GL_INTERFACE_PVT dependencies on OZF_CLAIM_LINES_ALL

Line 134: from ozf_claim_lines_all

130:
131: -- get claim_id for a claim line
132: CURSOR get_claim_id_csr(cv_claim_line_id in number) IS
133: select claim_id
134: from ozf_claim_lines_all
135: where claim_line_id = cv_claim_line_id;
136:
137: -- default accounts from claim type
138: CURSOR get_claim_type_acc_csr(cv_claim_id in number) IS

Line 164: FROM ozf_claim_lines_all l

160: SELECT l.claim_currency_amount
161: , l.acctd_amount
162: , c.currency_code
163: , c.claim_id
164: FROM ozf_claim_lines_all l
165: , ozf_claims_all c
166: WHERE l.claim_id = c.claim_id
167: --AND l.earnings_associated_flag = 'T'
168: AND l.claim_line_id = p_id;

Line 214: , ozf_claim_lines_all l

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
218: and u.utilization_id = f.utilization_id

Line 258: IF (upper(p_source_table) = 'OZF_CLAIM_LINES_ALL' )THEN

254: END IF;
255: l_acct_gen_tbl := acct_gen_tbl();
256:
257: --ER#9382547 ChRM-SLA Uptake
258: IF (upper(p_source_table) = 'OZF_CLAIM_LINES_ALL' )THEN
259:
260: -- get the claim id
261: OPEN get_claim_id_csr(p_source_id);
262: FETCH get_claim_id_csr INTO l_claim_id;

Line 1551: , ozf_claim_lines_all l

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'
1555: AND l.claim_line_id = u.claim_line_id

Line 2298: FROM ozf_claim_lines_all

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:
2301: CURSOR c_get_claim_line_util(p_claim_id IN NUMBER) IS
2302: SELECT clu.claim_line_util_id

Line 2304: ozf_claim_lines_all cln

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:
2308: