DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PUB dependencies on PA_RESOURCE_ASGN_CURR_S

Line 8714: (pa_resource_asgn_curr_s.nextval,

8710: RESOURCE_ASSIGNMENT_ID,
8711: TXN_CURRENCY_CODE,
8712: expenditure_type)
8713: VALUES
8714: (pa_resource_asgn_curr_s.nextval,
8715: p_budget_version_id,
8716: l_def_plan_txn_ra_id_tbl(k),
8717: /*l_def_txn_curr_code); */
8718: nvl(l_curr_code_temp_tbl(k),l_def_txn_curr_code), /* janani */

Line 8721: -- The overriden rates present in pa_resource_asgn_curr should be retained.

8717: /*l_def_txn_curr_code); */
8718: nvl(l_curr_code_temp_tbl(k),l_def_txn_curr_code), /* janani */
8719: l_expenditure_type_tbl(k));
8720: --Start Bug 8223977
8721: -- The overriden rates present in pa_resource_asgn_curr should be retained.
8722: -- when resource is added using add row option .Updating the same in tmp table.
8723: OPEN rate_update_cur;
8724: FETCH rate_update_cur
8725: BULK COLLECT INTO