DBA Data[Home] [Help]

APPS.PAY_RANGE_TABLE_API dependencies on HR_ORGANIZATION_INFORMATION

Line 89: from hr_organization_information hoi

85:
86:
87: Cursor Sel_Bus Is
88: select inf.org_information9
89: from hr_organization_information hoi
90: , hr_organization_information inf
91: where hoi.organization_id = p_BUSINESS_GROUP_ID
92: and hoi.org_information_context||'' = 'CLASS'
93: and hoi.org_information1 = 'HR_BG'

Line 90: , hr_organization_information inf

86:
87: Cursor Sel_Bus Is
88: select inf.org_information9
89: from hr_organization_information hoi
90: , hr_organization_information inf
91: where hoi.organization_id = p_BUSINESS_GROUP_ID
92: and hoi.org_information_context||'' = 'CLASS'
93: and hoi.org_information1 = 'HR_BG'
94: and hoi.org_information2 = 'Y'

Line 329: from hr_organization_information hoi

325:
326:
327: Cursor Sel_Bus Is
328: select inf.org_information9
329: from hr_organization_information hoi
330: , hr_organization_information inf
331: where hoi.organization_id = p_BUSINESS_GROUP_ID
332: and hoi.org_information_context||'' = 'CLASS'
333: and hoi.org_information1 = 'HR_BG'

Line 330: , hr_organization_information inf

326:
327: Cursor Sel_Bus Is
328: select inf.org_information9
329: from hr_organization_information hoi
330: , hr_organization_information inf
331: where hoi.organization_id = p_BUSINESS_GROUP_ID
332: and hoi.org_information_context||'' = 'CLASS'
333: and hoi.org_information1 = 'HR_BG'
334: and hoi.org_information2 = 'Y'