DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_UTILS dependencies on FND_CURRENCIES

Line 2865: -- FROM fnd_currencies_vl

2861: -- so that the NAME, LANGUAGE index can be used, if appropriate
2862: --
2863: -- SELECT currency_code
2864: -- INTO x_txn_currency_code
2865: -- FROM fnd_currencies_vl
2866: -- WHERE p_currency_code_name = currency_code || ' - ' || name;
2867:
2868: SELECT currency_code
2869: INTO x_txn_currency_code

Line 2870: FROM fnd_currencies_tl

2866: -- WHERE p_currency_code_name = currency_code || ' - ' || name;
2867:
2868: SELECT currency_code
2869: INTO x_txn_currency_code
2870: FROM fnd_currencies_tl
2871: WHERE name = replace(p_currency_code_name, currency_code || ' - ')
2872: AND language = USERENV('LANG');
2873:
2874: ELSE

Line 12122: ,p_txn_currency_code IN fnd_currencies.currency_code%TYPE

12118: FUNCTION Check_delete_txn_cur_ok(
12119: p_project_id IN pa_projects_all.project_id%TYPE
12120: ,p_context IN VARCHAR2 -- FINPLAN or WORKPLAN
12121: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
12122: ,p_txn_currency_code IN fnd_currencies.currency_code%TYPE
12123: ) RETURN VARCHAR2
12124: IS
12125: l_delete_ok_flag varchar2(1);
12126: