APPS.PA_ALLOC_RUN dependencies on PA_RBS_PRJ_ASSIGNMENTS

Line 41: From PA_RBS_PRJ_ASSIGNMENTS

37: AND resource_list_id = p_rl_id
38: AND P_resource_struct_type = 'RL'
39: UNION All
40: Select 1
41: From PA_RBS_PRJ_ASSIGNMENTS
42: Where Project_Id = p_project_id
43: And RBS_VERSION_ID = p_version_id
44: AND P_resource_struct_type = 'RBS' ;
45: -- ------------------------------------------------------------

Line 5433: pa_rbs_prj_assignments prpa

5429: and Nvl(p_resource_struct_type,'RL') = 'RL'
5430: Union All
5431: select distinct part.project_id project_id
5432: from pa_alloc_run_targets part,
5433: pa_rbs_prj_assignments prpa
5434: where part.project_id = prpa.project_id
5435: and prpa.rbs_header_id = p_resource_list_id
5436: and prpa.rbs_version_id = p_rbs_version_id
5437: and part.run_id = p_run_id

Line 6157: pa_rbs_prj_assignments prpa

6153: and NVL(p_resource_struct_type,'RL') = 'RL'
6154: UNION All
6155: select distinct pars.project_id project_id
6156: from pa_alloc_run_sources pars,
6157: pa_rbs_prj_assignments prpa
6158: where pars.project_id = prpa.project_id
6159: and prpa.rbs_header_id = p_resource_list_id
6160: and prpa.rbs_version_id = p_rbs_version_id
6161: and pars.run_id = p_run_id