APPS.HR_ORGANIZATION dependencies on FND_PRODUCT_INSTALLATIONS

Line 86: FND_PRODUCT_INSTALLATIONS.

82: in the base user).
83: Changed insert_bus_grp_details to
84: insert 'user' if running in install
85: mode (ie no rows in
86: FND_PRODUCT_INSTALLATIONS.
87: -------------------------------------------------------------------------------
88: 70.25 04-AUG-93 TMATHERS removed reference to
89: product_security_type in
90: per_security_profiles.

Line 369: from fnd_product_installations

365: and id_flex_code = 'PEA';
366: --
367: cursor chk_hr_installed is
368: select null
369: from fnd_product_installations
370: where application_id = 800
371: and status = 'I';
372: --
373: cursor sel_id_flex_num (p_flex_type varchar2) is

Line 541: FROM fnd_product_installations

537: SELECT 'Y'
538: INTO l_install_mode
539: FROM sys.dual
540: WHERE NOT EXISTS (SELECT null
541: FROM fnd_product_installations
542: WHERE application_id = 800
543: AND status IN ('I','S'));
544: --
545: exception when NO_DATA_FOUND then null;

Line 557: FROM fnd_product_installations

553: begin
554: hr_utility.set_location('hr_organization.insert_bus_grp_details',6);
555: SELECT 'N'
556: INTO l_apps_account
557: FROM fnd_product_installations
558: WHERE application_id = 0
559: AND product_version = '6.0.27';
560: --
561: exception when NO_DATA_FOUND then l_apps_account := 'Y' ;