DBA Data[Home] [Help]

APPS.PER_ASP_BUS dependencies on HR_ORGANIZATION_INFORMATION

Line 186: from hr_organization_information h1

182: l_dummy varchar2(1);
183: --
184: cursor c1 is
185: select null
186: from hr_organization_information h1
187: where h1.org_information_context = 'Business Group Information'
188: and h1.organization_id = p_business_group_id;
189: --
190: Begin

Line 830: FROM hr_organization_information h1

826: --
827: CURSOR c_get_sg_id
828: IS
829: SELECT org_information14 security_group_id
830: FROM hr_organization_information h1
831: WHERE org_information_context = 'Business Group Information'
832: AND h1.organization_id = p_business_group_id;
833: --
834: l_security_group_id NUMBER;