DBA Data[Home] [Help]

APPS.PA_STRUCT_TASK_ROLLUP_PUB dependencies on PA_PROJECTS_ALL

Line 94: FROM pa_projects_all

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

Line 1171: FROM PA_PROJECTS_ALL

1167:
1168:
1169: CURSOR c_get_project_dates (l_project_id NUMBER) IS
1170: SELECT START_DATE, COMPLETION_DATE
1171: FROM PA_PROJECTS_ALL
1172: WHERE PROJECT_ID = l_project_id;
1173:
1174: --bug 4290472, rtarway
1175:

Line 1184: FROM pa_projects_all

1180:
1181: cursor get_proj_attr_csr(c_project_id NUMBER)
1182: IS
1183: SELECT template_flag, record_version_number
1184: FROM pa_projects_all
1185: WHERE project_id = c_project_id;
1186: -- End of changes
1187:
1188: cursor c1(c_child_element_id NUMBER) IS