APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_CLAIMS

Line 255: FROM ozf_claims cla

251:
252: --csr_object_class added for Ship - Debit claims / Pranay
253: CURSOR csr_object_class (cv_request_id IN NUMBER) IS
254: SELECT cla.source_object_class
255: FROM ozf_claims cla
256: , ozf_claim_lines line
257: WHERE cla.claim_id = line.claim_id
258: AND line.activity_id = cv_request_id;
259:

Line 725: , ozf_claims cla

721: , ln.claim_currency_amount
722: , cla.source_object_class
723: , cla.source_object_id
724: FROM ozf_claim_lines ln
725: , ozf_claims cla
726: WHERE ln.claim_id = cla.claim_id
727: AND ln.claim_line_id = cv_claim_line_id;
728:
729: CURSOR csr_offer_id(cv_request_id IN NUMBER) IS

Line 1923: FROM ozf_claims cla

1919: SELECT cla.currency_code
1920: , cla.exchange_rate_type
1921: , cla.exchange_rate_date
1922: , cla.exchange_rate
1923: FROM ozf_claims cla
1924: , ozf_claim_lines ln
1925: WHERE ln.claim_id = cla.claim_id
1926: AND ln.claim_line_id = cv_claim_line_id;
1927:

Line 2233: FROM ozf_claims cla

2229: , cla.exchange_rate_type
2230: , cla.exchange_rate_date
2231: , cla.exchange_rate
2232: , cla.creation_date
2233: FROM ozf_claims cla
2234: , ozf_claim_lines ln
2235: WHERE ln.claim_id = cla.claim_id
2236: AND ln.claim_line_id = cv_claim_line_id;
2237:

Line 2251: FROM ozf_claims_all

2247: WHERE claim_line_id = cv_claim_line_id;
2248:
2249: CURSOR csr_claim_org(cv_claim_id IN NUMBER) IS
2250: SELECT org_id
2251: FROM ozf_claims_all
2252: WHERE claim_id = cv_claim_id;
2253:
2254: -- Get Accrual Currency
2255: CURSOR csr_acc_currency(cv_utilization_id IN NUMBER) IS

Line 2884: FROM ozf_claims cla, ozf_claim_lines cl

2880: WHERE claim_line_id = cv_claim_line_id;
2881:
2882: CURSOR csr_claim_date(cv_claim_line_id IN NUMBER) IS
2883: SELECT cla.creation_date
2884: FROM ozf_claims cla, ozf_claim_lines cl
2885: WHERE cla.claim_id = cl.claim_id
2886: AND cl.claim_line_id = cv_claim_line_id;
2887:
2888: BEGIN

Line 4363: from ozf_claims_all

4359: l_salesrep_req_flag VARCHAR2(1);
4360:
4361: CURSOR csr_claim_info(cv_claim_id in number) IS
4362: select object_version_number, sales_rep_id
4363: from ozf_claims_all
4364: where claim_id = cv_claim_id;
4365:
4366: CURSOR csr_ar_system_options IS
4367: SELECT salesrep_required_flag

Line 5213: FROM ozf_claims

5209:
5210: -- Fix for Bug 7632911
5211: CURSOR csr_claim_info(cv_claim_id IN NUMBER) IS
5212: SELECT cust_account_id, amount,claim_class
5213: FROM ozf_claims
5214: WHERE claim_id = cv_claim_id;
5215:
5216: --Fix For Bug 7611966
5217: CURSOR csr_claim_line_util(cv_claim_line_id IN NUMBER, cv_claim_id NUMBER) IS

Line 6737: ozf_claims c,

6733: -- Modified for Bug 5101106 quantity = coupon count * offer qty
6734: CURSOR csr_funds_used_units(cv_activity_product_id IN NUMBER) IS
6735: SELECT NVL(SUM(scan_unit * amp.quantity ), 0)
6736: FROM ozf_claim_lines_util lu,
6737: ozf_claims c,
6738: ozf_claim_lines cl,
6739: ams_act_products amp
6740: WHERE lu.activity_product_id = cv_activity_product_id
6741: AND cl.claim_line_id = lu.claim_line_id

