10762: ELSE -- g_extract_type is TP4 or TP2
10763:
10764: -- CROSSPER:check the extract type and set the dates
10765: IF (g_extract_type = 'TP2' ) THEN
10766: l_eff_start_date := pqp_gb_tp_type2_functions.g_effective_start_date;
10767: l_eff_end_date := pqp_gb_tp_type2_functions.g_effective_end_date;
10768: ELSIF (g_extract_type = 'TP4' ) THEN
10769: l_eff_start_date := pqp_gb_tp_pension_extracts.g_last_effective_date ;
10770: l_eff_end_date := pqp_gb_tp_pension_extracts.g_effective_run_date ;
10763:
10764: -- CROSSPER:check the extract type and set the dates
10765: IF (g_extract_type = 'TP2' ) THEN
10766: l_eff_start_date := pqp_gb_tp_type2_functions.g_effective_start_date;
10767: l_eff_end_date := pqp_gb_tp_type2_functions.g_effective_end_date;
10768: ELSIF (g_extract_type = 'TP4' ) THEN
10769: l_eff_start_date := pqp_gb_tp_pension_extracts.g_last_effective_date ;
10770: l_eff_end_date := pqp_gb_tp_pension_extracts.g_effective_run_date ;
10771: END IF;