eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_STRUCTURE_PUB1 dependencies on DUAL

Line 4233: SELECT 1 FROM SYS.DUAL WHERE EXISTS

4229: IS
4230:
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');

Line 4241: SELECT 1 FROM SYS.DUAL WHERE EXISTS

4237: AND baseline_funding_flag = 'Y');
4238:
4239: /* Cursor to check resource assignments */
4240: CURSOR C_RES_ASSIGNMENT_EXISTS IS
4241: SELECT 1 FROM SYS.DUAL WHERE EXISTS
4242: (SELECT NULL
4243: FROM PA_RESOURCE_ASSIGNMENTS
4244: WHERE PROJECT_ID=p_project_id);
4245:

Line 4248: SELECT 1 FROM SYS.DUAL WHERE EXISTS

4244: WHERE PROJECT_ID=p_project_id);
4245:
4246: /* Cursor to check Expenditure items */
4247: CURSOR C_CHECK_EXPENDITURE_ITEM IS
4248: SELECT 1 FROM SYS.DUAL WHERE EXISTS
4249: (SELECT NULL
4250: FROM PA_EXPENDITURE_ITEMS_ALL
4251: WHERE PROJECT_ID=p_project_id);
4252:

Line 4267: SELECT 1 FROM SYS.DUAL WHERE EXISTS

4263: WHERE PROJECT_ID=p_project_id;
4264:
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);

Line 4275: SELECT 1 FROM SYS.DUAL WHERE EXISTS

4271: and CC_TAX_TASK_ID is not null);
4272:
4273: /* This Cursor checks if the project has purchase order distribution */
4274: CURSOR C_CHECK_PO_DIST_EXISTS IS
4275: SELECT 1 FROM SYS.DUAL WHERE EXISTS
4276: (SELECT NULL
4277: FROM PO_DISTRIBUTIONS_ALL
4278: WHERE PROJECT_ID=p_project_id);
4279:

Line 4282: SELECT 1 FROM SYS.DUAL WHERE EXISTS

4278: WHERE PROJECT_ID=p_project_id);
4279:
4280: /* This Cursor checks if the project has purchase order requisition */
4281: CURSOR C_CHECK_PO_REQ_EXISTS IS
4282: SELECT 1 FROM SYS.DUAL WHERE EXISTS
4283: (SELECT NULL
4284: FROM PO_REQ_DISTRIBUTIONS_ALL
4285: WHERE PROJECT_ID=p_project_id);
4286:

Line 4289: SELECT 1 FROM SYS.DUAL WHERE EXISTS

4285: WHERE PROJECT_ID=p_project_id);
4286:
4287: /* This Cursor checks if the project has supplier invoices */
4288: CURSOR C_CHECK_AP_INVOICE_EXISTS IS
4289: SELECT 1 FROM SYS.DUAL WHERE EXISTS
4290: (SELECT NULL
4291: FROM AP_INVOICES_ALL
4292: WHERE PROJECT_ID=p_project_id);
4293:

Line 4296: SELECT 1 FROM SYS.DUAL WHERE EXISTS

4292: WHERE PROJECT_ID=p_project_id);
4293:
4294: /* This Cursor checks if the project has supplier invoices distribution */
4295: CURSOR C_CHECK_AP_INVOICE_DIST_EXISTS IS
4296: SELECT 1 FROM SYS.DUAL WHERE EXISTS
4297: (SELECT NULL
4298: FROM AP_INVOICE_DISTRIBUTIONS_ALL
4299: WHERE PROJECT_ID=p_project_id);
4300:

Line 4303: SELECT 1 FROM SYS.DUAL WHERE EXISTS

4299: WHERE PROJECT_ID=p_project_id);
4300:
4301: /* This Cursor checks if the project has commitment transaction */
4302: CURSOR C_CHECK_COMMIT_TXN_EXISTS IS
4303: SELECT 1 FROM SYS.DUAL WHERE EXISTS
4304: (SELECT NULL
4305: FROM PA_COMMITMENT_TXNS
4306: WHERE PROJECT_ID=p_project_id);
4307:

Line 4310: SELECT 1 FROM SYS.DUAL WHERE EXISTS

4306: WHERE PROJECT_ID=p_project_id);
4307:
4308: /* This Cursor checks if the project has iExpense records */
4309: CURSOR C_CHECK_iExpense_Rec_EXISTS IS
4310: SELECT 1 FROM SYS.DUAL WHERE EXISTS
4311: (SELECT NULL
4312: FROM AP_EXP_REPORT_DISTS_ALL
4313: WHERE PROJECT_ID=p_project_id);
4314:

Line 4317: SELECT 1 FROM SYS.DUAL WHERE EXISTS

4313: WHERE PROJECT_ID=p_project_id);
4314:
4315: /* This Cursor checks if the project has Inventory Transaction records */
4316: CURSOR C_CHECK_INV_TXN_EXISTS IS
4317: SELECT 1 FROM SYS.DUAL WHERE EXISTS
4318: (SELECT NULL
4319: FROM MTL_MATERIAL_TRANSACTIONS
4320: WHERE PROJECT_ID=p_project_id);
4321:

Line 4330: SELECT 1 FROM SYS.DUAL WHERE EXISTS

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
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:

Line 4337: SELECT 1 FROM SYS.DUAL WHERE EXISTS

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
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 */