706: IS
707:
708:
709: l_proj_org_id NUMBER;
710: l_proj_func_curr_code fnd_currencies.currency_code%TYPE;
711: l_exp_func_curr_code fnd_currencies.currency_code%TYPE;
712: l_proj_rate_date DATE;
713: l_proj_rate_type VARCHAR2(30);
714: l_x_proj_raw_cost NUMBER;
707:
708:
709: l_proj_org_id NUMBER;
710: l_proj_func_curr_code fnd_currencies.currency_code%TYPE;
711: l_exp_func_curr_code fnd_currencies.currency_code%TYPE;
712: l_proj_rate_date DATE;
713: l_proj_rate_type VARCHAR2(30);
714: l_x_proj_raw_cost NUMBER;
715: l_x_burden_raw_cost NUMBER;
1052:
1053: RETURN VARCHAR2
1054: IS
1055:
1056: l_currency_code fnd_currencies.currency_code%TYPE;
1057:
1058: BEGIN
1059:
1060: SELECT FC.currency_code
1058: BEGIN
1059:
1060: SELECT FC.currency_code
1061: INTO l_currency_code
1062: FROM FND_CURRENCIES FC,
1063: GL_SETS_OF_BOOKS GB,
1064: PA_IMPLEMENTATIONS_ALL IMP
1065: WHERE FC.currency_code = DECODE(imp.set_of_books_id, NULL, NULL, GB.currency_code)
1066: AND GB.set_of_books_id = IMP.set_of_books_id
1476:
1477: l_x_raw_cost_rate NUMBER;
1478: l_x_raw_cost NUMBER;
1479: l_to_job_id NUMBER;
1480: l_currency_code fnd_currencies.currency_code%TYPE;
1481:
1482: l_raw_cost_null EXCEPTION;
1483:
1484: l_proj_cost_job_id number;