DBA Data[Home] [Help]

APPS.DPP_TRANSACTION_PVT dependencies on OZF_CLAIMS_ALL

Line 2184: ozf_claims_all oca

2180: IF p_txn_lines_tbl_type(i).inventory_item_id IS NOT NULL THEN
2181: SELECT dtla.supp_dist_claim_id
2182: INTO p_txn_lines_tbl_type(i).supp_dist_claim_id
2183: FROM dpp_transaction_lines_all dtla,
2184: ozf_claims_all oca
2185: WHERE dtla.transaction_header_id = p_txn_header_rec_type.transaction_header_id
2186: AND to_number(dtla.supp_dist_claim_id) = oca.claim_id
2187: AND (oca.claim_number = nvl(p_txn_header_rec_type.supp_dist_claim_number,oca.claim_number)
2188: AND oca.claim_id = nvl(to_number(p_txn_header_rec_type.supp_dist_claim_id),oca.claim_id))