eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_MULTI_CURRENCY_TXN dependencies on PA_IMPLEMENTATIONS_ALL

Line 102: ,pa_implementations_all imp_prvdr

98: ,NVL(proj.projfunc_cost_rate_date, DECODE(imp_prvdr.default_rate_date_code,
99: 'E', P_EI_date, 'P'
100: ,pa_utils2.get_pa_date(P_EI_date,sysdate, imp_prvdr.org_id))) PROJFUNC_COST_RATE_DATE
101: FROM pa_projects_all proj
102: ,pa_implementations_all imp_prvdr
103: ,pa_implementations_all imp_recvr /* bug fix :2322364 */
104: WHERE proj.project_id = P_project_id
105: AND imp_prvdr.org_id = P_exp_org_id
106: AND proj.org_id = imp_recvr.org_id; /* bug fix :2322364 */

Line 103: ,pa_implementations_all imp_recvr /* bug fix :2322364 */

99: 'E', P_EI_date, 'P'
100: ,pa_utils2.get_pa_date(P_EI_date,sysdate, imp_prvdr.org_id))) PROJFUNC_COST_RATE_DATE
101: FROM pa_projects_all proj
102: ,pa_implementations_all imp_prvdr
103: ,pa_implementations_all imp_recvr /* bug fix :2322364 */
104: WHERE proj.project_id = P_project_id
105: AND imp_prvdr.org_id = P_exp_org_id
106: AND proj.org_id = imp_recvr.org_id; /* bug fix :2322364 */
107:

Line 259: pa_implementations_all imp

255: INTO P_projfunc_currency_code,
256: P_projfunc_cost_rate_type
257: FROM pa_projects_all proj,
258: pa_tasks task,
259: pa_implementations_all imp
260: WHERE proj.project_id = task.project_id
261: AND task.task_id = P_task_id
262: AND NVL(proj.org_id, -99) = NVL(imp.org_id, -99);
263: ELSE

Line 273: pa_implementations_all imp

269: P_projfunc_cost_rate_type
270: FROM pa_projects_all proj,
271: pa_tasks task,
272: pa_map_wp_to_fin_tasks_v map_wp_fin,
273: pa_implementations_all imp
274: WHERE proj.project_id = map_wp_fin.project_id
275: AND task.task_id(+) = map_wp_fin.mapped_fin_task_id
276: AND map_wp_fin.proj_element_id = p_task_id
277: AND NVL(proj.org_id, -99) = NVL(imp.org_id, -99);

Line 288: pa_implementations_all imp

284: P_projfunc_cost_rate_type
285: FROM pa_projects_all proj,
286: pa_tasks task,
287: pa_map_wp_to_fin_tasks_v map_wp_fin,
288: pa_implementations_all imp
289: WHERE proj.project_id = p_project_id
290: AND task.task_id = map_wp_fin.mapped_fin_task_id
291: AND map_wp_fin.proj_element_id = p_task_id
292: AND map_wp_fin.parent_structure_version_id = p_structure_version_id

Line 303: pa_implementations_all imp

299: , imp.default_rate_type))
300: INTO P_projfunc_currency_code,
301: P_projfunc_cost_rate_type
302: FROM pa_projects_all proj,
303: pa_implementations_all imp
304: WHERE proj.project_id = p_project_id
305: AND NVL(proj.org_id, -99) = NVL(imp.org_id, -99);
306: END; -- anonymous
307: END IF;

Line 349: pa_implementations_all imp -- bug 8265941 changed to pa_implementations_all

345: INTO P_projfunc_currency_code,
346: P_projfunc_cost_rate_type
347: FROM pa_projects_all proj,
348: pa_tasks task,
349: pa_implementations_all imp -- bug 8265941 changed to pa_implementations_all
350: WHERE proj.project_id = task.project_id
351: AND task.task_id = P_task_id
352: AND NVL(proj.org_id,-99) = NVL(imp.org_id,-99); -- bug 7579126
353:

Line 433: pa_implementations_all imp -- bug 8265941 changed to pa_implementations_all

429: sysdate, imp.org_id))) /**CBGA**/
430: INTO P_projfunc_cost_rate_date
431: FROM pa_projects_all proj,
432: pa_tasks task,
433: pa_implementations_all imp -- bug 8265941 changed to pa_implementations_all
434: WHERE task.task_id = P_task_id
435: AND proj.project_id = task.project_id
436: AND NVL(proj.org_id,-99) = NVL(imp.org_id,-99); -- bug 7579126
437: ELSE

Line 458: ,pa_implementations_all imp -- bug 8265941 changed to pa_implementations_all

454: pa_utils2.get_pa_date(P_EI_date,
455: sysdate, imp.org_id)))
456: INTO P_projfunc_cost_rate_date
457: FROM pa_projects_all proj
458: ,pa_implementations_all imp -- bug 8265941 changed to pa_implementations_all
459: WHERE proj.project_id = p_project_id
460: AND NVL(proj.org_id,-99) = NVL(imp.org_id,-99); -- bug 7579126
461: END IF;
462: END IF; -- calling_module

Line 513: pa_implementations_all imp -- bug 8265941 changed to pa_implementations_all

509: NULL))
510: INTO P_projfunc_cost_rate_date
511: FROM pa_projects_all proj,
512: pa_tasks task,
513: pa_implementations_all imp -- bug 8265941 changed to pa_implementations_all
514: WHERE task.task_id = P_task_id
515: AND proj.project_id = task.project_id
516: AND NVL(proj.org_id,-99) = NVL(imp.org_id,-99); -- bug 7579126
517: ELSE

Line 554: ,pa_implementations_all imp -- bug 8265941 changed to pa_implementations_all

550: DECODE(imp.default_rate_date_code,
551: 'E', P_EI_date, 'P', NULL))
552: INTO P_projfunc_cost_rate_date
553: FROM pa_projects_all proj
554: ,pa_implementations_all imp -- bug 8265941 changed to pa_implementations_all
555: WHERE proj.project_id = p_project_id
556: AND NVL(proj.org_id,-99) = NVL(imp.org_id,-99); -- bug 7579126
557: END IF;
558: END IF; -- calling_module

Line 2254: pa_implementations_all imp

2250: INTO P_project_currency_code,
2251: P_project_rate_type
2252: FROM pa_projects_all proj,
2253: pa_tasks task,
2254: pa_implementations_all imp
2255: WHERE proj.project_id = task.project_id
2256: AND task.task_id = P_task_id
2257: AND proj.org_id = imp.org_id;
2258:

Line 2271: pa_implementations_all imp

2267: P_project_rate_type
2268: FROM pa_projects_all proj,
2269: pa_tasks task,
2270: pa_map_wp_to_fin_tasks_v map_wp_fin,
2271: pa_implementations_all imp
2272: WHERE proj.project_id = p_project_id
2273: AND task.task_id = map_wp_fin.mapped_fin_task_id
2274: AND map_wp_fin.proj_element_id = p_task_id
2275: AND map_wp_fin.parent_structure_version_id = p_structure_version_id

Line 2286: pa_implementations_all imp

2282: , imp.default_rate_type)
2283: INTO P_project_currency_code,
2284: P_project_rate_type
2285: FROM pa_projects_all proj,
2286: pa_implementations_all imp
2287: WHERE proj.project_id = p_project_id
2288: AND proj.org_id = imp.org_id;
2289: END ; -- anonymous
2290:

Line 2341: pa_implementations_all imp

2337: sysdate, imp.org_id))) /**CBGA**/
2338: INTO P_project_rate_date
2339: FROM pa_projects_all proj,
2340: pa_tasks task,
2341: pa_implementations_all imp
2342: WHERE task.task_id = P_task_id
2343: AND proj.project_id = task.project_id
2344: AND nvl(proj.org_id, -99) = nvl(imp.org_id, -99);
2345: ELSE

Line 2367: ,pa_implementations_all imp

2363: pa_utils2.get_pa_date(P_EI_date,
2364: sysdate, imp.org_id)))
2365: INTO P_project_rate_date
2366: FROM pa_projects_all proj
2367: ,pa_implementations_all imp
2368: WHERE proj.project_id = p_project_id
2369: AND nvl(proj.org_id, -99) = nvl(imp.org_id, -99);
2370: END IF;
2371: END IF; -- calling_module