APPS.IGS_CO_GEN_002 dependencies on IGS_CO_TYPE

Line 30: v_sys_generated_ind IGS_CO_TYPE.sys_generated_ind%TYPE;

26: DECLARE
27: cst_spl_seqnum CONSTANT VARCHAR2(10) := 'SPL_SEQNUM';
28: v_spl_sequence_number NUMBER(10);
29: v_dummy VARCHAR2(1);
30: v_sys_generated_ind IGS_CO_TYPE.sys_generated_ind%TYPE;
31: CURSOR c_corit(
32: cp_correspondence_type IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE,
33: cp_reference_number IGS_CO_ITM.reference_number%TYPE) IS
34: SELECT cort.sys_generated_ind

Line 36: IGS_CO_TYPE cort

32: cp_correspondence_type IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE,
33: cp_reference_number IGS_CO_ITM.reference_number%TYPE) IS
34: SELECT cort.sys_generated_ind
35: FROM IGS_CO_ITM cori,
36: IGS_CO_TYPE cort
37: WHERE cori.CORRESPONDENCE_TYPE = cp_correspondence_type
38: AND cori.reference_number = cp_reference_number
39: AND cort.CORRESPONDENCE_TYPE = cori.CORRESPONDENCE_TYPE;
40: CURSOR c_sl(