APPS.OZF_GL_INTERFACE_PVT dependencies on OZF_CLAIM_LINES_ALL

Line 163: , ozf_claim_lines_all l

159: , f.product_id
160: , f.price_adjustment_id
161: , f.cust_account_id
162: from ozf_claim_lines_util_all u
163: , ozf_claim_lines_all l
164: , ozf_claims_all c
165: , ozf_funds_utilized_all_b f
166: where u.claim_line_id = l.claim_line_id
167: and u.utilization_id = f.utilization_id

Line 181: , ozf_claim_lines_all l

177: SELECT SUM(u.amount)
178: , SUM(u.acctd_amount)
179: , c.currency_code
180: FROM ozf_claim_lines_util_all u
181: , ozf_claim_lines_all l
182: , ozf_claims_all c
183: WHERE l.claim_id = c.claim_id
184: AND l.earnings_associated_flag = 'T'
185: AND l.claim_line_id = u.claim_line_id

Line 208: , ozf_claim_lines_all l

204: , f.price_adjustment_id
205: , f.cust_account_id
206: , c.claim_id
207: from ozf_claim_lines_util_all u
208: , ozf_claim_lines_all l
209: , ozf_claims_all c
210: , ozf_funds_utilized_all_b f
211: where u.claim_line_id = l.claim_line_id
212: and u.utilization_id = f.utilization_id

Line 223: FROM ozf_claim_lines_all l

219: SELECT l.claim_currency_amount
220: , l.acctd_amount
221: , c.currency_code
222: , c.claim_id
223: FROM ozf_claim_lines_all l
224: , ozf_claims_all c
225: WHERE l.claim_id = c.claim_id
226: --AND l.earnings_associated_flag = 'T'
227: AND l.claim_line_id = p_id;

Line 247: , ozf_claim_lines_all l

243: , f.price_adjustment_id
244: , f.cust_account_id
245: , c.claim_id
246: from ozf_claim_lines_util_all u
247: , ozf_claim_lines_all l
248: , ozf_claims_all c
249: , ozf_funds_utilized_all_b f
250: where u.claim_line_id = l.claim_line_id
251: and u.utilization_id = f.utilization_id

Line 288: from ozf_claim_lines_all

284:
285: -- get claim_id for a claim line
286: CURSOR get_claim_id_csr(cv_claim_line_id in number) IS
287: select claim_id
288: from ozf_claim_lines_all
289: where claim_line_id = cv_claim_line_id;
290:
291: CURSOR util_accrual_account_csr (cv_source_table in varchar2,
292: cv_source_id in number,

Line 504: ELSIF upper(p_source_table) = 'OZF_CLAIM_LINES_ALL' THEN

500: l_rec_num := l_rec_num + 1;
501: END LOOP;
502: CLOSE get_claim_amt_csr;
503: END IF;
504: ELSIF upper(p_source_table) = 'OZF_CLAIM_LINES_ALL' THEN
505: -- get the claim id
506: OPEN get_claim_id_csr(p_source_id);
507: FETCH get_claim_id_csr INTO l_claim_id;
508: CLOSE get_claim_id_csr;

Line 1303: from ozf_claim_lines_all ln

1299: l_code_combination_id number;
1300:
1301: CURSOR get_product_line_csr(p_claim_id in number) IS
1302: select lu.claim_line_util_id
1303: from ozf_claim_lines_all ln
1304: , ozf_claim_lines_util_all lu
1305: , ozf_funds_utilized_all_b fu
1306: , ozf_offers o
1307: , ams_custom_setup_attr c

Line 2095: , ozf_claim_lines_all l

2091: SELECT SUM(u.amount)
2092: , SUM(u.fxgl_acctd_amount)
2093: , c.currency_code
2094: FROM ozf_claim_lines_util_all u
2095: , ozf_claim_lines_all l
2096: , ozf_claims_all c
2097: WHERE l.claim_id = c.claim_id
2098: AND l.earnings_associated_flag = 'T'
2099: AND l.claim_line_id = u.claim_line_id

Line 2499: FROM ozf_claim_lines_all

2495:
2496: /*
2497: CURSOR promo_claim_csr(p_id in number) IS
2498: SELECT count(claim_line_id)
2499: FROM ozf_claim_lines_all
2500: where claim_id = p_id
2501: and earnings_associated_flag = 'T';
2502: */
2503:

Line 2508: from ozf_claim_lines_all l

2504: CURSOR promo_claim_csr(p_id in number) IS
2505: select nvl(sum(lu.amount), 0)
2506: from ozf_claim_lines_util_all lu
2507: where lu.claim_line_id in (select l.claim_line_id
2508: from ozf_claim_lines_all l
2509: where l.claim_id = p_id);
2510:
2511: -- [BEGIN OF BUG 4039894 FIXING in 11.5.10]
2512: CURSOR chk_ae_exist( cv_source_id IN NUMBER