APPS.PA_BUDGET_PVT dependencies on PA_PERIOD_MASKS_B

Line 1917: -- by a check for existence of record in pa_period_masks_b

1913: */
1914:
1915: ---- Bug # 3507156
1916: -- Replaced the call to Pa_Prj_Period_Profile_Utils.Get_Curr_Period_Profile_Info
1917: -- by a check for existence of record in pa_period_masks_b
1918:
1919: ELSIF px_time_phased_code IN (PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,
1920: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G) THEN
1921: BEGIN

Line 1925: WHERE exists(SELECT 'X' FROM pa_period_masks_b WHERE trunc(sysdate) between EFFECTIVE_START_DATE

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:
1929: EXCEPTION

Line 1931: l_exists := 'N' ; /* No record exists in pa_period_masks_b */

1927: AND TIME_PHASE_CODE = px_time_phased_code); -- Bug # 3507156
1928:
1929: EXCEPTION
1930: WHEN no_data_found THEN
1931: l_exists := 'N' ; /* No record exists in pa_period_masks_b */
1932: l_any_error_occurred_flag := 'Y';
1933:
1934: PA_UTILS.ADD_MESSAGE
1935: (p_app_short_name => 'PA',