APPS.PA_PROJECT_STRUCTURE_PUB1 dependencies on PA_PROJECTS_ALL

Line 3410: SELECT B.PROJ_ELEMENT_ID INTO l_proj_element_id FROM PA_PROJECTS_ALL A,PA_PROJ_STRUCTURE_TYPES B,PA_PROJ_ELEMENTS C

3406: x_msg_data => l_msg_data,
3407: x_return_status => l_return_status);
3408:
3409: /* hsiu: 3305199
3410: SELECT B.PROJ_ELEMENT_ID INTO l_proj_element_id FROM PA_PROJECTS_ALL A,PA_PROJ_STRUCTURE_TYPES B,PA_PROJ_ELEMENTS C
3411: WHERE A.PROJECT_ID = C.PROJECT_ID
3412: AND B.PROJ_ELEMENT_ID = C.PROJ_ELEMENT_ID
3413: AND B.PROJ_STRUCTURE_TYPE_ID = 6
3414: AND A.PROJECT_ID = P_PROJECT_ID;

Line 4235: FROM PA_PROJECTS_ALL

4231: /* Cursor to check baseline funding with out budget option bug#16772073*/
4232: CURSOR C_BL_FUND_BUD_EXISTS IS
4233: SELECT 1 FROM SYS.DUAL WHERE EXISTS
4234: (SELECT NULL
4235: FROM PA_PROJECTS_ALL
4236: WHERE PROJECT_ID=p_project_id
4237: AND baseline_funding_flag = 'Y');
4238:
4239: /* Cursor to check resource assignments */

Line 4256: FROM PA_PROJECTS_ALL

4252:
4253: /* This Cursor checks if the project is enabled for program link */
4254: CURSOR C_GET_LINK_PROGRAM_FLAG IS
4255: SELECT SYS_PROGRAM_FLAG
4256: FROM PA_PROJECTS_ALL
4257: WHERE PROJECT_ID=p_project_id;
4258:
4259: /* This Cursor checks if the project is form based budgets */
4260: CURSOR C_CHECK_FORM_BASED_BUDGET IS

Line 4269: FROM PA_PROJECTS_ALL

4265: /* This Cursor checks if the project tax task id */
4266: CURSOR C_CHECK_TAX_TASK_ID_EXISTS IS
4267: SELECT 1 FROM SYS.DUAL WHERE EXISTS
4268: (SELECT NULL
4269: FROM PA_PROJECTS_ALL
4270: WHERE PROJECT_ID=p_project_id
4271: and CC_TAX_TASK_ID is not null);
4272:
4273: /* This Cursor checks if the project has purchase order distribution */

Line 4344: Project_Type = (Select PROJECT_TYPE from PA_PROJECTS_ALL where project_id=p_project_id);

4340:
4341: /* This Cursor checks if project has been defined from a project type which has the Burden Accounted on a different Project-Task */
4342: CURSOR C_CHECK_PROJ_BURDEN_ACC IS
4343: select NVL(BURDEN_ACCOUNT_FLAG,'N') from PA_PROJECT_TYPES_ALL where
4344: Project_Type = (Select PROJECT_TYPE from PA_PROJECTS_ALL where project_id=p_project_id);
4345:
4346:
4347:
4348: L_DUMMY NUMBER(1);