103: SELECT DISTINCT ccg.cost_group_id,
104: ccg.legal_entity
105: INTO x_cost_group_id,
106: x_legal_entity
107: FROM cst_cost_groups ccg,
108: cst_cost_group_assignments ccga
109: WHERE ccg.cost_group_id = ccga.cost_group_id
110: AND ccg.cost_group_type = 2
111: AND ccg.cost_group = ( SELECT cpici.cost_group
454: FROM cst_pc_item_cost_interface cpici
455: WHERE cpici.interface_header_id = x_interface_header_id )
456: AND clct.legal_entity =
457: (SELECT DISTINCT ccg.legal_entity
458: FROM cst_cost_groups ccg,
459: cst_cost_group_assignments ccga
460: WHERE ccg.cost_group_id = ccga.cost_group_id
461: AND ccg.cost_group_type = 2
462: AND ccg.cost_group =