APPS.PA_ASSIGNMENT_PROGRESS_PUB dependencies on DUAL

Line 411: SELECT 'x' FROM dual

407: PROJECT_ID = l_project_id;
408:
409: --This cursor to see if any progress record exists.
410: CURSOR c_if_progress_exists(l_object_id NUMBER, l_project_id NUMBER, l_structure_version_id NUMBER) IS
411: SELECT 'x' FROM dual
412: WHERE EXISTS
413: (
414: SELECT 'y' FROM PA_PROGRESS_ROLLUP
415: WHERE OBJECT_ID = l_object_id

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

2507:
2508: -- IF c_if_progress_exists%NOTFOUND THEN
2509: IF nvl(l_progress_exists, 'N')='N' THEN
2510:
2511: -- Bug 3696572 , we shd not be using l_etc_txn_raw_cost varables instead we shd sum up individual buckets
2512: -- this is because l_etc_txn_raw_cost will be null if not passed from UI, in this case
2513: -- up in the code we default individual etc buckets, we shd use them
2514: /*l_etc_txn_raw_cost_this_period := NVL(l_etc_txn_raw_cost,0) - NVL(l_planned_raw_cost_txn_cur,0);
2515: l_etc_prj_raw_cost_this_period := NVL(l_etc_project_raw_cost,0) - NVL(l_planned_raw_cost_proj_cur,0);

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

2509: IF nvl(l_progress_exists, 'N')='N' THEN
2510:
2511: -- Bug 3696572 , we shd not be using l_etc_txn_raw_cost varables instead we shd sum up individual buckets
2512: -- this is because l_etc_txn_raw_cost will be null if not passed from UI, in this case
2513: -- up in the code we default individual etc buckets, we shd use them
2514: /*l_etc_txn_raw_cost_this_period := NVL(l_etc_txn_raw_cost,0) - NVL(l_planned_raw_cost_txn_cur,0);
2515: l_etc_prj_raw_cost_this_period := NVL(l_etc_project_raw_cost,0) - NVL(l_planned_raw_cost_proj_cur,0);
2516: l_etc_pfc_raw_cost_this_period := NVL(l_etc_projfunc_raw_cost,0) - NVL(l_planned_raw_cost_projfunc,0);
2517: l_etc_txn_bur_cost_this_period := NVL(l_etc_txn_bur_cost,0) - NVL(l_planned_bur_cost_txn_cur,0);