327: select org_information1
328: , org_information2
329: , org_information3
330: , org_information4
331: from hr_organization_information
332: where organization_id=p_business_group_id
333: and org_information_context='Work Day Information';
334: --
335: cursor get_gre_information is
333: and org_information_context='Work Day Information';
334: --
335: cursor get_gre_information is
336: select org_information1
337: from hr_organization_information
338: where organization_id=p_business_group_id
339: and org_information_context='DEFAULT_GRE_INFO';
340: --
341: cursor get_loc is
679: select org_information1
680: , org_information2
681: , org_information3
682: , org_information4
683: from hr_organization_information
684: where organization_id=p_organization_id
685: and org_information_context='Work Day Information';
686: --
687: cursor get_org_information is
689: , org_information2
690: , org_information3
691: , org_information4
692: , org_information5
693: from hr_organization_information
694: where organization_id=p_organization_id
695: and org_information_context='DEFAULT_HR_INFO';
696: --
697: cursor get_loc is