APPS.GMP_HORIZONTAL_PDR_PKG dependencies on MSC_PLANS

Line 143: FROM msc_plans

139: -- This cursor select number of buckets in the plan.
140: -- -------------------------------------------------
141: CURSOR cur_bckt_start_date IS
142: SELECT trunc(curr_start_date)
143: FROM msc_plans
144: WHERE plan_id = G_plan_id;
145:
146:
147:

Line 1301: FROM msc_plans

1297: -- add SS to gross req if plan type is SRO
1298: -- ----------------------------------------
1299:
1300: SELECT plan_type INTO l_plan_type
1301: FROM msc_plans
1302: WHERE plan_id = G_plan_id;
1303: -- -------------------------------
1304: -- Get the item segments, atp flag
1305: -- -------------------------------

Line 1963: FROM msc_plans

1959: g_num_of_buckets := 0;
1960: g_error_stmt := NULL;
1961:
1962: SELECT plan_type INTO l_plan_type
1963: FROM msc_plans
1964: WHERE plan_id = G_plan_id;
1965:
1966: g_error_stmt := 'Debug - populate_horizontal_plan - 10';
1967: FND_FILE.PUT_LINE ( FND_FILE.LOG,g_error_stmt);

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

1973: 1) get the week_cutoff_date.
1974: 2) find the seq number from msc_period_start_date table.
1975: 3) add the period seq number as entered by the user.
1976: 4) get the next_date column - 1 as the period cutoff date
1977: 5) subtract the period_cutoff_date - curr_start_date (bucket start date from msc_plans)
1978: 6) this gives the number of days. */
1979:
1980: OPEN cur_bckt_end_date;
1981: FETCH cur_bckt_end_date INTO l_bckt_end_date;