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 5410: pa_rbs_prj_assignments prpa

5406: and Nvl(p_resource_struct_type,'RL') = 'RL'
5407: Union All
5408: select distinct part.project_id project_id
5409: from pa_alloc_run_targets part,
5410: pa_rbs_prj_assignments prpa
5411: where part.project_id = prpa.project_id
5412: and prpa.rbs_header_id = p_resource_list_id
5413: and prpa.rbs_version_id = p_rbs_version_id
5414: and part.run_id = p_run_id

Line 6134: pa_rbs_prj_assignments prpa

6130: and NVL(p_resource_struct_type,'RL') = 'RL'
6131: UNION All
6132: select distinct pars.project_id project_id
6133: from pa_alloc_run_sources pars,
6134: pa_rbs_prj_assignments prpa
6135: where pars.project_id = prpa.project_id
6136: and prpa.rbs_header_id = p_resource_list_id
6137: and prpa.rbs_version_id = p_rbs_version_id
6138: and pars.run_id = p_run_id