APPS.CSTPPINV dependencies on CST_PAC_PERIODS

Line 347: FROM cst_pac_periods cpp,

343: IF (l_so_line_id IS NOT NULL) THEN
344: l_stmt_num := 75;
345: SELECT count(*)
346: INTO l_prior_period_shipment
347: FROM cst_pac_periods cpp,
348: oe_order_lines_all SO
349: WHERE cpp.pac_period_id = i_pac_period_id
350: AND cpp.period_start_date > SO.ACTUAL_SHIPMENT_DATE
351: AND SO.line_id = l_so_line_id;

Line 1871: FROM cst_pac_periods cpp

1867:
1868: /* Get prior period id */
1869: SELECT nvl(max(cpp.pac_period_id), -1)
1870: INTO l_prev_period_id
1871: FROM cst_pac_periods cpp
1872: WHERE cpp.cost_type_id = i_cost_type_id
1873: AND cpp.legal_entity = i_legal_entity
1874: AND cpp.pac_period_id < i_pac_period_id;
1875: