DBA Data[Home] [Help]

APPS.HR_INT_BUS dependencies on HR_KI_OPTIONS

Line 933: -- rows are hr_ki_integrations_tl,hr_ki_topic_integrations,hr_ki_options.

929: --
930: -- Description:
931: -- This procedure ensures that a delete occurs only if there are no child
932: -- rows for a record in hr_ki_integrations. The tables that contain child
933: -- rows are hr_ki_integrations_tl,hr_ki_topic_integrations,hr_ki_options.
934: -- Pre Conditions:
935: -- g_rec has been populated with details of the values
936: -- from the ins or the upd procedures
937: --

Line 967: from hr_ki_options

963: -- Cursor to check that if maintenance rows exists.
964: --
965: cursor csr_maintenance_option is
966: select null
967: from hr_ki_options
968: where integration_id = p_integration_id;
969:
970: cursor csr_maintenance_ti is
971: select null