APPS.HR_INT_BUS dependencies on HR_KI_EXT_APPLICATIONS

Line 454: -- hr_ki_ext_applications and it is not duplicated in hr_ki_integrations

450: -- {Start Of Comments}
451: --
452: -- Description:
453: -- This procedure ensures external application id is present in
454: -- hr_ki_ext_applications and it is not duplicated in hr_ki_integrations
455: -- table.
456: -- If earlier procedure is used for update validation then error will be
457: -- thrown even if id is unique and not null as earlier query
458: -- does not have addtional p_ext_application_id condition in the cursor.

Line 486: from hr_ki_ext_applications

482: l_key varchar2(1) ;
483: l_key_app varchar2(1) ;
484: cursor csr_name is
485: select null
486: from hr_ki_ext_applications
487: where ext_application_id = p_ext_application_id;
488: cursor csr_app is
489: select null
490: from hr_ki_integrations

Line 981: select null from hr_ki_integrations inte,hr_ki_ext_applications ext

977: from hr_ki_integrations_tl
978: where integration_id = p_integration_id;
979:
980: cursor csr_maintenance_extapp is
981: select null from hr_ki_integrations inte,hr_ki_ext_applications ext
982: where inte.integration_id=p_integration_id
983: and inte.ext_application_id=ext.ext_application_id;
984:
985: --