APPS.OZF_CLAIMS_HISTORY_PVT dependencies on OZF_CLAIMS_ALL

Line 1388: AND db_table_name = 'OZF_CLAIMS_ALL'

1384: CURSOR user_selected_columns_csr IS
1385: SELECT db_column_name, ak_attribute_code
1386: FROM ams_column_rules
1387: WHERE object_type = 'CLAM'
1388: AND db_table_name = 'OZF_CLAIMS_ALL'
1389: AND rule_type = 'HISTORY';
1390:
1391: l_column_info user_selected_columns_csr%rowtype;
1392:

Line 1977: FROM ozf_claims_all

1973: AND activity_type_code = p_claim_class;
1974:
1975: CURSOR claim_csr(pid in number) IS
1976: SELECT *
1977: FROM ozf_claims_all
1978: WHERE claim_id = pid;
1979: l_claim_rec claim_csr%ROWTYPE;
1980:
1981: CURSOR claim_line_csr(p_id in number) IS

Line 2004: from ozf_claims_all

2000: FROM dual;
2001:
2002: CURSOR check_csr (pid in number)is
2003: select history_event, history_event_description
2004: from ozf_claims_all
2005: where claim_id = pid;
2006:
2007: CURSOR c_claim_hist_id_count(p_id in number) is
2008: select count(*)

Line 2208: UPDATE ozf_claims_all

2204: RAISE FND_API.g_exc_unexpected_error;
2205: END IF;
2206:
2207: -- update the history related columns for the claim
2208: UPDATE ozf_claims_all
2209: SET history_event = p_history_event,
2210: history_event_date = SYSDATE,
2211: history_event_description = p_history_event_description
2212: WHERE claim_id = p_claim_id;