APPS.PA_FIN_PLAN_PVT dependencies on DUAL

Line 344: FROM DUAL

340:
341: CURSOR c_chk_rej_codes
342: IS
343: SELECT 'Y'
344: FROM DUAL
345: WHERE EXISTS (SELECT 1
346: FROM pa_budget_lines pbl
347: WHERE pbl.budget_version_id = p_budget_version_id
348: AND( pbl.cost_rejection_code IS NOT NULL

Line 3045: --Populate the individual column tables so that we can do a bulk

3041: END IF;
3042:
3043: l_calling_context := p_calling_context; /* Bug# 2674353 */
3044:
3045: --Populate the individual column tables so that we can do a bulk
3046: --insert into resource assignments table.
3047:
3048: IF nvl(p_budget_lines_tab.last,0) > 0 THEN
3049: FOR i in p_budget_lines_tab.first..p_budget_lines_tab.last LOOP