DBA Data[Home] [Help]

APPS.PA_COST dependencies on FND_CURRENCIES

Line 915: l_txn_currency_code fnd_currencies.currency_code%TYPE; /* Added for Org Forecasting */

911: l_txn_raw_cost NUMBER; /* Added for Org Forecasting */
912: l_txn_raw_cost_rate NUMBER; /* Added for Org Forecasting */
913: l_txn_burden_cost NUMBER; /* Added for Org Forecasting */
914: l_txn_burden_cost_rate NUMBER; /* Added for Org Forecasting */
915: l_txn_currency_code fnd_currencies.currency_code%TYPE; /* Added for Org Forecasting */
916: l_project_currency_code fnd_currencies.currency_code%TYPE; /* Added for Org Forecasting */
917: l_proj_func_curr_code fnd_currencies.currency_code%TYPE;
918: l_exp_func_curr_code fnd_currencies.currency_code%TYPE;
919: l_projfunc_rate_date DATE; /* changed the name of these varible for MCB 2 */

Line 916: l_project_currency_code fnd_currencies.currency_code%TYPE; /* Added for Org Forecasting */

912: l_txn_raw_cost_rate NUMBER; /* Added for Org Forecasting */
913: l_txn_burden_cost NUMBER; /* Added for Org Forecasting */
914: l_txn_burden_cost_rate NUMBER; /* Added for Org Forecasting */
915: l_txn_currency_code fnd_currencies.currency_code%TYPE; /* Added for Org Forecasting */
916: l_project_currency_code fnd_currencies.currency_code%TYPE; /* Added for Org Forecasting */
917: l_proj_func_curr_code fnd_currencies.currency_code%TYPE;
918: l_exp_func_curr_code fnd_currencies.currency_code%TYPE;
919: l_projfunc_rate_date DATE; /* changed the name of these varible for MCB 2 */
920: l_projfunc_rate_type VARCHAR2(30);

Line 917: l_proj_func_curr_code fnd_currencies.currency_code%TYPE;

913: l_txn_burden_cost NUMBER; /* Added for Org Forecasting */
914: l_txn_burden_cost_rate NUMBER; /* Added for Org Forecasting */
915: l_txn_currency_code fnd_currencies.currency_code%TYPE; /* Added for Org Forecasting */
916: l_project_currency_code fnd_currencies.currency_code%TYPE; /* Added for Org Forecasting */
917: l_proj_func_curr_code fnd_currencies.currency_code%TYPE;
918: l_exp_func_curr_code fnd_currencies.currency_code%TYPE;
919: l_projfunc_rate_date DATE; /* changed the name of these varible for MCB 2 */
920: l_projfunc_rate_type VARCHAR2(30);
921: l_x_projfunc_raw_cost NUMBER;

Line 918: l_exp_func_curr_code fnd_currencies.currency_code%TYPE;

914: l_txn_burden_cost_rate NUMBER; /* Added for Org Forecasting */
915: l_txn_currency_code fnd_currencies.currency_code%TYPE; /* Added for Org Forecasting */
916: l_project_currency_code fnd_currencies.currency_code%TYPE; /* Added for Org Forecasting */
917: l_proj_func_curr_code fnd_currencies.currency_code%TYPE;
918: l_exp_func_curr_code fnd_currencies.currency_code%TYPE;
919: l_projfunc_rate_date DATE; /* changed the name of these varible for MCB 2 */
920: l_projfunc_rate_type VARCHAR2(30);
921: l_x_projfunc_raw_cost NUMBER;
922: l_x_projfunc_raw_cost_rate NUMBER;

Line 1574: l_currency_code fnd_currencies.currency_code%TYPE;

1570:
1571: RETURN VARCHAR2
1572: IS
1573:
1574: l_currency_code fnd_currencies.currency_code%TYPE;
1575:
1576: BEGIN
1577:
1578: SELECT FC.currency_code

Line 1580: FROM FND_CURRENCIES FC,

1576: BEGIN
1577:
1578: SELECT FC.currency_code
1579: INTO l_currency_code
1580: FROM FND_CURRENCIES FC,
1581: GL_SETS_OF_BOOKS GB,
1582: PA_IMPLEMENTATIONS_ALL IMP
1583: WHERE FC.currency_code = DECODE(imp.set_of_books_id, NULL, NULL, GB.currency_code)
1584: AND GB.set_of_books_id = IMP.set_of_books_id

Line 2021: l_currency_code fnd_currencies.currency_code%TYPE;

2017:
2018: l_x_raw_cost_rate NUMBER;
2019: l_x_raw_cost NUMBER;
2020: l_to_job_id NUMBER;
2021: l_currency_code fnd_currencies.currency_code%TYPE;
2022:
2023: l_raw_cost_null EXCEPTION;
2024: l_conversion_fail EXCEPTION;
2025:

Line 2041: l_acct_currency_code fnd_currencies.currency_code%TYPE;

2037: /*LCE changes*/
2038: l_expend_organization_id pa_expenditures_all.incurred_by_organization_id%type;
2039: l_exp_org_id pa_expenditures_all.org_id%type; /*2879644*/
2040: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;
2041: l_acct_currency_code fnd_currencies.currency_code%TYPE;
2042: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;
2043: l_start_date_active date;
2044: l_end_date_active date;
2045: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;