DBA Data[Home] [Help]

APPS.CSTPPPOI dependencies on CST_PAC_PERIODS

Line 211: FROM cst_pac_periods cpp

207: l_stmt_num := 1;
208:
209: SELECT cpp.pac_period_id
210: INTO x_pac_period_id
211: FROM cst_pac_periods cpp
212: WHERE cpp.period_name = ( SELECT cpici.period_name
213: FROM cst_pc_item_cost_interface cpici
214: WHERE cpici.interface_header_id = x_interface_header_id )
215: AND cpp.pac_period_id =( SELECT MAX(cpp1.pac_period_id )

Line 216: FROM cst_pac_periods cpp1

212: WHERE cpp.period_name = ( SELECT cpici.period_name
213: FROM cst_pc_item_cost_interface cpici
214: WHERE cpici.interface_header_id = x_interface_header_id )
215: AND cpp.pac_period_id =( SELECT MAX(cpp1.pac_period_id )
216: FROM cst_pac_periods cpp1
217: WHERE cpp1.legal_entity = x_legal_entity
218: AND cpp1.cost_type_id = x_cost_type_id );
219:
220: