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_CAPITAL_EVENTS_PVT dependencies on PA_TASKS

Line 512: FROM pa_tasks

508:
509: --Determine if any Retirement Cost Tasks exist for the current project
510: SELECT COUNT(*)
511: INTO v_ret_tasks_count
512: FROM pa_tasks
513: WHERE project_id = ac_projects_rec.project_id
514: AND NVL(retirement_cost_flag,'N') = 'Y';
515:
516: --Determine if any Retirement Adjustment Assets assets exist for the current project

Line 646: FROM pa_tasks

642:
643: CURSOR add_ei_tasks_cur(x_project_id NUMBER,
644: x_event_type VARCHAR2) IS
645: SELECT task_id
646: FROM pa_tasks
647: WHERE project_id = x_project_id
648: AND NVL(retirement_cost_flag,'N') = DECODE(x_event_type,'R','Y','N')
649: ORDER BY task_id;
650:

Line 661: pa_tasks t

657: paa.task_id, --Grouping Level: If = 0, asset is assigned to project
658: t.retirement_cost_flag task_retirement_cost_flag --Will be NULL if Task ID = 0
659: FROM pa_project_assets_all pa,
660: pa_project_asset_assignments paa,
661: pa_tasks t
662: WHERE pa.project_id = x_project_id
663: AND pa.project_asset_id = paa.project_asset_id
664: AND pa.capital_event_id IS NULL
665: AND pa.project_asset_type = DECODE(x_event_type,'C','AS-BUILT','RETIREMENT_ADJUSTMENT')

Line 681: pa_tasks t

677: paa.task_id assignment_task_id,
678: t.top_task_id,
679: t.parent_task_id
680: FROM pa_project_asset_assignments paa,
681: pa_tasks t
682: WHERE paa.project_id = x_project_id
683: AND NVL(t.retirement_cost_flag,'N') = DECODE(x_event_type,'R','Y','N')
684: AND paa.project_asset_id = 0
685: AND (paa.task_id = t.task_id

Line 695: pa_tasks t

691: CURSOR remaining_costs_cur(x_project_id NUMBER,
692: x_event_type VARCHAR2) IS
693: SELECT peia.task_id
694: FROM pa_expenditure_items_all peia,
695: pa_tasks t
696: WHERE peia.project_id = x_project_id
697: AND peia.task_id = t.task_id
698: AND t.project_id = x_project_id
699: AND NVL(t.retirement_cost_flag,'N') = DECODE(x_event_type,'R','Y','N')

Line 805: FROM pa_tasks

801: x_current_task_id NUMBER,
802: x_event_type VARCHAR2) IS
803: SELECT task_id,
804: task_number
805: FROM pa_tasks
806: WHERE task_id <> x_parent_task_id
807: AND task_id <> x_current_task_id
808: AND NVL(retirement_cost_flag,'N') = DECODE(x_event_type,'R','Y','N')
809: CONNECT BY parent_task_id = PRIOR task_id

Line 848: v_task_number pa_tasks.task_number%TYPE;

844: v_addtl_costs_or_assets VARCHAR2(1);
845: v_first_addtl VARCHAR2(1);
846: v_event_number pa_capital_events.capital_event_number%TYPE;
847: v_new_event_id pa_capital_events.capital_event_id%TYPE := NULL;
848: v_task_number pa_tasks.task_number%TYPE;
849: v_event_exists VARCHAR2(1);
850: v_asset_count NUMBER := 0;
851: v_ei_count NUMBER := 0;
852: v_top_task_id NUMBER := 0;

Line 965: pa_tasks t

