APPS.OZF_CLAIM_SETTLEMENT_PVT dependencies on OZF_CLAIM_LINES

Line 375: FROM ozf_claim_lines

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

Line 970: FROM ozf_claim_lines

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

Line 1275: FROM ozf_claim_lines

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

Line 1669: FROM ozf_claim_lines_util lu

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

Line 1672: FROM ozf_claim_lines l

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

Line 2040: FROM ozf_claim_lines

2036: AND sd.claim_id = cv_claim_id;
2037:
2038: CURSOR csr_sum_line_amount(cv_claim_id IN NUMBER) IS
2039: SELECT SUM(claim_currency_amount)
2040: FROM ozf_claim_lines
2041: WHERE claim_id = cv_claim_id;
2042:
2043:
2044: BEGIN