DBA Data[Home] [Help]

APPS.PER_QH_POPULATE dependencies on HR_ORGANIZATION_INFORMATION

Line 331: from hr_organization_information

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

Line 337: from hr_organization_information

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

Line 683: from hr_organization_information

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

Line 693: from hr_organization_information

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