APPS.GHR_SF52_POS_UPDATE dependencies on HR_ORGANIZATION_INFORMATION

Line 47: l_org_info_id hr_organization_information.org_information_id%type;

43: ,p_org_info_rec out nocopy org_info_rec_type
44: ) is
45: --
46: l_proc varchar2(72) := g_package||'retrieve_gov_kff_setup_info';
47: l_org_info_id hr_organization_information.org_information_id%type;
48: l_org_info_found boolean := FALSE;
49: --
50: cursor c_organization_information (org_id number) is
51: select oi.org_information1,

Line 56: from hr_organization_information oi

52: oi.org_information2,
53: oi.org_information3,
54: oi.org_information4,
55: oi.org_information5
56: from hr_organization_information oi
57: where oi.organization_id = org_id
58: and oi.org_information_context = 'GHR_US_ORG_INFORMATION';
59: --
60: begin