APPS.PA_RELATIONSHIP_UTILS dependencies on PA_PROJECTS_ALL

Line 1325: FROM pa_projects_all

1321: --
1322: -- Start of Bug 3621794
1323: CURSOR get_proj_prog_fl(c_project_id NUMBER) IS
1324: SELECT sys_program_flag
1325: FROM pa_projects_all
1326: WHERE project_id =c_project_id;
1327:
1328: CURSOR get_parent_sub_proj(c_project_id NUMBER) IS
1329: SELECT ppa.sys_program_flag

Line 1332: pa_projects_all ppa

1328: CURSOR get_parent_sub_proj(c_project_id NUMBER) IS
1329: SELECT ppa.sys_program_flag
1330: FROM pa_proj_element_versions ppev,
1331: pa_proj_elements ppe,
1332: pa_projects_all ppa
1333: WHERE ppe.project_id = ppev.project_id
1334: AND ppe.proj_element_id = ppev.proj_element_id
1335: AND ppev.object_type = 'PA_TASKS'
1336: AND ppe.object_type = 'PA_TASKS'

Line 1353: from pa_projects_all

1349: --
1350: --bug 3893970
1351: CURSOR get_multi_rollup(c_project_id NUMBER) IS
1352: select nvl(ALLOW_MULTI_PROGRAM_ROLLUP,'N')
1353: from pa_projects_all
1354: where project_id = c_project_id;
1355:
1356: CURSOR get_child_links(c_project_id NUMBER, c_parent_proj_id NUMBER) IS
1357: select distinct(object_id_from2)

Line 1926: from pa_projects_all

1922: , p_dest_project_id NUMBER) return VARCHAR2
1923: IS
1924: CURSOR get_proj_curr_code(c_project_id NUMBER) IS
1925: select project_currency_code
1926: from pa_projects_all
1927: where project_id = C_project_id;
1928: l_src_proj_currency_code VARCHAR2(15);
1929: l_dest_proj_currency_code VARCHAR2(15);
1930: BEGIN