DBA Data[Home] [Help]

APPS.HR_OTY_BUS dependencies on HR_KI_OPTIONS

Line 238: -- rows are hr_ki_option_types_tl,hr_ki_options.

234: --
235: -- Description:
236: -- This procedure ensures that a delete occurs only if there are no child
237: -- rows for a record in hr_ki_option_types. The tables that contain child
238: -- rows are hr_ki_option_types_tl,hr_ki_options.
239: -- Pre Conditions:
240: -- g_rec has been populated with details of the values
241: -- from the ins or the upd procedures
242: --

Line 271: from hr_ki_options

267: -- Cursor to check that if maintenance rows type exists.
268: --
269: cursor csr_maintenance_option is
270: select null
271: from hr_ki_options
272: where option_type_id = p_option_type_id ;
273:
274: cursor csr_maintenance_tl is
275: select null