APPS.PN_VAR_DEFAULTS_PKG dependencies on PN_VAR_GRP_DATES_ALL

Line 576: from pn_var_grp_dates_all

572:
573: CURSOR c_rep_periods(p_period_id NUMBER)
574: IS
575: select count(grp_start_date)
576: from pn_var_grp_dates_all
577: where period_id = p_period_id;
578:
579: CURSOR line_exists_cur ( ip_period_id NUMBER,ip_item_category_code VARCHAR2,ip_sales_type_code VARCHAR2)
580: IS

Line 1453: from pn_var_grp_dates_all

1449: from pn_var_transactions_all
1450: where var_rent_id = p_var_rent_id
1451: and prorated_group_sales is not null
1452: and grp_date_id in (select grp_date_id
1453: from pn_var_grp_dates_all
1454: where grp_start_date <= p_date );*/
1455:
1456: cursor csr_get_gd (p_grp_date_id NUMBER) IS
1457: select grp_start_date, grp_end_date

Line 1458: from pn_var_grp_dates_all

1454: where grp_start_date <= p_date );*/
1455:
1456: cursor csr_get_gd (p_grp_date_id NUMBER) IS
1457: select grp_start_date, grp_end_date
1458: from pn_var_grp_dates_all
1459: where grp_date_id = p_grp_date_id;
1460:
1461: l_start_date DATE;
1462: l_end_date DATE;

Line 1643: from pn_var_grp_dates_all

1639: from pn_var_transactions_all
1640: where var_rent_id = p_var_rent_id
1641: and prorated_group_sales is not null
1642: and grp_date_id in (select grp_date_id
1643: from pn_var_grp_dates_all
1644: where grp_end_date >= p_date)
1645: order by bkpt_start_date desc;*/
1646:
1647: cursor csr_get_gd (p_grp_date_id NUMBER) IS

Line 1649: from pn_var_grp_dates_all

1645: order by bkpt_start_date desc;*/
1646:
1647: cursor csr_get_gd (p_grp_date_id NUMBER) IS
1648: select grp_start_date, grp_end_date
1649: from pn_var_grp_dates_all
1650: where grp_date_id = p_grp_date_id;
1651:
1652: l_start_date DATE;
1653: l_end_date DATE;