DBA Data[Home] [Help]

APPS.PA_COST dependencies on FND_CURRENCIES

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

944: l_txn_raw_cost NUMBER; /* Added for Org Forecasting */
945: l_txn_raw_cost_rate NUMBER; /* Added for Org Forecasting */
946: l_txn_burden_cost NUMBER; /* Added for Org Forecasting */
947: l_txn_burden_cost_rate NUMBER; /* Added for Org Forecasting */
948: l_txn_currency_code fnd_currencies.currency_code%TYPE; /* Added for Org Forecasting */
949: l_project_currency_code fnd_currencies.currency_code%TYPE; /* Added for Org Forecasting */
950: l_proj_func_curr_code fnd_currencies.currency_code%TYPE;
951: l_exp_func_curr_code fnd_currencies.currency_code%TYPE;
952: l_projfunc_rate_date DATE; /* changed the name of these varible for MCB 2 */

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

945: l_txn_raw_cost_rate NUMBER; /* Added for Org Forecasting */
946: l_txn_burden_cost NUMBER; /* Added for Org Forecasting */
947: l_txn_burden_cost_rate NUMBER; /* Added for Org Forecasting */
948: l_txn_currency_code fnd_currencies.currency_code%TYPE; /* Added for Org Forecasting */
949: l_project_currency_code fnd_currencies.currency_code%TYPE; /* Added for Org Forecasting */
950: l_proj_func_curr_code fnd_currencies.currency_code%TYPE;
951: l_exp_func_curr_code fnd_currencies.currency_code%TYPE;
952: l_projfunc_rate_date DATE; /* changed the name of these varible for MCB 2 */
953: l_projfunc_rate_type VARCHAR2(30);

Line 950: l_proj_func_curr_code fnd_currencies.currency_code%TYPE;

946: l_txn_burden_cost NUMBER; /* Added for Org Forecasting */
947: l_txn_burden_cost_rate NUMBER; /* Added for Org Forecasting */
948: l_txn_currency_code fnd_currencies.currency_code%TYPE; /* Added for Org Forecasting */
949: l_project_currency_code fnd_currencies.currency_code%TYPE; /* Added for Org Forecasting */
950: l_proj_func_curr_code fnd_currencies.currency_code%TYPE;
951: l_exp_func_curr_code fnd_currencies.currency_code%TYPE;
952: l_projfunc_rate_date DATE; /* changed the name of these varible for MCB 2 */
953: l_projfunc_rate_type VARCHAR2(30);
954: l_x_projfunc_raw_cost NUMBER;

Line 951: l_exp_func_curr_code fnd_currencies.currency_code%TYPE;

947: l_txn_burden_cost_rate NUMBER; /* Added for Org Forecasting */
948: l_txn_currency_code fnd_currencies.currency_code%TYPE; /* Added for Org Forecasting */
949: l_project_currency_code fnd_currencies.currency_code%TYPE; /* Added for Org Forecasting */
950: l_proj_func_curr_code fnd_currencies.currency_code%TYPE;
951: l_exp_func_curr_code fnd_currencies.currency_code%TYPE;
952: l_projfunc_rate_date DATE; /* changed the name of these varible for MCB 2 */
953: l_projfunc_rate_type VARCHAR2(30);
954: l_x_projfunc_raw_cost NUMBER;
955: l_x_projfunc_raw_cost_rate NUMBER;

Line 1607: l_currency_code fnd_currencies.currency_code%TYPE;

1603:
1604: RETURN VARCHAR2
1605: IS
1606:
1607: l_currency_code fnd_currencies.currency_code%TYPE;
1608:
1609: BEGIN
1610:
1611: SELECT FC.currency_code

Line 1613: FROM FND_CURRENCIES FC,

1609: BEGIN
1610:
1611: SELECT FC.currency_code
1612: INTO l_currency_code
1613: FROM FND_CURRENCIES FC,
1614: GL_SETS_OF_BOOKS GB,
1615: PA_IMPLEMENTATIONS_ALL IMP
1616: WHERE FC.currency_code = DECODE(imp.set_of_books_id, NULL, NULL, GB.currency_code)
1617: AND GB.set_of_books_id = IMP.set_of_books_id

Line 2054: l_currency_code fnd_currencies.currency_code%TYPE;

2050:
2051: l_x_raw_cost_rate NUMBER;
2052: l_x_raw_cost NUMBER;
2053: l_to_job_id NUMBER;
2054: l_currency_code fnd_currencies.currency_code%TYPE;
2055:
2056: l_raw_cost_null EXCEPTION;
2057: l_conversion_fail EXCEPTION;
2058:

Line 2074: l_acct_currency_code fnd_currencies.currency_code%TYPE;

2070: /*LCE changes*/
2071: l_expend_organization_id pa_expenditures_all.incurred_by_organization_id%type;
2072: l_exp_org_id pa_expenditures_all.org_id%type; /*2879644*/
2073: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;
2074: l_acct_currency_code fnd_currencies.currency_code%TYPE;
2075: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;
2076: l_start_date_active date;
2077: l_end_date_active date;
2078: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;