DBA Data[Home] [Help]

APPS.OZF_CLAIM_PVT dependencies on OZF_CLAIMS_HISTORY_ALL

Line 4659: from ozf_claims_history_all

4655:
4656: -- Fix for 5048675
4657: CURSOR claim_history_id_csr(p_id in number) is
4658: select claim_history_id, object_version_number
4659: from ozf_claims_history_all
4660: where claim_id = p_id;
4661:
4662: CURSOR claim_line_his_id_csr(p_id in number) is
4663: select claim_line_history_id, object_version_number

Line 5243: FROM ozf_claims_history_all

5239: l_uncompleted_tasks_tbl tasks_csr_Tbl_Type;
5240:
5241: CURSOR claim_history_tbl_csr(p_claim_id in number) IS
5242: SELECT claim_history_id, object_version_number
5243: FROM ozf_claims_history_all
5244: WHERE task_source_object_id = p_claim_id
5245: AND task_source_object_type_code = G_CLAIM_TYPE
5246: AND claim_id = p_claim_id;
5247:

Line 6518: update ozf_claims_history_all

6514: END IF;
6515: END IF;
6516: /*
6517: -- Temp solution for update the claim history
6518: update ozf_claims_history_all
6519: set task_source_object_id = l_claim_history_id,
6520: task_source_object_type_code = G_CLAIM_HISTORY_TYPE
6521: where task_source_object_id = l_claim.claim_id
6522: and task_source_object_id = G_OBJECT_TYPE