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 867: FROM pa_project_assignments

863:
864: CURSOR l_res_dt_minmax_csr (l_proj_id NUMBER)
865: IS
866: SELECT min(start_date), max(end_date)
867: FROM pa_project_assignments
868: WHERE project_id = l_proj_id
869: AND assignment_type IN ('OPEN_ASSIGNMENT', 'STAFFED_ASSIGNMENT');
870:
871: CURSOR l_tsk_dt_minmax_csr (l_proj_id NUMBER) -- Added for bug6866666

Line 960: FROM pa_project_assignments

956:
957: CURSOR l_res_dt_minmax_csr (l_proj_id NUMBER)
958: IS
959: SELECT min(start_date), max(end_date)
960: FROM pa_project_assignments
961: WHERE project_id = l_proj_id
962: AND assignment_type IN ('OPEN_ASSIGNMENT', 'STAFFED_ASSIGNMENT');
963:
964: CURSOR get_structure

Line 1169: FROM pa_project_assignments

1165:
1166: CURSOR l_templ_dt_minmax_csr (l_template_id NUMBER)
1167: IS
1168: SELECT min(start_date), max(end_date)
1169: FROM pa_project_assignments
1170: WHERE assignment_template_id = l_template_id ;
1171:
1172: /*Fix for Bug 6856082 starts*/
1173: CURSOR get_team_start_date(l_template_id NUMBER) IS