APPS.OZF_CLAIM_LINE_PVT dependencies on OZF_CLAIMS

Line 435: FROM ozf_claims

431: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
432:
433: CURSOR csr_claim_currency(cv_claim_id IN NUMBER) IS
434: SELECT currency_code
435: FROM ozf_claims
436: WHERE claim_id = cv_claim_id;
437:
438: CURSOR csr_order_default_exc(cv_doc_id IN NUMBER) IS
439: SELECT transactional_curr_code

Line 646: FROM ozf_claims

642: , payment_method
643: , tax_code
644: , set_of_books_id
645: , amount -- Bug:2781186
646: FROM ozf_claims
647: WHERE claim_id = cv_claim_id;
648:
649: CURSOR csr_line_rec_upd(cv_claim_id IN NUMBER) IS
650: SELECT claim_line_id

Line 1001: FROM ozf_claims

997:
998: -- Cursor to get claim amount
999: CURSOR c_claim_amount(cv_claim_id IN NUMBER) IS
1000: SELECT amount_remaining, claim_class
1001: FROM ozf_claims
1002: WHERE claim_id = cv_claim_id;
1003:
1004: -- Cursor to get claim amount
1005: CURSOR c_exist_total_line_amt(cv_claim_id IN NUMBER) IS

Line 1012: FROM ozf_claims

1008: WHERE claim_id = cv_claim_id;
1009:
1010: CURSOR c_claim(cv_claim_id IN NUMBER) IS
1011: SELECT currency_code
1012: FROM ozf_claims
1013: WHERE claim_id = cv_claim_id;
1014:
1015: BEGIN
1016: --------------------- initialize -----------------------

Line 1308: FROM ozf_claims

1304:
1305: -- Cursor to get set_of_books_id, and tax_code from Claim
1306: CURSOR csr_default_fm_claim(cv_claim_id IN NUMBER) IS
1307: SELECT set_of_books_id, tax_code, org_id
1308: FROM ozf_claims
1309: WHERE CLAIM_ID = cv_claim_id;
1310:
1311: -- Cursor to get claim amount
1312: CURSOR c_claim_amount(cv_claim_id IN NUMBER) IS

Line 1315: FROM ozf_claims

1311: -- Cursor to get claim amount
1312: CURSOR c_claim_amount(cv_claim_id IN NUMBER) IS
1313: SELECT amount_remaining
1314: , claim_class
1315: FROM ozf_claims
1316: WHERE claim_id = cv_claim_id;
1317:
1318: -- Cursor to sum of claim line amount
1319: CURSOR c_line_sum_amt(cv_claim_id IN NUMBER) IS

Line 1330: FROM ozf_claims

1326: SELECT currency_code
1327: , exchange_rate_type
1328: , exchange_rate_date
1329: , exchange_rate
1330: FROM ozf_claims
1331: WHERE claim_id = cv_claim_id;
1332:
1333: -- fix for bug 5042046
1334: -- Cursor to get functional currency

Line 2007: FROM ozf_claims

2003:
2004:
2005: CURSOR csr_claim_amount(cv_claim_id IN NUMBER) IS
2006: SELECT amount_remaining, claim_class
2007: FROM ozf_claims
2008: WHERE claim_id = cv_claim_id;
2009:
2010: CURSOR csr_exist_total_line_amt(cv_claim_id IN NUMBER) IS
2011: SELECT nvl(sum(claim_currency_amount), 0)

Line 2241: FROM ozf_claims

2237:
2238: -- Cursor to get claim amount
2239: CURSOR c_claim_amount(cv_claim_id IN NUMBER) IS
2240: SELECT amount_remaining
2241: FROM ozf_claims
2242: WHERE claim_id = cv_claim_id;
2243:
2244: -- Cursor to sum of claim line amount
2245: CURSOR c_line_sum_amt(cv_claim_id IN NUMBER, cv_line_id IN NUMBER) IS

Line 2755: FROM ozf_claims

2751: , exchange_rate_type
2752: , exchange_rate_date
2753: , exchange_rate
2754: , claim_class
2755: FROM ozf_claims
2756: WHERE claim_id = cv_claim_id;
2757:
2758: CURSOR c_old_line_amt(cv_claim_line_id IN NUMBER) IS
2759: SELECT claim_currency_amount, currency_code

Line 3049: FROM ozf_claims

3045: -- Cursor to get claim amount
3046: CURSOR c_claim_amount(cv_claim_id IN NUMBER) IS
3047: SELECT amount_remaining
3048: , claim_class
3049: FROM ozf_claims
3050: WHERE claim_id = cv_claim_id;
3051:
3052: -- cursor to get payment_method
3053: CURSOR c_claim_payment_method(cv_claim_id IN NUMBER) IS

Line 3055: FROM ozf_claims

3051:
3052: -- cursor to get payment_method
3053: CURSOR c_claim_payment_method(cv_claim_id IN NUMBER) IS
3054: SELECT payment_method
3055: FROM ozf_claims
3056: WHERE claim_id = cv_claim_id;
3057:
3058: -- Cursor to sum of line util associations
3059: -- Chage the cursor for bug 7658894

Line 3079: FROM ozf_claims

3075: , currency_code
3076: , exchange_rate_type
3077: , exchange_rate_date
3078: , exchange_rate
3079: FROM ozf_claims
3080: WHERE claim_id = cv_claim_id;
3081:
3082: -- fix for bug 5042046
3083: CURSOR csr_function_currency IS

Line 4174: ozf_claims_all oc

4170:
4171: CURSOR csr_claim_settle_method(cv_claim_id IN NUMBER) IS
4172: SELECT ocs.tax_for
4173: FROM ozf_claim_sttlmnt_methods_all ocs,
4174: ozf_claims_all oc
4175: WHERE claim_id = cv_claim_id
4176: AND ocs.claim_class = oc.claim_class
4177: AND NVL(ocs.source_object_class,'NULL') = NVL(oc.source_object_class,'NULL')
4178: AND ocs.settlement_method = oc.payment_method ;

Line 5088: FROM ozf_claims_all

5084:
5085:
5086: CURSOR csr_claim_status(cv_claim_id IN NUMBER) IS
5087: SELECT status_code
5088: FROM ozf_claims_all
5089: WHERE claim_id = cv_claim_id;
5090:
5091: -- added for bugfix 5075837 to get max line number
5092: CURSOR c_line_number(cv_claim_id IN NUMBER) IS