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_PROJECT_DATES_UTILS dependencies on PA_PROJECT_ASSIGNMENTS

Line 907: FROM pa_project_assignments

903:
904: CURSOR l_res_dt_minmax_csr (l_proj_id NUMBER)
905: IS
906: SELECT min(start_date), max(end_date)
907: FROM pa_project_assignments
908: WHERE project_id = l_proj_id
909: AND assignment_type IN ('OPEN_ASSIGNMENT', 'STAFFED_ASSIGNMENT');
910:
911: CURSOR l_tsk_dt_minmax_csr (l_proj_id NUMBER) -- Added for bug6866666

Line 1000: FROM pa_project_assignments

996:
997: CURSOR l_res_dt_minmax_csr (l_proj_id NUMBER)
998: IS
999: SELECT min(start_date), max(end_date)
1000: FROM pa_project_assignments
1001: WHERE project_id = l_proj_id
1002: AND assignment_type IN ('OPEN_ASSIGNMENT', 'STAFFED_ASSIGNMENT');
1003:
1004: CURSOR get_structure

Line 1511: FROM pa_project_assignments

1507:
1508: CURSOR l_templ_dt_minmax_csr (l_template_id NUMBER)
1509: IS
1510: SELECT min(start_date), max(end_date)
1511: FROM pa_project_assignments
1512: WHERE assignment_template_id = l_template_id
1513: AND project_id IS NULL ; -- added this for bug 7638712
1514:
1515: /*Fix for Bug 6856082 starts*/