DBA Data[Home] [Help]

APPS.OZF_CLAIMS_HISTORY_PVT dependencies on DUAL

Line 1391: SELECT 'GL_DATE','OZF_GL_DATE' FROM DUAL;

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:
1393: l_column_info user_selected_columns_csr%rowtype;
1394:
1395: CURSOR claim_rec_csr(p_id in number) IS

Line 2002: FROM dual;

1998: --AND event_date = max(event_date);
1999:
2000: CURSOR claim_history_sequence_cur IS
2001: SELECT ozf_claims_history_all_s.nextval
2002: FROM dual;
2003:
2004: CURSOR check_csr (pid in number)is
2005: select history_event, history_event_description
2006: from ozf_claims_all