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: UNION ALL
1391: SELECT 'GL_DATE','OZF_GL_DATE' FROM DUAL;
1392:

Line 1979: FROM ozf_claims_all

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

Line 2006: from ozf_claims_all

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

Line 2029: UPDATE ozf_claims_all

2025: FND_MSG_PUB.Add;
2026: END IF;
2027:
2028: -- update the history related columns for the claim
2029: UPDATE ozf_claims_all
2030: SET history_event = p_history_event,
2031: history_event_date = SYSDATE,
2032: history_event_description = p_history_event_description
2033: WHERE claim_id = p_claim_id;