APPS.PA_RELATIONSHIP_UTILS dependencies on PA_PROJECTS_ALL

Line 1340: FROM pa_projects_all

1336: --
1337: -- Start of Bug 3621794
1338: CURSOR get_proj_prog_fl(c_project_id NUMBER) IS
1339: SELECT sys_program_flag
1340: FROM pa_projects_all
1341: WHERE project_id =c_project_id;
1342:
1343: CURSOR get_parent_sub_proj(c_project_id NUMBER) IS
1344: SELECT ppa.sys_program_flag

Line 1347: pa_projects_all ppa

1343: CURSOR get_parent_sub_proj(c_project_id NUMBER) IS
1344: SELECT ppa.sys_program_flag
1345: FROM pa_proj_element_versions ppev,
1346: pa_proj_elements ppe,
1347: pa_projects_all ppa
1348: WHERE ppe.project_id = ppev.project_id
1349: AND ppe.proj_element_id = ppev.proj_element_id
1350: AND ppev.object_type = 'PA_TASKS'
1351: AND ppe.object_type = 'PA_TASKS'

Line 1368: from pa_projects_all

1364: --
1365: --bug 3893970
1366: CURSOR get_multi_rollup(c_project_id NUMBER) IS
1367: select nvl(ALLOW_MULTI_PROGRAM_ROLLUP,'N')
1368: from pa_projects_all
1369: where project_id = c_project_id;
1370:
1371: CURSOR get_child_links(c_project_id NUMBER, c_parent_proj_id NUMBER) IS
1372: select distinct(object_id_from2)

Line 1941: from pa_projects_all

1937: , p_dest_project_id NUMBER) return VARCHAR2
1938: IS
1939: CURSOR get_proj_curr_code(c_project_id NUMBER) IS
1940: select project_currency_code
1941: from pa_projects_all
1942: where project_id = C_project_id;
1943: l_src_proj_currency_code VARCHAR2(15);
1944: l_dest_proj_currency_code VARCHAR2(15);
1945: BEGIN