DBA Data[Home] [Help]

APPS.DPP_TRANSACTION_PVT dependencies on OZF_CLAIMS_ALL

Line 1975: ozf_claims_all oca

1971: IF p_txn_lines_tbl_type(i).inventory_item_id IS NOT NULL THEN
1972: SELECT dtla.supp_dist_claim_id
1973: INTO p_txn_lines_tbl_type(i).supp_dist_claim_id
1974: FROM dpp_transaction_lines_all dtla,
1975: ozf_claims_all oca
1976: WHERE dtla.transaction_header_id = p_txn_header_rec_type.transaction_header_id
1977: AND to_number(dtla.supp_dist_claim_id) = oca.claim_id
1978: AND (oca.claim_number = nvl(p_txn_header_rec_type.supp_dist_claim_number,oca.claim_number)
1979: AND oca.claim_id = nvl(to_number(p_txn_header_rec_type.supp_dist_claim_id),oca.claim_id))