APPS.PA_PROJECT_STRUCTURE_PUB1 dependencies on PA_TASKS

Line 3306: FROM pa_tasks

3302: IS
3303:
3304: CURSOR C1 IS
3305: SELECT task_id
3306: FROM pa_tasks
3307: WHERE project_id = p_project_id
3308: AND top_task_id = task_id
3309: AND parent_task_id is NULL;
3310:

Line 4333: (Select Task_id From PA_TASKS Where project_id=p_project_id));

4329: CURSOR C_CHECK_PROJ_IS_RECIEVER IS
4330: SELECT 1 FROM SYS.DUAL WHERE EXISTS
4331: (Select Null from PA_PROJECT_CUSTOMERS
4332: where RECEIVER_TASK_ID in
4333: (Select Task_id From PA_TASKS Where project_id=p_project_id));
4334:
4335: /* This Cursor checks if any tasks has Reciever Project for Inter project billing */
4336: CURSOR C_CHECK_TASK_IS_RECIEVER IS
4337: SELECT 1 FROM SYS.DUAL WHERE EXISTS

Line 4338: (Select Null from PA_TASKS where PROJECT_ID=p_project_id

4334:
4335: /* This Cursor checks if any tasks has Reciever Project for Inter project billing */
4336: CURSOR C_CHECK_TASK_IS_RECIEVER IS
4337: SELECT 1 FROM SYS.DUAL WHERE EXISTS
4338: (Select Null from PA_TASKS where PROJECT_ID=p_project_id
4339: and RECEIVE_PROJECT_INVOICE_FLAG='Y');
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