APPS.GR_ITEM_PROPERTIES_PUB dependencies on GR_LABELS_B

Line 126: GR_LABELS_B B

122:
123: CURSOR c_get_field_name is
124: SELECT 1
125: FROM
126: GR_LABELS_B B
127: where B.LABEL_CODE = l_field_name_code;
128:
129: cursor c_val_fname is
130: SELECT lcb.form_block

Line 132: GR_LABELS_B B , gr_label_classes_b lcb

128:
129: cursor c_val_fname is
130: SELECT lcb.form_block
131: FROM
132: GR_LABELS_B B , gr_label_classes_b lcb
133: where B.LABEL_CODE = l_field_name_code and
134: lcb.label_class_code = b.label_class_code
135: and lcb.form_block in ('SAFETY_PHRASES', 'RISK_PHRASES' );
136:

Line 337: -- Validate that the value of Field Name code exists in the table GR_LABELS_B.

333: RAISE loop_exception;
334: END IF;
335:
336:
337: -- Validate that the value of Field Name code exists in the table GR_LABELS_B.
338: -- If it does not, write an error to the log file
339:
340: OPEN c_get_field_name;
341: FETCH c_get_field_name INTO dummy;