APPS.OZF_CLAIM_SETTLEMENT_PVT dependencies on OZF_CLAIM_LINES

Line 377: FROM ozf_claim_lines

373:
374: CURSOR csr_claim_line_asso(cv_claim_id IN NUMBER) IS
375: SELECT claim_line_id
376: , object_version_number
377: FROM ozf_claim_lines
378: WHERE claim_id = cv_claim_id;
379:
380: TYPE claim_line_asso_tbl IS TABLE OF csr_claim_line_asso%ROWTYPE
381: INDEX BY BINARY_INTEGER;

Line 972: FROM ozf_claim_lines

968: AND system_status_code = cv_status_code;
969:
970: CURSOR csr_line_sum_amt(cv_claim_id IN NUMBER) IS
971: SELECT SUM(claim_currency_amount)
972: FROM ozf_claim_lines
973: WHERE claim_id = cv_claim_id;
974:
975: CURSOR csr_claim_perf_appr_req(cv_custom_setup_id IN NUMBER) IS
976: SELECT NVL(attr_available_flag, 'N')

Line 1277: FROM ozf_claim_lines

1273: AND system_status_code = cv_status_code;
1274:
1275: CURSOR csr_line_sum_amt(cv_claim_id IN NUMBER) IS
1276: SELECT SUM(claim_currency_amount)
1277: FROM ozf_claim_lines
1278: WHERE claim_id = cv_claim_id;
1279:
1280: CURSOR csr_trx_balance(cv_customer_trx_id IN NUMBER) IS
1281: SELECT SUM(amount_due_remaining),

Line 1671: FROM ozf_claim_lines_util lu

1667: l_automate_settlement VARCHAR2(1);
1668:
1669: CURSOR promo_claim_csr(p_id IN NUMBER) IS
1670: SELECT NVL(SUM(lu.amount), 0)
1671: FROM ozf_claim_lines_util lu
1672: WHERE lu.claim_line_id IN (
1673: SELECT l.claim_line_id
1674: FROM ozf_claim_lines l
1675: WHERE l.claim_id = p_id);

Line 1674: FROM ozf_claim_lines l

1670: SELECT NVL(SUM(lu.amount), 0)
1671: FROM ozf_claim_lines_util lu
1672: WHERE lu.claim_line_id IN (
1673: SELECT l.claim_line_id
1674: FROM ozf_claim_lines l
1675: WHERE l.claim_id = p_id);
1676:
1677: l_asso_amount NUMBER;
1678: l_bg_process VARCHAR2(1) := 'N';

Line 2053: FROM ozf_claim_lines

2049: AND sd.claim_id = cv_claim_id;
2050:
2051: CURSOR csr_sum_line_amount(cv_claim_id IN NUMBER) IS
2052: SELECT SUM(claim_currency_amount)
2053: FROM ozf_claim_lines
2054: WHERE claim_id = cv_claim_id;
2055:
2056:
2057: BEGIN

Line 2326: FROM ozf_claim_lines_all ln

2322: , fu.plan_currency_code
2323: , fu.exchange_rate_type
2324: , fu.exchange_rate
2325: , fu.exchange_rate_date
2326: FROM ozf_claim_lines_all ln
2327: , ozf_claim_lines_util_all lu
2328: , ozf_funds_utilized_all_b fu
2329: WHERE ln.claim_id = p_claim_id
2330: AND ln.claim_line_id = lu.claim_line_id

Line 2327: , ozf_claim_lines_util_all lu

2323: , fu.exchange_rate_type
2324: , fu.exchange_rate
2325: , fu.exchange_rate_date
2326: FROM ozf_claim_lines_all ln
2327: , ozf_claim_lines_util_all lu
2328: , ozf_funds_utilized_all_b fu
2329: WHERE ln.claim_id = p_claim_id
2330: AND ln.claim_line_id = lu.claim_line_id
2331: AND lu.utilization_id = fu.utilization_id;

Line 2376: UPDATE ozf_claim_lines_util_all

2372: IF (p_claim_rate = 1) THEN
2373:
2374: p_claim_exchange_date := l_claim_settled_date;
2375: -- Update the claim line util table with the settled date.
2376: UPDATE ozf_claim_lines_util_all
2377: SET exchange_rate_date = l_claim_settled_date
2378: WHERE claim_line_util_id = l_line_util_id;
2379:
2380: END IF;

Line 2447: UPDATE ozf_claim_lines_util_all

2443: OZF_Utility_PVT.debug_message('l_claim_settled_date = '||l_claim_settled_date);
2444: OZF_Utility_PVT.debug_message('l_claim_exc_rate = '||l_claim_exc_rate);
2445: END IF;
2446:
2447: UPDATE ozf_claim_lines_util_all
2448: SET acctd_amount = l_lu_acctd_amount
2449: , exchange_rate_date = l_claim_settled_date
2450: , exchange_rate = l_claim_exc_rate
2451: -- , utilized_acctd_amount = l_util_acctd_amount