APPS.PA_BUDGET_PVT dependencies on DUAL

Line 1924: FROM dual

1920: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G) THEN
1921: BEGIN
1922: SELECT 'Y'
1923: INTO l_exists
1924: FROM dual
1925: WHERE exists(SELECT 'X' FROM pa_period_masks_b WHERE trunc(sysdate) between EFFECTIVE_START_DATE
1926: AND nvl( EFFECTIVE_END_DATE,sysdate)
1927: AND TIME_PHASE_CODE = px_time_phased_code); -- Bug # 3507156
1928:

Line 4530: -- select DECODE(l_fp_type_id, null, 'Y','N') into l_old_model from dual;

4526: -- into l_fp_type_id
4527: -- from pa_budget_versions
4528: -- where budget_version_id = p_budget_version_id;
4529: --
4530: -- select DECODE(l_fp_type_id, null, 'Y','N') into l_old_model from dual;
4531: ----3569883 end
4532:
4533: --Bug 4224464: FP.M Changes for Validate_Budget_Lines
4534: --Send the budget version id to validate_budget_lines API for