APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_PERIODS

Line 631: FROM pa_periods

627:
628: BEGIN
629: SELECT end_date
630: INTO l_prev_accum_end_date
631: FROM pa_periods
632: WHERE period_name = l_prev_accum_period ;
633: EXCEPTION
634: WHEN OTHERS THEN
635: x_ret_flag := 'N' ;

Line 644: FROM pa_periods_v

640:
641: BEGIN
642: SELECT DISTINCT gl_end_date
643: INTO l_prev_accum_end_date
644: FROM pa_periods_v
645: WHERE gl_period_name = l_prev_accum_period ;
646: EXCEPTION
647: WHEN OTHERS THEN
648: x_ret_flag := 'N' ;

Line 684: FROM pa_periods

680: SELECT 'N'
681: INTO x_ret_flag
682: FROM dual
683: WHERE EXISTS (SELECT 'x'
684: FROM pa_periods
685: WHERE period_name =
686: l_prev_accum_period) ;
687: EXCEPTION
688: WHEN NO_DATA_FOUND THEN

Line 703: FROM pa_periods_v

699: SELECT 'N'
700: INTO x_ret_flag
701: FROM dual
702: WHERE EXISTS (SELECT 'x'
703: FROM pa_periods_v
704: WHERE gl_period_name =
705: l_prev_accum_period) ;
706: EXCEPTION
707: WHEN NO_DATA_FOUND THEN

Line 3187: FROM pa_periods

3183:
3184: IF ( x_start_pa_period IS NOT NULL ) THEN
3185: BEGIN
3186: SELECT start_date INTO x_start_pa_date
3187: FROM pa_periods
3188: WHERE period_name = x_start_pa_period;
3189:
3190: EXCEPTION
3191: WHEN NO_DATA_FOUND THEN

Line 3200: FROM pa_periods

3196: RETURN;
3197: END;
3198: BEGIN
3199: SELECT end_date INTO x_end_pa_date
3200: FROM pa_periods
3201: WHERE period_name = x_end_pa_period;
3202:
3203: EXCEPTION
3204: WHEN NO_DATA_FOUND THEN