Line 6771: FROM ozf_claims cla, ozf_claim_lines cln

6767: ,cla.exchange_rate
6768: ,cla.source_object_id
6769: ,cln.activity_id --Bugfix 7717638
6770: ,cln.batch_line_id --Bugfix 7811671
6771: FROM ozf_claims cla, ozf_claim_lines cln
6772: WHERE cla.claim_id = cln.claim_id
6773: AND cln.claim_line_id = cv_claim_line_id;
6774:
6775: -- Introduced for Bug4348163

Line 8842: from ozf_claims_all

8838:
8839: --modified for bugfix 5119143
8840: CURSOR csr_claim_info(cv_claim_id IN NUMBER) IS
8841: select CUST_ACCOUNT_ID , CUST_BILLTO_ACCT_SITE_ID , CUST_SHIPTO_ACCT_SITE_ID
8842: from ozf_claims_all
8843: where claim_id = cv_claim_id;
8844:
8845:
8846: BEGIN

Line 9250: FROM ozf_claims

9246: GROUP BY fu.plan_id, fu.cust_account_id, ln.activity_type;
9247:
9248: CURSOR csr_claim_setup_info(cv_claim_id IN NUMBER) IS
9249: SELECT custom_setup_id
9250: FROM ozf_claims
9251: WHERE claim_id = cv_claim_id;
9252:
9253: CURSOR csr_claim_perf_req_attr(cv_custom_setup_id IN NUMBER) IS
9254: SELECT NVL(attr_available_flag, 'N')

Line 9304: -- update ozf_claims.approved_flag

9300: ,x_offer_perf_tbl => l_offer_perf_tbl
9301: );
9302:
9303: IF l_performance_flag = FND_API.g_false THEN
9304: -- update ozf_claims.approved_flag
9305: UPDATE ozf_claims_all
9306: SET approved_flag = 'F'
9307: WHERE claim_id = p_claim_id;
9308:

Line 9305: UPDATE ozf_claims_all

9301: );
9302:
9303: IF l_performance_flag = FND_API.g_false THEN
9304: -- update ozf_claims.approved_flag
9305: UPDATE ozf_claims_all
9306: SET approved_flag = 'F'
9307: WHERE claim_id = p_claim_id;
9308:
9309: RETURN FND_API.g_true;

Line 9315: -- update ozf_claims.approved_flag

9311: END IF;
9312: END LOOP;
9313: CLOSE csr_line_util;
9314:
9315: -- update ozf_claims.approved_flag
9316: UPDATE ozf_claims_all
9317: SET approved_flag = 'T'
9318: WHERE claim_id = p_claim_id;
9319:

Line 9316: UPDATE ozf_claims_all

9312: END LOOP;
9313: CLOSE csr_line_util;
9314:
9315: -- update ozf_claims.approved_flag
9316: UPDATE ozf_claims_all
9317: SET approved_flag = 'T'
9318: WHERE claim_id = p_claim_id;
9319:
9320: RETURN FND_API.g_false;

Line 9354: FROM ozf_claims

9350: l_un_earned_pay_thold_flag VARCHAR2(1) := 'F';
9351:
9352: CURSOR csr_claim_info(cv_claim_id IN NUMBER) IS
9353: SELECT cust_account_id
9354: FROM ozf_claims
9355: WHERE claim_id = cv_claim_id;
9356:
9357: CURSOR csr_cust_trd_prfl_info(cv_cust_account_id IN NUMBER) IS
9358: SELECT un_earned_pay_thold_type, un_earned_pay_thold_amount, un_earned_pay_thold_flag

Line 9843: , ozf_claims cla

9839: CURSOR csr_access(cv_claim_id IN NUMBER) IS
9840: SELECT resource_id
9841: FROM ozf_sd_request_access req
9842: , ozf_claim_lines line
9843: , ozf_claims cla
9844: WHERE cla.claim_id = cv_claim_id
9845: AND cla.claim_id = line.claim_id
9846: AND line.activity_id = req.request_header_id
9847: AND req.enabled_flag = 'Y'