APPS.INV_EBI_ITEM_HELPER dependencies on PO_HAZARD_CLASSES_VL

Line 152: SELECT hazard_class_id INTO l_id from po_hazard_classes_vl

148: AND MIRVH.EFFECTIVITY_DATE < SYSDATE
149: AND decode(MIRVH.HIGH_DATE,SYSDATE,SYSDATE+1) > SYSDATE;
150: WHEN G_HAZARD_CLASS THEN
151: l_pk1 := ID_COL_VALUE('hazard_class',p_pk_col_name_val_pairs);
152: SELECT hazard_class_id INTO l_id from po_hazard_classes_vl
153: WHERE hazard_class = l_pk1;
154: WHEN G_ASSET_CATEGORY THEN
155: l_pk1 := ID_COL_VALUE('concatenated_segments',p_pk_col_name_val_pairs);
156: SELECT category_id INTO l_id FROM fa_categories_b_kfv

Line 232: FROM po_hazard_classes_vl

228: WHERE revision_id = l_pk1;
229: WHEN G_HAZARD_CLASS THEN
230: l_pk1 := ID_COL_VALUE('hazard_class_id',p_pk_col_name_val_pairs);
231: SELECT hazard_class INTO l_code
232: FROM po_hazard_classes_vl
233: WHERE hazard_class_id = l_pk1;
234: WHEN G_ASSET_CATEGORY THEN
235: l_pk1 := ID_COL_VALUE('category_id',p_pk_col_name_val_pairs);
236: SELECT concatenated_segments INTO l_code