[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT decode(lrl.alc_no_rate_action_code,
'REPORT_ERROR', 0, p_max_roll_days)
FROM gl_ledger_relationships lrl,
gl_je_inclusion_rules inc
WHERE lrl.source_ledger_id = p_ledger_id
AND lrl.target_ledger_id = p_reporting_ledger_id
AND lrl.target_ledger_category_code = 'ALC'
AND lrl.relationship_type_code in ('ADJUST', 'JOURNAL', 'SUBLEDGER')
AND lrl.application_id = 101
AND lrl.relationship_enabled_flag = 'Y'
AND inc.je_rule_set_id = lrl.gl_je_conversion_set_id
AND inc.include_flag = 'Y'
AND ((inc.je_source_name = p_source_name AND
inc.je_category_name = p_category_name)
OR (inc.je_source_name = p_source_name AND
inc.je_category_name = 'Other')
OR (inc.je_source_name = 'Other' AND
inc.je_category_name = p_category_name)
OR (inc.je_source_name = 'Other' AND
inc.je_category_name = 'Other'))
ORDER BY decode(inc.je_source_name, 'Other', 2, 0)
+ decode(inc.je_category_name, 'Other', 1, 0);
SELECT account_type
INTO l_account_type
FROM gl_code_combinations
WHERE code_combination_id = p_code_combination_id;
SELECT round((p_entered_amount * l_conv_rate_numer
/ l_conv_rate_denom)
/ nvl(curr.minimum_accountable_unit, power(10, -curr.precision)))
* nvl(curr.minimum_accountable_unit, power(10, -curr.precision))
INTO p_accounted_amount
FROM fnd_currencies curr
WHERE curr.currency_code = p_functional_currency;