APPS.PER_HU_ORG_INFO dependencies on HR_ORGANIZATION_INFORMATION

Line 35: SELECT org_information4 from hr_organization_information

31: ,p_org_information5 VARCHAR2
32: ) is
33:
34: CURSOR get_information4 (p_org_information_id NUMBER) is
35: SELECT org_information4 from hr_organization_information
36: where ORG_INFORMATION_CONTEXT='HU_COMPANY_INFORMATION_DETAILS'
37: and org_information_id= p_org_information_id;
38:
39: CURSOR get_information5 (p_org_information_id NUMBER) is

Line 40: SELECT org_information5 from hr_organization_information

36: where ORG_INFORMATION_CONTEXT='HU_COMPANY_INFORMATION_DETAILS'
37: and org_information_id= p_org_information_id;
38:
39: CURSOR get_information5 (p_org_information_id NUMBER) is
40: SELECT org_information5 from hr_organization_information
41: where ORG_INFORMATION_CONTEXT='HU_COMPANY_INFORMATION_DETAILS'
42: and org_information_id= p_org_information_id;
43:
44: l_check NUMBER;

Line 45: l_information5 hr_organization_information.org_information5%TYPE;

41: where ORG_INFORMATION_CONTEXT='HU_COMPANY_INFORMATION_DETAILS'
42: and org_information_id= p_org_information_id;
43:
44: l_check NUMBER;
45: l_information5 hr_organization_information.org_information5%TYPE;
46: l_information4 hr_organization_information.org_information4%TYPE;
47: BEGIN
48: --
49: -- Added for GSI Bug 5472781

Line 46: l_information4 hr_organization_information.org_information4%TYPE;

42: and org_information_id= p_org_information_id;
43:
44: l_check NUMBER;
45: l_information5 hr_organization_information.org_information5%TYPE;
46: l_information4 hr_organization_information.org_information4%TYPE;
47: BEGIN
48: --
49: -- Added for GSI Bug 5472781
50: --