APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_CLAIMS

Line 287: FROM ozf_claims cla

283: --Bug# 8513457 fixed by ateotia (+)
284: /*
285: CURSOR csr_object_class (cv_request_id IN NUMBER) IS
286: SELECT cla.source_object_class
287: FROM ozf_claims cla
288: , ozf_claim_lines line
289: WHERE cla.claim_id = line.claim_id
290: AND line.activity_id = cv_request_id;
291: */

Line 294: FROM ozf_claims_all cla

290: AND line.activity_id = cv_request_id;
291: */
292: CURSOR csr_object_class (cv_claim_line_id IN NUMBER) IS
293: SELECT cla.source_object_class
294: FROM ozf_claims_all cla
295: , ozf_claim_lines_all line
296: WHERE cla.claim_id = line.claim_id
297: AND line.claim_line_id = cv_claim_line_id;
298: --Bug# 8513457 fixed by ateotia (-)

Line 800: , ozf_claims cla

796: , ln.claim_currency_amount
797: , cla.source_object_class
798: , cla.source_object_id
799: FROM ozf_claim_lines ln
800: , ozf_claims cla
801: WHERE ln.claim_id = cla.claim_id
802: AND ln.claim_line_id = cv_claim_line_id;
803:
804: CURSOR csr_offer_id(cv_request_id IN NUMBER) IS

Line 2244: FROM ozf_claims cla

2240: SELECT cla.currency_code
2241: , cla.exchange_rate_type
2242: , cla.exchange_rate_date
2243: , cla.exchange_rate
2244: FROM ozf_claims cla
2245: , ozf_claim_lines ln
2246: WHERE ln.claim_id = cla.claim_id
2247: AND ln.claim_line_id = cv_claim_line_id;
2248:

Line 3218: FROM ozf_claims cla, ozf_claim_lines cl

3214: WHERE claim_line_id = cv_claim_line_id;
3215:
3216: CURSOR csr_claim_date(cv_claim_line_id IN NUMBER) IS
3217: SELECT cla.creation_date
3218: FROM ozf_claims cla, ozf_claim_lines cl
3219: WHERE cla.claim_id = cl.claim_id
3220: AND cl.claim_line_id = cv_claim_line_id;
3221:
3222: BEGIN

Line 4743: from ozf_claims_all

4739: l_salesrep_req_flag VARCHAR2(1);
4740:
4741: CURSOR csr_claim_info(cv_claim_id in number) IS
4742: select object_version_number, sales_rep_id
4743: from ozf_claims_all
4744: where claim_id = cv_claim_id;
4745:
4746: CURSOR csr_ar_system_options IS
4747: SELECT salesrep_required_flag

Line 6264: FROM ozf_claims

6260: -- Fix for Bug 7632911
6261: -- Added the currency_code for Multi Currency - kpatro
6262: CURSOR csr_claim_info(cv_claim_id IN NUMBER) IS
6263: SELECT cust_account_id, amount,claim_class,currency_code
6264: FROM ozf_claims
6265: WHERE claim_id = cv_claim_id;
6266:
6267: --Fix For Bug 7611966
6268: CURSOR csr_claim_line_util(cv_claim_line_id IN NUMBER, cv_claim_id NUMBER) IS

Line 8670: ozf_claims c,

