DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_UTILS dependencies on PA_FP_TXN_CURRENCIES

Line 568: from pa_fp_txn_currencies

564: if l_multi_curr_flag = 'Y' then
565: begin
566: select fp_txn_currency_id
567: into l_txn_currency_id
568: from pa_fp_txn_currencies
569: where proj_fp_options_id = l_proj_fp_options_id --Sql Performance to avoid FTS fix sql id 16509328
570: and txn_currency_code = p_currency_code;
571: exception
572: When NO_DATA_FOUND THEN

Line 1077: FROM pa_fp_txn_currencies

1073:
1074:
1075: CURSOR C_TXN_CURR_CODE IS
1076: SELECT txn_currency_code
1077: FROM pa_fp_txn_currencies
1078: WHERE fin_plan_version_id = p_budget_version_id
1079: AND proj_fp_options_id = p_proj_fp_options_id ;
1080:
1081: BEGIN