The following lines contain the word 'select', 'insert', 'update' or 'delete':
cons_child_set VARCHAR2(1500); -- Buffer for the select statement
SELECT distinct to_ledger.ledger_id,
to_ledger.name ||
'\nCurrency: ' || to_ledger.currency_code ||
'\nCalendar: ' || to_ledger.period_set_name ||
'\nChart of Accounts: ',
to_ledger.chart_of_accounts_id,
cs1.name,
from_ledger.ledger_id,
from_ledger.name ||
'\nCurrency: ' || from_ledger.currency_code ||
'\nCalendar: ' || from_ledger.period_set_name ||
'\nChart of Accounts: ',
from_ledger.chart_of_accounts_id,
cs2.consolidation_set_id, cs2.name
FROM
gl_ledgers to_ledger,
gl_ledgers from_ledger,
gl_cons_set_assignments csa,
gl_consolidation_sets cs1,
gl_consolidation_sets cs2,
gl_consolidation c
WHERE cs1.consolidation_set_id = csa.consolidation_set_id
AND csa.consolidation_id = c.consolidation_id
AND c.from_ledger_id = from_ledger.ledger_id
AND c.to_ledger_id = to_ledger.ledger_id
AND cs2.consolidation_set_id(+) = csa.child_consolidation_set_id
AND cs1.consolidation_set_id = X_Consolidation_Set_Id ;
SELECT to_ledger.ledger_id,
to_ledger.name ||
'\nCurrency: ' || to_ledger.currency_code ||
'\nCalendar: ' || to_ledger.period_set_name ||
'\nChart of Accounts: ',
to_ledger.chart_of_accounts_id,
cs1.name,
from_ledger.ledger_id,
from_ledger.name ||
'\nCurrency: ' || from_ledger.currency_code ||
'\nCalendar: ' || from_ledger.period_set_name ||
'\nChart of Accounts: ',
from_ledger.chart_of_accounts_id,
cs2.consolidation_set_id, cs2.name, c.name
FROM
gl_ledgers to_ledger,
gl_ledgers from_ledger,
gl_consolidation c,
gl_cons_set_assignments csa,
gl_consolidation_sets cs1,
gl_consolidation_sets cs2
WHERE cs1.consolidation_set_id = csa.consolidation_set_id
AND csa.consolidation_id = c.consolidation_id
AND c.from_ledger_id = from_ledger.ledger_id
AND c.to_ledger_id = to_ledger.ledger_id
AND cs2.consolidation_set_id(+) = csa.child_consolidation_set_id
AND cs1.consolidation_set_id = X_Consolidation_Set_Id ;
SELECT form_left_prompt
FROM fnd_id_flex_segments_tl
WHERE id_flex_num = coa
AND application_id = 101
AND id_flex_code = 'GL#'
AND language = userenv('LANG');
SELECT name
INTO mapping_set_name
FROM GL_CONSOLIDATION_SETS
WHERE consolidation_set_id = X_Consolidation_Set_Id;
SELECT description
INTO title
FROM GL_LOOKUPS
WHERE lookup_type = 'CONSOLIDATION_VIEWER'
AND lookup_code = 'CHV_TITLE';
SELECT description
INTO gcs_title
FROM GL_LOOKUPS
WHERE lookup_type = 'CONSOLIDATION_VIEWER'
AND lookup_code = 'FEATURE_NAME';
SELECT description
INTO gcs_message
FROM GL_LOOKUPS
WHERE lookup_type = 'CONSOLIDATION_VIEWER'
AND lookup_code = 'FEATURE_MESSAGE';
cons_child_set := 'SELECT distinct to_ledger.ledger_id,to_ledger.name || ' ||
'''\nCurrency: ''' || ' || to_ledger.currency_code || ' ||
'''\nCalendar: ''' || '|| to_ledger.period_set_name || ' ||
'''\nChart of Accounts: ''' || ', ' ||
'to_ledger.chart_of_accounts_id, ' ||
'cs1.name, ' ||
'from_ledger.ledger_id, from_ledger.name || ' ||
'''\nCurrency: ''' || ' || from_ledger.currency_code || ' ||
'''\nCalendar: ''' || '|| from_ledger.period_set_name || ' ||
'''\nChart of Accounts: ''' || ', ' ||
'from_ledger.chart_of_accounts_id, ' ||
'cs2.consolidation_set_id, cs2.name ' ||
'FROM gl_ledgers to_ledger, ' ||
'gl_ledgers from_ledger, ' ||
'gl_consolidation c, ' ||
'gl_cons_set_assignments csa, ' ||
'gl_consolidation_sets cs1, ' ||
'gl_consolidation_sets cs2 ' ||
'WHERE cs1.consolidation_set_id = ' ||
'csa.consolidation_set_id ' ||
'AND csa.consolidation_id = ' ||
'c.consolidation_id ' ||
'AND c.from_ledger_id = ' ||
'from_ledger.ledger_id ' ||
'AND c.to_ledger_id = ' ||
'to_ledger.ledger_id ' ||
'AND cs2.consolidation_set_id(+) = csa.child_consolidation_set_id ' ||
'AND cs1.consolidation_set_id IN ( ' || prior_child_set_id || ')' ;
cons_child_set := 'SELECT distinct to_ledger.ledger_id,to_ledger.name || ' ||
'''\nCurrency: ''' || ' || to_ledger.currency_code || ' ||
'''\nCalendar: ''' || '|| to_ledger.period_set_name || ' ||
'''\nChart of Accounts: ''' || ', ' ||
'to_ledger.chart_of_accounts_id, ' ||
'cs1.name, ' ||
'from_ledger.ledger_id, from_ledger.name || ' ||
'''\nCurrency: ''' || ' || from_ledger.currency_code || ' ||
'''\nCalendar: ''' || '|| from_ledger.period_set_name || ' ||
'''\nChart of Accounts: ''' || ', ' ||
'from_ledger.chart_of_accounts_id, ' ||
'cs2.consolidation_set_id, cs2.name, c.name ' ||
'FROM gl_ledgers to_ledger, ' ||
'gl_ledgers from_ledger, ' ||
'gl_consolidation c, ' ||
'gl_cons_set_assignments csa, ' ||
'gl_consolidation_sets cs1, ' ||
'gl_consolidation_sets cs2 ' ||
'WHERE cs1.consolidation_set_id = ' ||
'csa.consolidation_set_id ' ||
'AND csa.consolidation_id = ' ||
'c.consolidation_id ' ||
'AND c.from_ledger_id = ' ||
'from_ledger.ledger_id ' ||
'AND c.to_ledger_id = ' ||
'to_ledger.ledger_id ' ||
'AND cs2.consolidation_set_id(+) = csa.child_consolidation_set_id ' ||
'AND cs1.consolidation_set_id IN ( ' || prior_child_set_id || ')' ;
temp_child_seg := 'SELECT form_left_prompt ' ||
'FROM fnd_id_flex_segments_tl ' ||
'WHERE application_id = 101 '||
'AND id_flex_code = ''GL#'' ' ||
'AND language = userenv(''LANG'') ';