APPS.DPP_CLAIMS_PVT dependencies on OZF_CLAIMS_ALL

Line 199: FROM ozf_claims_all

195: WHERE inventory_item_id = p_item_id;
196:
197: CURSOR get_claim_number_csr(p_claim_id NUMBER) IS
198: SELECT claim_number
199: FROM ozf_claims_all
200: WHERE claim_id = p_claim_id;
201:
202: CURSOR get_customer_dtl_csr(p_cust_account_id NUMBER) IS
203: SELECT account_name,

Line 1402: FROM ozf_claims_all

1398: SELECT Object_version_number,
1399: cust_account_id
1400: INTO l_object_version_number,
1401: l_cust_account_id
1402: FROM ozf_claims_all
1403: WHERE claim_id = l_txn_hdr_rec.claim_id;
1404: EXCEPTION
1405: WHEN NO_DATA_FOUND THEN
1406: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 1606: FROM ozf_claims_all

1602: --Output XML Generation Code
1603: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_transaction_number||'txnnumber,
1604: claim_number claimnumber,'
1605: ||l_reason||'reason
1606: FROM ozf_claims_all
1607: WHERE claim_id = '||l_txn_hdr_rec.claim_id);
1608: dbms_xmlquery.setRowTag(l_queryCtx
1609: ,'ROOT'
1610: );