APPS.IGS_AD_GEN_011 dependencies on IGS_CO_S_LTR

Line 796: v_letter_reference_number igs_co_s_ltr.letter_reference_number%TYPE;

792: l_org_id NUMBER(15);
793: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
794: BEGIN
795: DECLARE
796: v_letter_reference_number igs_co_s_ltr.letter_reference_number%TYPE;
797: v_spl_sequence_number igs_co_s_per_lt_parm.spl_sequence_number%TYPE;
798: v_create_dt DATE;
799: v_issue_dt DATE;
800: v_comments VARCHAR2(2000);

Line 814: igs_co_s_ltr slet

810: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE
811: ) IS
812: SELECT apcl.letter_reference_number
813: FROM igs_ad_prcs_cat_ltr apcl,
814: igs_co_s_ltr slet
815: WHERE apcl.admission_cat = cp_admission_cat
816: AND apcl.s_admission_process_type = cp_s_admission_process_type
817: AND apcl.correspondence_type = cp_correspondence_type
818: AND apcl.correspondence_type = slet.correspondence_type

Line 825: FROM igs_co_s_ltr sl

821: CURSOR c_sl (
822: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE
823: ) IS
824: SELECT sl.letter_reference_number
825: FROM igs_co_s_ltr sl
826: WHERE sl.correspondence_type = cp_correspondence_type
827: AND sl.closed_ind = 'N'
828: ORDER BY sl.letter_reference_number;
829: CURSOR c_cit (