APPS.MO_UTILS dependencies on HR_ORGANIZATION_INFORMATION

Line 85: FROM hr_organization_information o1,

81:
82: BEGIN
83: SELECT gl.name
84: INTO l_ledger_name
85: FROM hr_organization_information o1,
86: hr_organization_information o2,
87: gl_ledgers_public_v gl
88: WHERE o1.organization_id = o2.organization_id
89: AND o1.organization_id = p_operating_unit

Line 86: hr_organization_information o2,

82: BEGIN
83: SELECT gl.name
84: INTO l_ledger_name
85: FROM hr_organization_information o1,
86: hr_organization_information o2,
87: gl_ledgers_public_v gl
88: WHERE o1.organization_id = o2.organization_id
89: AND o1.organization_id = p_operating_unit
90: AND o1.org_information_context = 'CLASS'

Line 124: FROM hr_organization_information o1,

120: SELECT to_number(o2.org_information3),
121: gl.name
122: INTO l_ledger_id,
123: l_ledger_name
124: FROM hr_organization_information o1,
125: hr_organization_information o2,
126: gl_ledgers_public_v gl
127: WHERE o1.organization_id = o2.organization_id
128: AND o1.organization_id = p_operating_unit

Line 125: hr_organization_information o2,

121: gl.name
122: INTO l_ledger_id,
123: l_ledger_name
124: FROM hr_organization_information o1,
125: hr_organization_information o2,
126: gl_ledgers_public_v gl
127: WHERE o1.organization_id = o2.organization_id
128: AND o1.organization_id = p_operating_unit
129: AND o1.org_information_context = 'CLASS'