DBA Data[Home] [Help]

APPS.PN_VAR_ABATEMENT_AMOUNT_PKG dependencies on PN_VAR_GRP_DATES_ALL

Line 388: FROM pn_var_grp_dates_all

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

Line 394: FROM pn_var_grp_dates_all

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;