APPS.MO_UTILS dependencies on GL_LEDGERS

Line 80: l_ledger_name GL_LEDGERS.Name%TYPE;

76: ( p_operating_unit IN NUMBER
77: )
78: RETURN VARCHAR2
79: IS
80: l_ledger_name GL_LEDGERS.Name%TYPE;
81:
82: BEGIN
83: SELECT gl.name
84: INTO l_ledger_name

Line 87: gl_ledgers_public_v gl

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'
91: AND o2.org_information_context = 'Operating Unit Information'

Line 116: l_ledger_id GL_LEDGERS.Ledger_Id%TYPE;

112: , p_ledger_id OUT NOCOPY NUMBER
113: , p_ledger_name OUT NOCOPY VARCHAR2
114: )
115: IS
116: l_ledger_id GL_LEDGERS.Ledger_Id%TYPE;
117: l_ledger_name GL_LEDGERS.Name%TYPE;
118:
119: BEGIN
120: SELECT to_number(o2.org_information3),

Line 117: l_ledger_name GL_LEDGERS.Name%TYPE;

113: , p_ledger_name OUT NOCOPY VARCHAR2
114: )
115: IS
116: l_ledger_id GL_LEDGERS.Ledger_Id%TYPE;
117: l_ledger_name GL_LEDGERS.Name%TYPE;
118:
119: BEGIN
120: SELECT to_number(o2.org_information3),
121: gl.name

Line 126: gl_ledgers_public_v gl

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'
130: AND o2.org_information_context = 'Operating Unit Information'