1055: AND list_header_id = p_list_header_id;
1056:
1057: CURSOR c_get_list_headers(l_request_id number) IS
1058: SELECT list_header_id, list_name
1059: FROM ams_list_headers_vl
1060: WHERE request_id = l_request_id;
1061:
1062: l_list_header_id number;
1063: l_list_header_status varchar2(100);
1369:
1370:
1371: CURSOR c_get_list_headers(l_request_id number) IS
1372: SELECT list_header_id, list_name
1373: FROM ams_list_headers_vl
1374: WHERE request_id = l_request_id;
1375:
1376: l_list_header_id number;
1377: l_list_header_status varchar2(100);