APPS.IGS_AD_GEN_002 dependencies on IGS_CO_OU_CO_REF

Line 2473: v_issue_dt IGS_CO_OU_CO_REF.issue_dt%TYPE;

2469: -- admp_get_aal_sent_dt
2470: DECLARE
2471: cst_spl_seqnum CONSTANT VARCHAR2(10) := 'SPL_SEQNUM';
2472: v_spl_sequence_number IGS_AD_APPL_LTR.spl_sequence_number%TYPE;
2473: v_issue_dt IGS_CO_OU_CO_REF.issue_dt%TYPE;
2474: CURSOR c_aal IS
2475: SELECT spl_sequence_number
2476: FROM IGS_AD_APPL_LTR
2477: WHERE person_id = p_person_id AND

Line 2486: FROM IGS_CO_OU_CO_REF

2482: p_person_id IGS_AD_APPL_LTR.person_id%TYPE,
2483: p_correspondence_type IGS_AD_APPL_LTR.correspondence_type%TYPE,
2484: cp_spl_sequence_number IGS_AD_APPL_LTR.spl_sequence_number%TYPE) IS
2485: SELECT issue_dt
2486: FROM IGS_CO_OU_CO_REF
2487: WHERE person_id = p_person_id AND
2488: correspondence_type = p_correspondence_type AND
2489: s_other_reference_type = cst_spl_seqnum AND
2490: other_reference = IGS_GE_NUMBER.TO_CANN(cp_spl_sequence_number);