APPS.PO_UN_NUMBERS_SV1 dependencies on PO_UN_NUMBERS_VAL_V

Line 18: /* check to see if x_un_number_id is valid in po_un_numbers_val_v */

14:
15: BEGIN
16: x_progress := '010';
17:
18: /* check to see if x_un_number_id is valid in po_un_numbers_val_v */
19:
20: SELECT count(*)
21: INTO x_temp
22: FROM po_un_numbers_val_v

Line 22: FROM po_un_numbers_val_v

18: /* check to see if x_un_number_id is valid in po_un_numbers_val_v */
19:
20: SELECT count(*)
21: INTO x_temp
22: FROM po_un_numbers_val_v
23: WHERE un_number_id = x_un_number_id;
24:
25: IF x_temp = 0 THEN
26: RETURN FALSE; /* validation fails */

Line 53: FROM po_un_numbers_val_v

49: /* get the group of un_number_id records */
50:
51: CURSOR c_un_number_id IS
52: SELECT un_number_id
53: FROM po_un_numbers_val_v
54: WHERE un_number = X_un_number;
55:
56: BEGIN
57: