APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_CLAIMS_ALL

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 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 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 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 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 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