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
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'
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
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'