3673: AND glp.application_id = Pa_Period_Process_Pkg.Application_id
3674: AND glp.adjustment_period_flag = 'N'
3675: AND p_completion_date BETWEEN pap.start_date and pap.end_date
3676: AND EXISTS (SELECT NULL
3677: FROM pa_lookups pal
3678: WHERE pal.lookup_type = 'CLOSING STATUS'
3679: AND pal.lookup_code = pap.status);
3680:
3681: IF g1_debug_mode = 'Y' THEN