APPS.PA_ASSIGNMENT_PROGRESS_PUB dependencies on DUAL

Line 416: SELECT 'x' FROM dual

412: PROJECT_ID = l_project_id;
413:
414: --This cursor to see if any progress record exists.
415: CURSOR c_if_progress_exists(l_object_id NUMBER, l_project_id NUMBER, l_structure_version_id NUMBER , c_cbs_element_id NUMBER) IS
416: SELECT 'x' FROM dual
417: WHERE EXISTS
418: (
419: SELECT 'y' FROM PA_PROGRESS_ROLLUP
420: WHERE OBJECT_ID = l_object_id

Line 2626: -- Bug 3696572 , we shd not be using l_etc_txn_raw_cost varables instead we shd sum up individual buckets

2622:
2623: -- IF c_if_progress_exists%NOTFOUND THEN
2624: IF nvl(l_progress_exists, 'N')='N' THEN
2625:
2626: -- Bug 3696572 , we shd not be using l_etc_txn_raw_cost varables instead we shd sum up individual buckets
2627: -- this is because l_etc_txn_raw_cost will be null if not passed from UI, in this case
2628: -- up in the code we default individual etc buckets, we shd use them
2629: /*l_etc_txn_raw_cost_this_period := NVL(l_etc_txn_raw_cost,0) - NVL(l_planned_raw_cost_txn_cur,0);
2630: l_etc_prj_raw_cost_this_period := NVL(l_etc_project_raw_cost,0) - NVL(l_planned_raw_cost_proj_cur,0);

Line 2628: -- up in the code we default individual etc buckets, we shd use them

2624: IF nvl(l_progress_exists, 'N')='N' THEN
2625:
2626: -- Bug 3696572 , we shd not be using l_etc_txn_raw_cost varables instead we shd sum up individual buckets
2627: -- this is because l_etc_txn_raw_cost will be null if not passed from UI, in this case
2628: -- up in the code we default individual etc buckets, we shd use them
2629: /*l_etc_txn_raw_cost_this_period := NVL(l_etc_txn_raw_cost,0) - NVL(l_planned_raw_cost_txn_cur,0);
2630: l_etc_prj_raw_cost_this_period := NVL(l_etc_project_raw_cost,0) - NVL(l_planned_raw_cost_proj_cur,0);
2631: l_etc_pfc_raw_cost_this_period := NVL(l_etc_projfunc_raw_cost,0) - NVL(l_planned_raw_cost_projfunc,0);
2632: l_etc_txn_bur_cost_this_period := NVL(l_etc_txn_bur_cost,0) - NVL(l_planned_bur_cost_txn_cur,0);