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 2165: pa_implementations_all imp

2161: INTO P_project_currency_code,
2162: P_project_rate_type
2163: FROM pa_projects_all proj,
2164: pa_tasks task,
2165: pa_implementations_all imp
2166: WHERE proj.project_id = task.project_id
2167: AND task.task_id = P_task_id
2168: AND proj.org_id = imp.org_id;
2169:

Line 2182: pa_implementations_all imp

2178: P_project_rate_type
2179: FROM pa_projects_all proj,
2180: pa_tasks task,
2181: pa_map_wp_to_fin_tasks_v map_wp_fin,
2182: pa_implementations_all imp
2183: WHERE proj.project_id = p_project_id
2184: AND task.task_id = map_wp_fin.mapped_fin_task_id
2185: AND map_wp_fin.proj_element_id = p_task_id
2186: AND map_wp_fin.parent_structure_version_id = p_structure_version_id

Line 2197: pa_implementations_all imp

2193: , imp.default_rate_type)
2194: INTO P_project_currency_code,
2195: P_project_rate_type
2196: FROM pa_projects_all proj,
2197: pa_implementations_all imp
2198: WHERE proj.project_id = p_project_id
2199: AND proj.org_id = imp.org_id;
2200: END ; -- anonymous
2201:

Line 2252: pa_implementations_all imp

2248: sysdate, imp.org_id))) /**CBGA**/
2249: INTO P_project_rate_date
2250: FROM pa_projects_all proj,
2251: pa_tasks task,
2252: pa_implementations_all imp
2253: WHERE task.task_id = P_task_id
2254: AND proj.project_id = task.project_id
2255: AND nvl(proj.org_id, -99) = nvl(imp.org_id, -99);
2256: ELSE

Line 2278: ,pa_implementations_all imp

2274: pa_utils2.get_pa_date(P_EI_date,
2275: sysdate, imp.org_id)))
2276: INTO P_project_rate_date
2277: FROM pa_projects_all proj
2278: ,pa_implementations_all imp
2279: WHERE proj.project_id = p_project_id
2280: AND nvl(proj.org_id, -99) = nvl(imp.org_id, -99);
2281: END IF;
2282: END IF; -- calling_module