APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_PERIODS

Line 637: FROM pa_periods

633:
634: BEGIN
635: SELECT end_date
636: INTO l_prev_accum_end_date
637: FROM pa_periods
638: WHERE period_name = l_prev_accum_period ;
639: EXCEPTION
640: WHEN OTHERS THEN
641: x_ret_flag := 'N' ;

Line 650: FROM pa_periods_v

646:
647: BEGIN
648: SELECT DISTINCT gl_end_date
649: INTO l_prev_accum_end_date
650: FROM pa_periods_v
651: WHERE gl_period_name = l_prev_accum_period ;
652: EXCEPTION
653: WHEN OTHERS THEN
654: x_ret_flag := 'N' ;

Line 690: FROM pa_periods

686: SELECT 'N'
687: INTO x_ret_flag
688: FROM dual
689: WHERE EXISTS (SELECT 'x'
690: FROM pa_periods
691: WHERE period_name =
692: l_prev_accum_period) ;
693: EXCEPTION
694: WHEN NO_DATA_FOUND THEN

Line 709: FROM pa_periods_v

705: SELECT 'N'
706: INTO x_ret_flag
707: FROM dual
708: WHERE EXISTS (SELECT 'x'
709: FROM pa_periods_v
710: WHERE gl_period_name =
711: l_prev_accum_period) ;
712: EXCEPTION
713: WHEN NO_DATA_FOUND THEN

Line 3250: FROM pa_periods

3246:
3247: IF ( x_start_pa_period IS NOT NULL ) THEN
3248: BEGIN
3249: SELECT start_date INTO x_start_pa_date
3250: FROM pa_periods
3251: WHERE period_name = x_start_pa_period;
3252:
3253: EXCEPTION
3254: WHEN NO_DATA_FOUND THEN

Line 3263: FROM pa_periods

3259: RETURN;
3260: END;
3261: BEGIN
3262: SELECT end_date INTO x_end_pa_date
3263: FROM pa_periods
3264: WHERE period_name = x_end_pa_period;
3265:
3266: EXCEPTION
3267: WHEN NO_DATA_FOUND THEN