APPS.GMD_QC_MIG12 dependencies on SY_DOCS_SEQ

Line 1179: CURSOR get_doc_info(v_orgn_code sy_docs_seq.orgn_code%TYPE, v_doc_type sy_docs_seq.doc_type%TYPE) IS

1175: /*=================================
1176: Cursor to get doc_seq and type
1177: =================================*/
1178:
1179: CURSOR get_doc_info(v_orgn_code sy_docs_seq.orgn_code%TYPE, v_doc_type sy_docs_seq.doc_type%TYPE) IS
1180: SELECT assignment_type, last_assigned
1181: FROM sy_docs_seq
1182: WHERE doc_type = v_doc_type
1183: AND orgn_code = v_orgn_code;

Line 1181: FROM sy_docs_seq

1177: =================================*/
1178:
1179: CURSOR get_doc_info(v_orgn_code sy_docs_seq.orgn_code%TYPE, v_doc_type sy_docs_seq.doc_type%TYPE) IS
1180: SELECT assignment_type, last_assigned
1181: FROM sy_docs_seq
1182: WHERE doc_type = v_doc_type
1183: AND orgn_code = v_orgn_code;
1184:
1185: l_smpl_assignment_type sy_docs_seq.assignment_type%TYPE;

Line 1185: l_smpl_assignment_type sy_docs_seq.assignment_type%TYPE;

1181: FROM sy_docs_seq
1182: WHERE doc_type = v_doc_type
1183: AND orgn_code = v_orgn_code;
1184:
1185: l_smpl_assignment_type sy_docs_seq.assignment_type%TYPE;
1186: l_smpl_last_assigned sy_docs_seq.last_assigned%TYPE;
1187: l_stbl_assignment_type sy_docs_seq.assignment_type%TYPE;
1188: l_stbl_last_assigned sy_docs_seq.last_assigned%TYPE;
1189:

Line 1186: l_smpl_last_assigned sy_docs_seq.last_assigned%TYPE;

1182: WHERE doc_type = v_doc_type
1183: AND orgn_code = v_orgn_code;
1184:
1185: l_smpl_assignment_type sy_docs_seq.assignment_type%TYPE;
1186: l_smpl_last_assigned sy_docs_seq.last_assigned%TYPE;
1187: l_stbl_assignment_type sy_docs_seq.assignment_type%TYPE;
1188: l_stbl_last_assigned sy_docs_seq.last_assigned%TYPE;
1189:
1190: /*==================================

Line 1187: l_stbl_assignment_type sy_docs_seq.assignment_type%TYPE;

1183: AND orgn_code = v_orgn_code;
1184:
1185: l_smpl_assignment_type sy_docs_seq.assignment_type%TYPE;
1186: l_smpl_last_assigned sy_docs_seq.last_assigned%TYPE;
1187: l_stbl_assignment_type sy_docs_seq.assignment_type%TYPE;
1188: l_stbl_last_assigned sy_docs_seq.last_assigned%TYPE;
1189:
1190: /*==================================
1191: Cursor to get Lab indicator.

Line 1188: l_stbl_last_assigned sy_docs_seq.last_assigned%TYPE;

1184:
1185: l_smpl_assignment_type sy_docs_seq.assignment_type%TYPE;
1186: l_smpl_last_assigned sy_docs_seq.last_assigned%TYPE;
1187: l_stbl_assignment_type sy_docs_seq.assignment_type%TYPE;
1188: l_stbl_last_assigned sy_docs_seq.last_assigned%TYPE;
1189:
1190: /*==================================
1191: Cursor to get Lab indicator.
1192: ==================================*/