APPS.DPP_CLAIMS_PVT dependencies on OZF_CLAIMS_ALL

Line 193: FROM ozf_claims_all

189: WHERE inventory_item_id = p_item_id;
190:
191: CURSOR get_claim_number_csr(p_claim_id NUMBER) IS
192: SELECT claim_number
193: FROM ozf_claims_all
194: WHERE claim_id = p_claim_id;
195:
196: CURSOR get_customer_dtl_csr(p_cust_account_id NUMBER) IS
197: SELECT account_name,

Line 1387: FROM ozf_claims_all

1383: SELECT Object_version_number,
1384: cust_account_id
1385: INTO l_object_version_number,
1386: l_cust_account_id
1387: FROM ozf_claims_all
1388: WHERE claim_id = l_txn_hdr_rec.claim_id;
1389: EXCEPTION
1390: WHEN NO_DATA_FOUND THEN
1391: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 1593: FROM ozf_claims_all

1589: --Output XML Generation Code
1590: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_transaction_number||'txnnumber,
1591: claim_number claimnumber,'
1592: ||l_reason||'reason
1593: FROM ozf_claims_all
1594: WHERE claim_id = '||l_txn_hdr_rec.claim_id);
1595: dbms_xmlquery.setRowTag(l_queryCtx
1596: ,'ROOT'
1597: );