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_SCHEDULE_PVT dependencies on PA_RESOURCE_ASSIGNMENTS

Line 3646: from pa_budget_lines a, pa_resource_assignments b

3642: IS
3643:
3644: Cursor C_Periodic_dates1 IS
3645: select least(min(start_date), p_start_date), greatest(max(end_date), p_end_date)
3646: from pa_budget_lines a, pa_resource_assignments b
3647: where a.resource_assignment_id = b.resource_assignment_id
3648: and b.project_assignment_id = p_project_assignment_id
3649: and b.project_id = p_project_id
3650: and b.budget_version_id = p_budget_version_id

Line 3801: FROM pa_resource_assignments WHERE resource_assignment_id = p_task_assignment_id_tbl(1));

3797: BEGIN
3798: IF p_task_assignment_id_tbl.COUNT > 0 THEN
3799: SELECT ALIAS INTO l_alias_name FROM
3800: pa_resource_list_members WHERE RESOURCE_LIST_MEMBER_ID = (SELECT RESOURCE_LIST_MEMBER_ID
3801: FROM pa_resource_assignments WHERE resource_assignment_id = p_task_assignment_id_tbl(1));
3802: ELSE
3803: l_alias_name := NULL;
3804: END IF;
3805:

Line 7797: pa_resource_assignments c

7793: SELECT a.start_date, a.end_date, NVL(a.quantity,0),
7794: c.planning_start_date, c.planning_end_date -- 4367912
7795: FROM pa_budget_lines a,
7796: -- pa_projects_all b, -- Bug 5086869
7797: pa_resource_assignments c
7798: WHERE a.resource_assignment_id = c.resource_assignment_id
7799: AND c.resource_assignment_id = l_task_assignment_id;
7800: -- Bug 5086869 - In WP, there is only one currency
7801: -- so no need for currency join.