8666: -- Bugfix 5101106
8667: /*CURSOR csr_funds_used_units(cv_activity_product_id IN NUMBER) IS
8668: SELECT NVL(SUM(scan_unit * amp.quantity ), 0)
8669: FROM ozf_claim_lines_util lu,
8670: ozf_claims c,
8671: ozf_claim_lines cl,
8672: ams_act_products amp
8673: WHERE lu.activity_product_id = cv_activity_product_id
8674: AND cl.claim_line_id = lu.claim_line_id

Line 9653: FROM ozf_claims cla, ozf_claim_lines cln

9649: , cln.activity_id
9650: , cln.batch_line_id
9651: , cla.created_from
9652: , cla.org_id
9653: FROM ozf_claims cla, ozf_claim_lines cln
9654: WHERE cla.claim_id = cln.claim_id
9655: AND cln.claim_line_id = cv_claim_line_id;
9656:
9657: BEGIN

Line 11211: from ozf_claims_all

11207:
11208: --modified for bugfix 5119143
11209: CURSOR csr_claim_info(cv_claim_id IN NUMBER) IS
11210: select CUST_ACCOUNT_ID , CUST_BILLTO_ACCT_SITE_ID , CUST_SHIPTO_ACCT_SITE_ID
11211: from ozf_claims_all
11212: where claim_id = cv_claim_id;
11213:
11214:
11215: BEGIN

Line 11501: FROM ozf_claims

11497: GROUP BY fu.plan_id, fu.cust_account_id, ln.activity_type;
11498:
11499: CURSOR csr_claim_setup_info(cv_claim_id IN NUMBER) IS
11500: SELECT custom_setup_id
11501: FROM ozf_claims
11502: WHERE claim_id = cv_claim_id;
11503:
11504: CURSOR csr_claim_perf_req_attr(cv_custom_setup_id IN NUMBER) IS
11505: SELECT NVL(attr_available_flag, 'N')

Line 11555: -- update ozf_claims.approved_flag

11551: ,x_offer_perf_tbl => l_offer_perf_tbl
11552: );
11553:
11554: IF l_performance_flag = FND_API.g_false THEN
11555: -- update ozf_claims.approved_flag
11556: UPDATE ozf_claims_all
11557: SET approved_flag = 'F'
11558: WHERE claim_id = p_claim_id;
11559:

Line 11556: UPDATE ozf_claims_all

11552: );
11553:
11554: IF l_performance_flag = FND_API.g_false THEN
11555: -- update ozf_claims.approved_flag
11556: UPDATE ozf_claims_all
11557: SET approved_flag = 'F'
11558: WHERE claim_id = p_claim_id;
11559:
11560: RETURN FND_API.g_true;

Line 11566: -- update ozf_claims.approved_flag

11562: END IF;
11563: END LOOP;
11564: CLOSE csr_line_util;
11565:
11566: -- update ozf_claims.approved_flag
11567: UPDATE ozf_claims_all
11568: SET approved_flag = 'T'
11569: WHERE claim_id = p_claim_id;
11570:

Line 11567: UPDATE ozf_claims_all

11563: END LOOP;
11564: CLOSE csr_line_util;
11565:
11566: -- update ozf_claims.approved_flag
11567: UPDATE ozf_claims_all
11568: SET approved_flag = 'T'
11569: WHERE claim_id = p_claim_id;
11570:
11571: RETURN FND_API.g_false;

Line 11606: FROM ozf_claims

11602: l_currOrgId NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();
11603:
11604: CURSOR csr_claim_info(cv_claim_id IN NUMBER) IS
11605: SELECT cust_account_id
11606: FROM ozf_claims
11607: WHERE claim_id = cv_claim_id;
11608:
11609: CURSOR csr_cust_trd_prfl_info(cv_cust_account_id IN NUMBER) IS
11610: SELECT un_earned_pay_thold_type, un_earned_pay_thold_amount, un_earned_pay_thold_flag

Line 12131: , ozf_claims cla

12127: CURSOR csr_access(cv_claim_id IN NUMBER) IS
12128: SELECT resource_id
12129: FROM ozf_sd_request_access req
12130: , ozf_claim_lines line
12131: , ozf_claims cla
12132: WHERE cla.claim_id = cv_claim_id
12133: AND cla.claim_id = line.claim_id
12134: AND line.activity_id = req.request_header_id
12135: AND req.enabled_flag = 'Y'

Line 12931: FROM ozf_claims_all

12927:
12928:
12929: CURSOR csr_claim_header(cv_claim_id IN NUMBER) IS
12930: SELECT created_from
12931: FROM ozf_claims_all
12932: WHERE claim_id = cv_claim_id;
12933:
12934: CURSOR claim_line_id_csr(p_id in number) IS
12935: SELECT claim_line_id, object_version_number