eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_GEN_011 dependencies on IGS_AD_APPL_LTR_PHR

Line 1609: cp_person_id IGS_AD_APPL_LTR_PHR.person_id%TYPE,

1605: v_value VARCHAR2(2000);
1606: v_sequence_number IGS_CO_S_PER_LT_PARM.sequence_number%TYPE;
1607:
1608: CURSOR c_aalp (
1609: cp_person_id IGS_AD_APPL_LTR_PHR.person_id%TYPE,
1610: cp_adm_appl_number IGS_AD_APPL_LTR_PHR.admission_appl_number%TYPE,
1611: cp_correspondence_type IGS_AD_APPL_LTR_PHR.correspondence_type%TYPE,
1612: cp_aal_sequence_number IGS_AD_APPL_LTR_PHR.aal_sequence_number%TYPE,
1613: cp_letter_parameter_type IGS_AD_APPL_LTR_PHR.letter_parameter_type%TYPE) IS

Line 1610: cp_adm_appl_number IGS_AD_APPL_LTR_PHR.admission_appl_number%TYPE,

1606: v_sequence_number IGS_CO_S_PER_LT_PARM.sequence_number%TYPE;
1607:
1608: CURSOR c_aalp (
1609: cp_person_id IGS_AD_APPL_LTR_PHR.person_id%TYPE,
1610: cp_adm_appl_number IGS_AD_APPL_LTR_PHR.admission_appl_number%TYPE,
1611: cp_correspondence_type IGS_AD_APPL_LTR_PHR.correspondence_type%TYPE,
1612: cp_aal_sequence_number IGS_AD_APPL_LTR_PHR.aal_sequence_number%TYPE,
1613: cp_letter_parameter_type IGS_AD_APPL_LTR_PHR.letter_parameter_type%TYPE) IS
1614: SELECT aalp.phrase_cd,

Line 1611: cp_correspondence_type IGS_AD_APPL_LTR_PHR.correspondence_type%TYPE,

1607:
1608: CURSOR c_aalp (
1609: cp_person_id IGS_AD_APPL_LTR_PHR.person_id%TYPE,
1610: cp_adm_appl_number IGS_AD_APPL_LTR_PHR.admission_appl_number%TYPE,
1611: cp_correspondence_type IGS_AD_APPL_LTR_PHR.correspondence_type%TYPE,
1612: cp_aal_sequence_number IGS_AD_APPL_LTR_PHR.aal_sequence_number%TYPE,
1613: cp_letter_parameter_type IGS_AD_APPL_LTR_PHR.letter_parameter_type%TYPE) IS
1614: SELECT aalp.phrase_cd,
1615: aalp.phrase_text

Line 1612: cp_aal_sequence_number IGS_AD_APPL_LTR_PHR.aal_sequence_number%TYPE,

1608: CURSOR c_aalp (
1609: cp_person_id IGS_AD_APPL_LTR_PHR.person_id%TYPE,
1610: cp_adm_appl_number IGS_AD_APPL_LTR_PHR.admission_appl_number%TYPE,
1611: cp_correspondence_type IGS_AD_APPL_LTR_PHR.correspondence_type%TYPE,
1612: cp_aal_sequence_number IGS_AD_APPL_LTR_PHR.aal_sequence_number%TYPE,
1613: cp_letter_parameter_type IGS_AD_APPL_LTR_PHR.letter_parameter_type%TYPE) IS
1614: SELECT aalp.phrase_cd,
1615: aalp.phrase_text
1616: FROM IGS_AD_APPL_LTR_PHR aalp

Line 1613: cp_letter_parameter_type IGS_AD_APPL_LTR_PHR.letter_parameter_type%TYPE) IS

1609: cp_person_id IGS_AD_APPL_LTR_PHR.person_id%TYPE,
1610: cp_adm_appl_number IGS_AD_APPL_LTR_PHR.admission_appl_number%TYPE,
1611: cp_correspondence_type IGS_AD_APPL_LTR_PHR.correspondence_type%TYPE,
1612: cp_aal_sequence_number IGS_AD_APPL_LTR_PHR.aal_sequence_number%TYPE,
1613: cp_letter_parameter_type IGS_AD_APPL_LTR_PHR.letter_parameter_type%TYPE) IS
1614: SELECT aalp.phrase_cd,
1615: aalp.phrase_text
1616: FROM IGS_AD_APPL_LTR_PHR aalp
1617: WHERE aalp.person_id = cp_person_id AND

Line 1616: FROM IGS_AD_APPL_LTR_PHR aalp

1612: cp_aal_sequence_number IGS_AD_APPL_LTR_PHR.aal_sequence_number%TYPE,
1613: cp_letter_parameter_type IGS_AD_APPL_LTR_PHR.letter_parameter_type%TYPE) IS
1614: SELECT aalp.phrase_cd,
1615: aalp.phrase_text
1616: FROM IGS_AD_APPL_LTR_PHR aalp
1617: WHERE aalp.person_id = cp_person_id AND
1618: aalp.admission_appl_number = cp_adm_appl_number AND
1619: aalp.correspondence_type = cp_correspondence_type AND
1620: aalp.aal_sequence_number = cp_aal_sequence_number AND