APPS.AMS_EVENTHEADER_PVT dependencies on DUAL

Line 79: FROM DUAL;

75:
76:
77: CURSOR c_evh_seq IS
78: SELECT ams_event_headers_all_b_s.NEXTVAL
79: FROM DUAL;
80:
81: CURSOR c_evh_count(evh_id IN NUMBER) IS
82: SELECT COUNT(*)
83: FROM ams_event_headers_vl

Line 2165: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from ams_source_codes

2161:
2162: l_valid_flag VARCHAR2(1);
2163: l_dummy NUMBER;
2164: cursor c_src_code(src_code_in IN VARCHAR2) IS
2165: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from ams_source_codes
2166: where SOURCE_CODE = src_code_in);
2167: BEGIN
2168:
2169: x_return_status := FND_API.g_ret_sts_success;