384: p_date_type IN VARCHAR2)
385: RETURN DATE IS
386: CURSOR csr_min_gd IS
387: SELECT MIN(grp_start_date)
388: FROM pn_var_grp_dates_all
389: WHERE invoice_date = p_invoice_date
390: AND period_id = p_period_id;
391:
392: CURSOR csr_max_gd IS
390: AND period_id = p_period_id;
391:
392: CURSOR csr_max_gd IS
393: SELECT MAX(grp_end_date)
394: FROM pn_var_grp_dates_all
395: WHERE invoice_date = p_invoice_date
396: AND period_id = p_period_id;
397:
398: l_grp_date DATE;