APPS.CSTPPINV dependencies on CST_PAC_PERIODS

Line 353: FROM cst_pac_periods cpp,

349: IF (l_so_line_id IS NOT NULL) THEN
350: l_stmt_num := 90;
351: SELECT count(*)
352: INTO l_prior_period_shipment
353: FROM cst_pac_periods cpp,
354: oe_order_lines_all SO
355: WHERE cpp.pac_period_id = i_pac_period_id
356: AND cpp.period_start_date > SO.ACTUAL_SHIPMENT_DATE
357: AND SO.line_id = l_so_line_id;

Line 1913: FROM cst_pac_periods cpp

1909:
1910: /* Get prior period id */
1911: SELECT nvl(max(cpp.pac_period_id), -1)
1912: INTO l_prev_period_id
1913: FROM cst_pac_periods cpp
1914: WHERE cpp.cost_type_id = i_cost_type_id
1915: AND cpp.legal_entity = i_legal_entity
1916: AND cpp.pac_period_id < i_pac_period_id;
1917: