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_ALLOC_RUN dependencies on PA_RESOURCE_LIST_ASSIGNMENTS

Line 35: FROM pa_resource_list_assignments

31: G_Org_Id Number; /* F
32: /* Cursor Declarations --------------------------------------- */
33: CURSOR C_proj_in_RL (p_project_id IN NUMBER, p_rl_id IN NUMBER , p_resource_struct_type in Varchar2, p_version_id In Number ) IS
34: SELECT 1
35: FROM pa_resource_list_assignments
36: WHERE project_id = p_project_id
37: AND resource_list_id = p_rl_id
38: AND P_resource_struct_type = 'RL'
39: UNION All

Line 5424: pa_resource_list_assignments prla

5420: IS
5421: cursor c_projects is
5422: select distinct part.project_id project_id
5423: from pa_alloc_run_targets part,
5424: pa_resource_list_assignments prla
5425: where part.project_id = prla.project_id
5426: and prla.resource_list_id = p_resource_list_id
5427: and prla.resource_list_accumulated_flag = 'Y'
5428: and part.run_id = p_run_id

Line 6148: pa_resource_list_assignments prla

6144: IS
6145: cursor c_projects is
6146: select distinct pars.project_id project_id
6147: from pa_alloc_run_sources pars,
6148: pa_resource_list_assignments prla
6149: where pars.project_id = prla.project_id
6150: and prla.resource_list_id = p_resource_list_id
6151: and prla.resource_list_accumulated_flag = 'Y'
6152: and pars.run_id = p_run_id