APPS.GMP_HORIZONTAL_PDR_PKG dependencies on MSC_PLANS

Line 146: FROM msc_plans

142: -- This cursor select number of buckets in the plan.
143: -- -------------------------------------------------
144: CURSOR cur_bckt_start_date IS
145: SELECT trunc(curr_start_date)
146: FROM msc_plans
147: WHERE plan_id = G_plan_id;
148:
149: -- Vpedarla Bug:6784251 Modified the cursor
150: -- Vpedarla Bug:7257708 Modified the cursor. corrected the mistake done for bug: 6784251

Line 1319: FROM msc_plans

1315: -- add SS to gross req if plan type is SRO
1316: -- ----------------------------------------
1317:
1318: SELECT plan_type INTO l_plan_type
1319: FROM msc_plans
1320: WHERE plan_id = G_plan_id;
1321: -- -------------------------------
1322: -- Get the item segments, atp flag
1323: -- -------------------------------

Line 2005: FROM msc_plans

2001: g_error_stmt := NULL;
2002: g_incl_items_no_activity := p_incl_items_no_activity; -- Bug: 8486531 Vpedarla
2003:
2004: SELECT plan_type INTO l_plan_type
2005: FROM msc_plans
2006: WHERE plan_id = G_plan_id;
2007:
2008: gmp_debug_message(' l_plan_type '||l_plan_type);
2009:

Line 2023: 5) subtract the period_cutoff_date - curr_start_date (bucket start date from msc_plans)

2019: 1) get the week_cutoff_date.
2020: 2) find the seq number from msc_period_start_date table.
2021: 3) add the period seq number as entered by the user.
2022: 4) get the next_date column - 1 as the period cutoff date
2023: 5) subtract the period_cutoff_date - curr_start_date (bucket start date from msc_plans)
2024: 6) this gives the number of days. */
2025:
2026: -- vpedarla Bug: 8363786
2027: IF (G_week_bckt_cutoff_dt is not NULL) and (p_period_bucket > 0) THEN