APPS.INV_EBI_ITEM_HELPER dependencies on PO_HAZARD_CLASSES_VL

Line 133: SELECT hazard_class_id INTO l_id from po_hazard_classes_vl

129: AND MIRVH.EFFECTIVITY_DATE < SYSDATE
130: AND decode(MIRVH.HIGH_DATE,SYSDATE,SYSDATE+1) > SYSDATE;
131: WHEN G_HAZARD_CLASS THEN
132: l_pk1 := ID_COL_VALUE('hazard_class',p_pk_col_name_val_pairs);
133: SELECT hazard_class_id INTO l_id from po_hazard_classes_vl
134: WHERE hazard_class = l_pk1;
135: WHEN G_ASSET_CATEGORY THEN
136: l_pk1 := ID_COL_VALUE('concatenated_segments',p_pk_col_name_val_pairs);
137: SELECT category_id INTO l_id FROM fa_categories_b_kfv

Line 210: FROM po_hazard_classes_vl

206: WHERE revision_id = l_pk1;
207: WHEN G_HAZARD_CLASS THEN
208: l_pk1 := ID_COL_VALUE('hazard_class_id',p_pk_col_name_val_pairs);
209: SELECT hazard_class INTO l_code
210: FROM po_hazard_classes_vl
211: WHERE hazard_class_id = l_pk1;
212: WHEN G_ASSET_CATEGORY THEN
213: l_pk1 := ID_COL_VALUE('category_id',p_pk_col_name_val_pairs);
214: SELECT concatenated_segments INTO l_code