APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on CST_PAC_EXPLOSION_TEMP

Line 2993: FROM cst_pac_explosion_temp cpet

2989: INTO l_min_child_absl_level_code
2990: FROM cst_pac_itms_absl_codes cpiac
2991: WHERE cpiac.pac_period_id = p_period_id
2992: AND cpiac.inventory_item_id IN (SELECT DISTINCT cpet.component_item_id
2993: FROM cst_pac_explosion_temp cpet
2994: WHERE cpet.pac_period_id = cpiac.pac_period_id
2995: AND cpet.assembly_item_id = items_in_current_absl_row.inventory_item_id
2996: AND cpet.component_item_id <> cpet.assembly_item_id
2997: );