DBA Data[Home] [Help]

APPS.GL_GLXRLBOL_XMLP_PKG dependencies on GL_LOOKUPS

Line 86: FROM GL_BUDGET_ENTITIES be, GL_LOOKUPS lk

82:
83: else
84: SELECT be.name, be.description, lk.meaning, be.start_date, be.end_date
85: INTO ORGNAME, ORGDESC, ORGPASS, STARTDATE, ENDDATE
86: FROM GL_BUDGET_ENTITIES be, GL_LOOKUPS lk
87: --WHERE be.budget_entity_id = P_BUDGET_ENTITY_ID
88: WHERE be.budget_entity_id = P_BUDGET_ENTITY_ID_NEW
89: AND lk.lookup_code = be.budget_password_required_flag
90: AND lk.lookup_type = 'YES/NO';

Line 126: from gl_lookups l, gl_budget_entities be

122: all_bud_ent_id NUMBER;
123: begin
124: select be.budget_entity_id
125: into all_bud_ent_id
126: from gl_lookups l, gl_budget_entities be
127: where l.lookup_type = 'LITERAL'
128: and l.lookup_code = 'ALL'
129: and upper(be.name) = upper(l.meaning)
130: and be.ledger_id = p_ledger_id;