APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_CLAIMS_ALL

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