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 5401: pa_resource_list_assignments prla

5397: IS
5398: cursor c_projects is
5399: select distinct part.project_id project_id
5400: from pa_alloc_run_targets part,
5401: pa_resource_list_assignments prla
5402: where part.project_id = prla.project_id
5403: and prla.resource_list_id = p_resource_list_id
5404: and prla.resource_list_accumulated_flag = 'Y'
5405: and part.run_id = p_run_id

Line 6125: pa_resource_list_assignments prla

6121: IS
6122: cursor c_projects is
6123: select distinct pars.project_id project_id
6124: from pa_alloc_run_sources pars,
6125: pa_resource_list_assignments prla
6126: where pars.project_id = prla.project_id
6127: and prla.resource_list_id = p_resource_list_id
6128: and prla.resource_list_accumulated_flag = 'Y'
6129: and pars.run_id = p_run_id