DBA Data[Home] [Help]

APPS.PA_PROJ_TSK_UTILS dependencies on PA_DRAFT_REVENUE_ITEMS

Line 1414: FROM pa_draft_revenue_items

1410: cursor c1 is
1411: SELECT 1
1412: FROM sys.dual
1413: WHERE EXISTS (SELECT NULL
1414: FROM pa_draft_revenue_items
1415: WHERE project_id = x_project_id);
1416:
1417: cursor c2 is
1418: SELECT 1

Line 1421: FROM pa_draft_revenue_items

1417: cursor c2 is
1418: SELECT 1
1419: FROM sys.dual
1420: where exists (SELECT NULL
1421: FROM pa_draft_revenue_items
1422: where project_id = x_proj_id
1423: AND TASK_ID IN
1424: (SELECT TASK_ID
1425: FROM PA_TASKS

Line 1433: FROM pa_draft_revenue_items

1429: /* cursor c2 is
1430: SELECT 1
1431: FROM sys.dual
1432: where exists (SELECT NULL
1433: FROM pa_draft_revenue_items
1434: where project_id = x_proj_id
1435: AND TASK_ID IN
1436: (SELECT TASK_ID
1437: FROM PA_TASKS

Line 1448: FROM pa_draft_revenue_items

1444: cursor c3 is
1445: SELECT 1
1446: FROM sys.dual
1447: where exists (SELECT NULL
1448: FROM pa_draft_revenue_items
1449: where project_id = x_proj_id
1450: AND TASK_ID =x_task_id);
1451: c3_rec c3%rowtype;
1452: begin