APPS.IGS_AD_GEN_002 dependencies on IGS_AD_APPL_LTR

Line 2472: v_spl_sequence_number IGS_AD_APPL_LTR.spl_sequence_number%TYPE;

2468: -- Letter
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

Line 2476: FROM IGS_AD_APPL_LTR

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
2478: admission_appl_number = p_admission_appl_number AND
2479: correspondence_type = p_correspondence_type AND
2480: sequence_number = p_sequence_number;

Line 2482: p_person_id IGS_AD_APPL_LTR.person_id%TYPE,

2478: admission_appl_number = p_admission_appl_number AND
2479: correspondence_type = p_correspondence_type AND
2480: sequence_number = p_sequence_number;
2481: CURSOR c_ocr (
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

Line 2483: p_correspondence_type IGS_AD_APPL_LTR.correspondence_type%TYPE,

2479: correspondence_type = p_correspondence_type AND
2480: sequence_number = p_sequence_number;
2481: CURSOR c_ocr (
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

Line 2484: cp_spl_sequence_number IGS_AD_APPL_LTR.spl_sequence_number%TYPE) IS

2480: sequence_number = p_sequence_number;
2481: CURSOR c_ocr (
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