DBA Data[Home] [Help]

APPS.PA_PROJECT_STRUCTURE_PUB1 dependencies on PA_PROJECT_CUSTOMERS

Line 4325: FROM PA_PROJECT_CUSTOMERS

4321:
4322: /* This Cursor checks if the project has inter project billing */
4323: CURSOR C_CHECK_INTER_PROJ_BILL_EXISTS IS
4324: SELECT BILL_ANOTHER_PROJECT_FLAG
4325: FROM PA_PROJECT_CUSTOMERS
4326: WHERE PROJECT_ID=p_project_id;
4327:
4328: /* This Cursor checks if the project is used as Reciever Project for Inter project billing */
4329: CURSOR C_CHECK_PROJ_IS_RECIEVER IS

Line 4331: (Select Null from PA_PROJECT_CUSTOMERS

4327:
4328: /* This Cursor checks if the project is used as Reciever Project for Inter project billing */
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 */