961: /* Commented for the bug 3961059 :
962: SELECT COUNT(*)
963: INTO v_ei_count
964: FROM pa_expenditure_items_all ei,
965: pa_tasks t
966: WHERE ei.project_id = p_project_id
967: AND t.task_id = ei.task_id
968: AND NVL(t.retirement_cost_flag,'N') = DECODE(p_event_type,'R','Y','N')
969: AND ei.billable_flag = DECODE(p_event_type,'C','Y','N')

Line 984: pa_tasks t

980: INTO v_ei_count
981: From Dual Where Exists
982: (Select 1
983: FROM pa_expenditure_items_all ei,
984: pa_tasks t
985: WHERE ei.project_id = p_project_id
986: AND t.task_id = ei.task_id
987: AND NVL(t.retirement_cost_flag,'N') = DECODE(p_event_type,'R','Y','N')
988: AND ei.billable_flag = DECODE(p_event_type,'C','Y','N')

Line 1310: pa_tasks t

1306: /* Commented for bug 3961059
1307: SELECT COUNT(*)
1308: INTO v_ei_count
1309: FROM pa_expenditure_items_all peia,
1310: pa_tasks t
1311: WHERE peia.task_id = t.task_id
1312: AND peia.capital_event_id = capital_event_rec.capital_event_id
1313: AND peia.project_id = p_project_id
1314: AND (new_assets_rec.task_id = t.task_id

Line 1325: pa_tasks t

1321: INTO v_ei_count
1322: From Dual Where Exists
1323: ( Select 1
1324: FROM pa_expenditure_items_all peia,
1325: pa_tasks t
1326: WHERE peia.task_id = t.task_id
1327: AND peia.capital_event_id = capital_event_rec.capital_event_id
1328: AND peia.project_id = p_project_id
1329: AND (new_assets_rec.task_id = t.task_id

Line 1362: pa_tasks t

1358: --Look for new costs at the PROJECT grouping level (i.e., ANY expenditure items)
1359: SELECT COUNT(*)
1360: INTO v_ei_count
1361: FROM pa_expenditure_items_all peia,
1362: pa_tasks t
1363: WHERE peia.project_id = p_project_id
1364: AND peia.task_id = t.task_id
1365: AND NVL(t.retirement_cost_flag,'N') = DECODE(p_event_type,'R','Y','N')
1366: AND peia.billable_flag = DECODE(p_event_type,'C','Y','N')

Line 1378: pa_tasks t

1374: --Look for new costs at the TASK or TOP TASK grouping level
1375: SELECT COUNT(*)
1376: INTO v_ei_count
1377: FROM pa_expenditure_items_all peia,
1378: pa_tasks t
1379: WHERE peia.task_id = t.task_id
1380: AND NVL(t.retirement_cost_flag,'N') = DECODE(p_event_type,'R','Y','N')
1381: AND peia.project_id = p_project_id
1382: AND peia.billable_flag = DECODE(p_event_type,'C','Y','N')

Line 1429: FROM pa_tasks

1425: AND cost_distributed_flag = 'Y'
1426: AND (
1427: ((new_assets_rec.task_id = 0) AND task_id IN
1428: (SELECT task_id
1429: FROM pa_tasks
1430: WHERE project_id = p_project_id
1431: AND NVL(retirement_cost_flag,'N') = DECODE(p_event_type,'R','Y','N')))
1432: OR (task_id = new_assets_rec.task_id
1433: AND NVL(new_assets_rec.task_retirement_cost_flag,'N') = DECODE(p_event_type,'R','Y','N'))

Line 1436: FROM pa_tasks

1432: OR (task_id = new_assets_rec.task_id
1433: AND NVL(new_assets_rec.task_retirement_cost_flag,'N') = DECODE(p_event_type,'R','Y','N'))
1434: OR task_id IN
1435: (SELECT task_id
1436: FROM pa_tasks
1437: WHERE top_task_id = new_assets_rec.task_id
1438: AND NVL(retirement_cost_flag,'N') = DECODE(p_event_type,'R','Y','N'))
1439: );
1440: END IF; --New costs exist

Line 1458: pa_tasks t

1454: --Look for new costs at the PROJECT grouping level (i.e., ANY expenditure items)
1455: SELECT COUNT(*)
1456: INTO v_ei_count
1457: FROM pa_expenditure_items_all peia,
1458: pa_tasks t
1459: WHERE peia.project_id = p_project_id
1460: AND peia.task_id = t.task_id
1461: AND NVL(t.retirement_cost_flag,'N') = DECODE(p_event_type,'R','Y','N')
1462: AND peia.billable_flag = DECODE(p_event_type,'C','Y','N')

Line 1474: pa_tasks t

1470: --Look for new costs at the TASK or TOP TASK grouping level
1471: SELECT COUNT(*)
1472: INTO v_ei_count
1473: FROM pa_expenditure_items_all peia,
1474: pa_tasks t
1475: WHERE peia.task_id = t.task_id
1476: AND NVL(t.retirement_cost_flag,'N') = DECODE(p_event_type,'R','Y','N')
1477: AND peia.project_id = p_project_id
1478: AND peia.billable_flag = DECODE(p_event_type,'C','Y','N')

Line 1576: FROM pa_tasks

1572: AND cost_distributed_flag = 'Y'
1573: AND (
1574: ((new_assets_rec.task_id = 0) AND task_id IN
1575: (SELECT task_id
1576: FROM pa_tasks
1577: WHERE project_id = p_project_id
1578: AND NVL(retirement_cost_flag,'N') = DECODE(p_event_type,'R','Y','N')))
1579: OR (task_id = new_assets_rec.task_id
1580: AND NVL(new_assets_rec.task_retirement_cost_flag,'N') = DECODE(p_event_type,'R','Y','N'))

Line 1583: FROM pa_tasks

1579: OR (task_id = new_assets_rec.task_id
1580: AND NVL(new_assets_rec.task_retirement_cost_flag,'N') = DECODE(p_event_type,'R','Y','N'))
1581: OR task_id IN
1582: (SELECT task_id
1583: FROM pa_tasks
1584: WHERE top_task_id = new_assets_rec.task_id
1585: AND NVL(retirement_cost_flag,'N') = DECODE(p_event_type,'R','Y','N'))
1586: );
1587:

Line 1724: FROM pa_tasks

1720:
1721: --Get the Top Task ID
1722: SELECT top_task_id
1723: INTO v_top_task_id
1724: FROM pa_tasks
1725: WHERE task_id = remaining_costs_rec.task_id;
1726:
1727: --Look for assets in the event at the grouping level of the new costs
1728:

Line 1792: FROM pa_tasks

1788:
1789: --Get the task number
1790: SELECT task_number
1791: INTO v_task_number
1792: FROM pa_tasks
1793: WHERE task_id = remaining_costs_rec.task_id;
1794:
1795: --Print warning message
1796: INSERT INTO pa_cap_event_creation_v

Line 1957: FROM pa_tasks

1953:
1954: --Get the task number
1955: SELECT task_number
1956: INTO v_task_number
1957: FROM pa_tasks
1958: WHERE task_id = remaining_assets_rec.task_id;
1959:
1960: --Print warning message
1961: INSERT INTO pa_cap_event_creation_v

Line 2434: pa_tasks pt

2430: CURSOR task_assignments_cur (x_project_asset_id NUMBER) IS
2431: SELECT paa.project_asset_id,
2432: paa.task_id
2433: FROM pa_project_asset_assignments paa,
2434: pa_tasks pt
2435: WHERE pt.project_id = p_project_id
2436: AND paa.project_id = p_project_id
2437: AND paa.project_asset_id = x_project_asset_id
2438: AND pt.task_id = paa.task_id

Line 2547: pa_tasks t

2543: peia.task_id,
2544: t.top_task_id,
2545: t.parent_task_id
2546: FROM pa_expenditure_items_all peia,
2547: pa_tasks t
2548: WHERE t.project_id = p_project_id
2549: AND peia.task_id = t.task_id
2550: AND t.task_number
2551: BETWEEN NVL(p_task_number_from, t.task_number)

Line 2583: FROM pa_tasks

2579: x_current_task_id NUMBER,
2580: x_event_type VARCHAR2) IS
2581: SELECT task_id,
2582: task_number
2583: FROM pa_tasks
2584: WHERE task_id <> x_parent_task_id
2585: AND task_id <> x_current_task_id
2586: AND NVL(retirement_cost_flag,'N') = DECODE(x_event_type,'R','Y','N')
2587: CONNECT BY parent_task_id = PRIOR task_id