APPS.GMD_QC_MIG12 dependencies on SY_DOCS_SEQ

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

1167: /*=================================
1168: Cursor to get doc_seq and type
1169: =================================*/
1170:
1171: CURSOR get_doc_info(v_orgn_code sy_docs_seq.orgn_code%TYPE, v_doc_type sy_docs_seq.doc_type%TYPE) IS
1172: SELECT assignment_type, last_assigned
1173: FROM sy_docs_seq
1174: WHERE doc_type = v_doc_type
1175: AND orgn_code = v_orgn_code;

Line 1173: FROM sy_docs_seq

1169: =================================*/
1170:
1171: CURSOR get_doc_info(v_orgn_code sy_docs_seq.orgn_code%TYPE, v_doc_type sy_docs_seq.doc_type%TYPE) IS
1172: SELECT assignment_type, last_assigned
1173: FROM sy_docs_seq
1174: WHERE doc_type = v_doc_type
1175: AND orgn_code = v_orgn_code;
1176:
1177: l_smpl_assignment_type sy_docs_seq.assignment_type%TYPE;

Line 1177: l_smpl_assignment_type sy_docs_seq.assignment_type%TYPE;

1173: FROM sy_docs_seq
1174: WHERE doc_type = v_doc_type
1175: AND orgn_code = v_orgn_code;
1176:
1177: l_smpl_assignment_type sy_docs_seq.assignment_type%TYPE;
1178: l_smpl_last_assigned sy_docs_seq.last_assigned%TYPE;
1179: l_stbl_assignment_type sy_docs_seq.assignment_type%TYPE;
1180: l_stbl_last_assigned sy_docs_seq.last_assigned%TYPE;
1181:

Line 1178: l_smpl_last_assigned sy_docs_seq.last_assigned%TYPE;

1174: WHERE doc_type = v_doc_type
1175: AND orgn_code = v_orgn_code;
1176:
1177: l_smpl_assignment_type sy_docs_seq.assignment_type%TYPE;
1178: l_smpl_last_assigned sy_docs_seq.last_assigned%TYPE;
1179: l_stbl_assignment_type sy_docs_seq.assignment_type%TYPE;
1180: l_stbl_last_assigned sy_docs_seq.last_assigned%TYPE;
1181:
1182: /*==================================

Line 1179: l_stbl_assignment_type sy_docs_seq.assignment_type%TYPE;

1175: AND orgn_code = v_orgn_code;
1176:
1177: l_smpl_assignment_type sy_docs_seq.assignment_type%TYPE;
1178: l_smpl_last_assigned sy_docs_seq.last_assigned%TYPE;
1179: l_stbl_assignment_type sy_docs_seq.assignment_type%TYPE;
1180: l_stbl_last_assigned sy_docs_seq.last_assigned%TYPE;
1181:
1182: /*==================================
1183: Cursor to get Lab indicator.

Line 1180: l_stbl_last_assigned sy_docs_seq.last_assigned%TYPE;

1176:
1177: l_smpl_assignment_type sy_docs_seq.assignment_type%TYPE;
1178: l_smpl_last_assigned sy_docs_seq.last_assigned%TYPE;
1179: l_stbl_assignment_type sy_docs_seq.assignment_type%TYPE;
1180: l_stbl_last_assigned sy_docs_seq.last_assigned%TYPE;
1181:
1182: /*==================================
1183: Cursor to get Lab indicator.
1184: ==================================*/