APPS.PA_PPR_ROLLUP_ACTUAL_PVT dependencies on DUAL

Line 1648: FROM DUAL

1644: ----
1645: ,0,0,0,0,0
1646: ,0,0,0,0,0
1647: ,0,0,0,0,0
1648: FROM DUAL
1649: )
1650: WHERE PROJECT_ID = p_project_id
1651: AND PROJECT_ELEMENT_ID = p_fact_task_arr(i) and p_fact_slice = 'WBS'
1652: AND WBS_ROLLUP_FLAG = 'Y'

Line 1726: FROM DUAL

1722: ----
1723: ,0,0,0,0,0
1724: ,0,0,0,0,0
1725: ,0,0,0,0,0
1726: FROM DUAL
1727: )
1728: WHERE PROJECT_ID = p_project_id
1729: AND PROJECT_ELEMENT_ID = p_fact_task_arr(i) and p_fact_slice = 'WBS'
1730: AND WBS_ROLLUP_FLAG = 'Y'

Line 1799: FROM DUAL

1795: ----
1796: ,0,0,0,0,0
1797: ,0,0,0,0,0
1798: ,0,0,0,0,0
1799: FROM DUAL
1800: )
1801: WHERE PROJECT_ID = p_project_id
1802: AND rbs_cbs_element_id = p_fact_task_arr(i) and p_fact_slice = 'RBS'
1803: AND RBS_AGGR_LEVEL = 'Y'

Line 1878: FROM DUAL

1874: ----
1875: ,0,0,0,0,0
1876: ,0,0,0,0,0
1877: ,0,0,0,0,0
1878: FROM DUAL
1879: )
1880: WHERE PROJECT_ID = p_project_id
1881: AND rbs_cbs_element_id = p_fact_task_arr(i) and p_fact_slice = 'RBS'
1882: AND RBS_AGGR_LEVEL = 'Y'

Line 1993: from dual

1989: ----
1990: ,0,0,0,0,0
1991: ,0,0,0,0,0
1992: ,0,0,0,0,0
1993: from dual
1994: where l_ins_task_flag_arr(i) = 'Y';
1995:
1996:
1997:

Line 2067: from dual

2063: ----
2064: ,0,0,0,0,0
2065: ,0,0,0,0,0
2066: ,0,0,0,0,0
2067: from dual
2068: where l_ins_task_flag_arr(i) = 'Y';
2069:
2070: end if;
2071: