APPS.PA_PROJ_TSK_UTILS dependencies on PA_COMMITMENT_TXNS

Line 1536: FROM pa_commitment_txns

1532: cursor c1 is
1533: SELECT 1
1534: FROM sys.dual
1535: WHERE EXISTS (SELECT NULL
1536: FROM pa_commitment_txns
1537: WHERE project_id = x_project_id);
1538:
1539: cursor c2 is
1540: SELECT 1

Line 1543: FROM pa_commitment_txns

1539: cursor c2 is
1540: SELECT 1
1541: FROM sys.dual
1542: where exists (SELECT NULL
1543: FROM pa_commitment_txns
1544: where project_id = x_proj_id
1545: AND TASK_ID IN
1546: (SELECT TASK_ID
1547: FROM PA_TASKS

Line 1556: FROM pa_commitment_txns

1552: /* cursor c2 is
1553: SELECT 1
1554: FROM sys.dual
1555: where exists (SELECT NULL
1556: FROM pa_commitment_txns
1557: where project_id = x_proj_id
1558: AND TASK_ID IN
1559: (SELECT TASK_ID
1560: FROM PA_TASKS

Line 1571: FROM pa_commitment_txns

1567: cursor c3 is
1568: SELECT 1
1569: FROM sys.dual
1570: where exists (SELECT NULL
1571: FROM pa_commitment_txns
1572: where project_id = x_proj_id
1573: AND TASK_ID = x_TASK_ID);
1574: c3_rec c3%rowtype;
1575: begin