DBA Data[Home] [Help]

APPS.PA_STRUCT_TASK_ROLLUP_PUB dependencies on PA_PROJECTS_ALL

Line 96: FROM pa_projects_all

92: --
93: cursor get_proj_attr_csr(c_project_id NUMBER)
94: IS
95: SELECT template_flag, record_version_number
96: FROM pa_projects_all
97: WHERE project_id = c_project_id;
98: --
99: l_structure_id NUMBER;
100: l_struc_project_id NUMBER;

Line 1218: FROM PA_PROJECTS_ALL

1214:
1215:
1216: CURSOR c_get_project_dates (l_project_id NUMBER) IS
1217: SELECT START_DATE, COMPLETION_DATE
1218: FROM PA_PROJECTS_ALL
1219: WHERE PROJECT_ID = l_project_id;
1220:
1221: --bug 4290472, rtarway
1222:

Line 1231: FROM pa_projects_all

1227:
1228: cursor get_proj_attr_csr(c_project_id NUMBER)
1229: IS
1230: SELECT template_flag, record_version_number
1231: FROM pa_projects_all
1232: WHERE project_id = c_project_id;
1233: -- End of changes
1234:
1235: cursor c1(c_child_element_id NUMBER) IS