DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_UTILS dependencies on FND_CURRENCIES

Line 2863: -- FROM fnd_currencies_vl

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

Line 2868: FROM fnd_currencies_tl

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

Line 12116: ,p_txn_currency_code IN fnd_currencies.currency_code%TYPE

12112: FUNCTION Check_delete_txn_cur_ok(
12113: p_project_id IN pa_projects_all.project_id%TYPE
12114: ,p_context IN VARCHAR2 -- FINPLAN or WORKPLAN
12115: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
12116: ,p_txn_currency_code IN fnd_currencies.currency_code%TYPE
12117: ) RETURN VARCHAR2
12118: IS
12119: l_delete_ok_flag varchar2(1);
12120: