DBA Data[Home] [Help]

APPS.OZF_CLAIM_PVT dependencies on OZF_CLAIMS_HISTORY_ALL

Line 5535: from ozf_claims_history_all

5531:
5532: -- Fix for 5048675
5533: CURSOR claim_history_id_csr(p_id in number) is
5534: select claim_history_id, object_version_number
5535: from ozf_claims_history_all
5536: where claim_id = p_id;
5537:
5538: CURSOR claim_line_his_id_csr(p_id in number) is
5539: select claim_line_history_id, object_version_number

Line 6121: FROM ozf_claims_history_all

6117: l_uncompleted_tasks_tbl tasks_csr_Tbl_Type;
6118:
6119: CURSOR claim_history_tbl_csr(p_claim_id in number) IS
6120: SELECT claim_history_id, object_version_number
6121: FROM ozf_claims_history_all
6122: WHERE task_source_object_id = p_claim_id
6123: AND task_source_object_type_code = G_CLAIM_TYPE
6124: AND claim_id = p_claim_id;
6125:

Line 7969: update ozf_claims_history_all

7965: END IF;
7966: END IF;
7967: /*
7968: -- Temp solution for update the claim history
7969: update ozf_claims_history_all
7970: set task_source_object_id = l_claim_history_id,
7971: task_source_object_type_code = G_CLAIM_HISTORY_TYPE
7972: where task_source_object_id = l_claim.claim_id
7973: and task_source_object_id = G_OBJECT_TYPE