47: and deliverable_num = c_deliverable_num;
48:
49: cursor sts ( c_status_name varchar2 ) is
50: select lookup_code
51: from fnd_lookup_values_vl
52: where view_application_id = 777
53: and lookup_type = 'PRINT_FORM_STATUS'
54: and meaning = c_status_name;
55:
218: and print_form_code = p_header_rec.print_form_code;
219:
220: cursor sts is
221: select count(1)
222: from fnd_lookup_values_vl
223: where view_application_id = 777
224: and lookup_type = 'PRINT_FORM_STATUS'
225: and lookup_code = p_header_rec.status_code;
226: