DBA Data[Home] [Help]

APPS.OTA_PMM_API dependencies on OTA_EVENTS

Line 63: from ota_events

59: enrolment_start_date,
60: enrolment_end_date,
61: organization_id,
62: secure_event_flag
63: from ota_events
64: where event_id = p_program_event_id;
65:
66: cursor c_effective_date is
67: select effective_date

Line 91: l_add_struct_d(l_add_struct_d.count) := 'OTA_EVENTS';

87: --
88: /* bug no 3891115 */
89:
90: l_add_struct_d.extend(1);
91: l_add_struct_d(l_add_struct_d.count) := 'OTA_EVENTS';
92: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
93: /* bug no 3891115 */
94: if p_event_id is null then
95: --

Line 191: from ota_events

187: l_event_ovn number;
188: --
189: cursor get_event is
190: select object_version_number
191: from ota_events
192: where event_id = p_event_id
193: and book_independent_flag <> 'Y'
194: and not exists
195: (select null