APPS.PO_HAZARD_CLASSES_SV1 dependencies on PO_HAZARD_CLASSES_VAL_V

Line 19: po_hazard_classes_val_v table */

15: BEGIN
16: x_progress := '010';
17:
18: /* check to see if there are x_hazard_class_id exists in
19: po_hazard_classes_val_v table */
20:
21: SELECT count(*)
22: INTO x_temp
23: FROM po_hazard_classes_val_v

Line 23: FROM po_hazard_classes_val_v

19: po_hazard_classes_val_v table */
20:
21: SELECT count(*)
22: INTO x_temp
23: FROM po_hazard_classes_val_v
24: WHERE hazard_class_id = x_hazard_class_id;
25:
26: IF x_temp = 0 THEN
27: RETURN FALSE; /* validation fails */

Line 60: FROM po_hazard_classes_val_v

56: based on hazard_class which is provided from input para. */
57:
58: SELECT hazard_class_id
59: INTO X_hazard_class_id_v
60: FROM po_hazard_classes_val_v
61: WHERE hazard_class = X_hazard_class;
62:
63: RETURN X_hazard_class_id_v;
64: