DBA Data[Home] [Help]

APPS.HR_UTIL_FLEX_WEB dependencies on HR_ORGANIZATION_INFORMATION

Line 58: -- Grade Keyflex Id is stored in org_information4 in hr_organization_information

54: l_cost_flex_code varchar2(4) default 'COST';
55:
56:
57: --
58: -- Grade Keyflex Id is stored in org_information4 in hr_organization_information
59: cursor csr_get_grade_flex_id is
60: select org_information4
61: from hr_organization_information
62: where organization_id = p_business_group_id

Line 61: from hr_organization_information

57: --
58: -- Grade Keyflex Id is stored in org_information4 in hr_organization_information
59: cursor csr_get_grade_flex_id is
60: select org_information4
61: from hr_organization_information
62: where organization_id = p_business_group_id
63: and org_information_context = 'Business Group Information';
64: --
65: -- People Group Keyflex Id is stored in org_information5 in

Line 66: -- hr_organization_information.

62: where organization_id = p_business_group_id
63: and org_information_context = 'Business Group Information';
64: --
65: -- People Group Keyflex Id is stored in org_information5 in
66: -- hr_organization_information.
67: cursor csr_get_people_group_flex_id is
68: select org_information5
69: from hr_organization_information
70: where organization_id = p_business_group_id

Line 69: from hr_organization_information

65: -- People Group Keyflex Id is stored in org_information5 in
66: -- hr_organization_information.
67: cursor csr_get_people_group_flex_id is
68: select org_information5
69: from hr_organization_information
70: where organization_id = p_business_group_id
71: and org_information_context = 'Business Group Information';
72: --
73: -- Job Keyflex Id is stored in org_information6 in hr_organization_information

Line 73: -- Job Keyflex Id is stored in org_information6 in hr_organization_information

69: from hr_organization_information
70: where organization_id = p_business_group_id
71: and org_information_context = 'Business Group Information';
72: --
73: -- Job Keyflex Id is stored in org_information6 in hr_organization_information
74: cursor csr_get_job_flex_id is
75: select org_information6
76: from hr_organization_information
77: where organization_id = p_business_group_id

Line 76: from hr_organization_information

72: --
73: -- Job Keyflex Id is stored in org_information6 in hr_organization_information
74: cursor csr_get_job_flex_id is
75: select org_information6
76: from hr_organization_information
77: where organization_id = p_business_group_id
78: and org_information_context = 'Business Group Information';
79: --
80: -- Costing Keyflex Id is stored in org_information7 in

Line 81: -- hr_organization_information.

77: where organization_id = p_business_group_id
78: and org_information_context = 'Business Group Information';
79: --
80: -- Costing Keyflex Id is stored in org_information7 in
81: -- hr_organization_information.
82: cursor csr_get_costing_flex_id is
83: select org_information7
84: from hr_organization_information
85: where organization_id = p_business_group_id

Line 84: from hr_organization_information

80: -- Costing Keyflex Id is stored in org_information7 in
81: -- hr_organization_information.
82: cursor csr_get_costing_flex_id is
83: select org_information7
84: from hr_organization_information
85: where organization_id = p_business_group_id
86: and org_information_context = 'Business Group Information';
87: --
88: -- Position Keyflex Id is stored in org_information8 in

Line 89: -- hr_organization_information.

85: where organization_id = p_business_group_id
86: and org_information_context = 'Business Group Information';
87: --
88: -- Position Keyflex Id is stored in org_information8 in
89: -- hr_organization_information.
90: cursor csr_get_position_flex_id is
91: select org_information8
92: from hr_organization_information
93: where organization_id = p_business_group_id

Line 92: from hr_organization_information

88: -- Position Keyflex Id is stored in org_information8 in
89: -- hr_organization_information.
90: cursor csr_get_position_flex_id is
91: select org_information8
92: from hr_organization_information
93: where organization_id = p_business_group_id
94: and org_information_context = 'Business Group Information';
95: --
96: Begin