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_ASSIGN_REVIEW_GRP dependencies on IGS_OR_INST_ADDR

Line 85: country igs_or_inst_addr.country%TYPE,

81: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
82: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
83: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
84: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
85: country igs_or_inst_addr.country%TYPE,
86: state igs_or_inst_addr.state%TYPE,
87: postal_code igs_or_inst_addr.postal_code%TYPE);
88:
89: TYPE c_ref IS REF CURSOR ;

Line 86: state igs_or_inst_addr.state%TYPE,

82: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
83: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
84: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
85: country igs_or_inst_addr.country%TYPE,
86: state igs_or_inst_addr.state%TYPE,
87: postal_code igs_or_inst_addr.postal_code%TYPE);
88:
89: TYPE c_ref IS REF CURSOR ;
90:

Line 87: postal_code igs_or_inst_addr.postal_code%TYPE);

83: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
84: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
85: country igs_or_inst_addr.country%TYPE,
86: state igs_or_inst_addr.state%TYPE,
87: postal_code igs_or_inst_addr.postal_code%TYPE);
88:
89: TYPE c_ref IS REF CURSOR ;
90:
91: l_include_where VARCHAR2(2000) DEFAULT NULL;

Line 124: l_country igs_or_inst_addr.country%TYPE;

120: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
121: l_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
122: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;
123: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
124: l_country igs_or_inst_addr.country%TYPE;
125: l_state igs_or_inst_addr.state%TYPE;
126: l_postal_code igs_or_inst_addr.postal_code%TYPE;
127: l_pe_country igs_pe_addr_v.country_cd%TYPE;
128: l_pe_state igs_pe_addr_v.state%TYPE;

Line 125: l_state igs_or_inst_addr.state%TYPE;

121: l_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
122: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;
123: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
124: l_country igs_or_inst_addr.country%TYPE;
125: l_state igs_or_inst_addr.state%TYPE;
126: l_postal_code igs_or_inst_addr.postal_code%TYPE;
127: l_pe_country igs_pe_addr_v.country_cd%TYPE;
128: l_pe_state igs_pe_addr_v.state%TYPE;
129: l_pe_postal_code igs_pe_addr_v.postal_code%TYPE;

Line 126: l_postal_code igs_or_inst_addr.postal_code%TYPE;

122: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;
123: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
124: l_country igs_or_inst_addr.country%TYPE;
125: l_state igs_or_inst_addr.state%TYPE;
126: l_postal_code igs_or_inst_addr.postal_code%TYPE;
127: l_pe_country igs_pe_addr_v.country_cd%TYPE;
128: l_pe_state igs_pe_addr_v.state%TYPE;
129: l_pe_postal_code igs_pe_addr_v.postal_code%TYPE;
130:

Line 499: fnd_dsql.add_text(' FROM igs_pe_hz_parties hp, igs_ad_ps_appl_inst_all apl, igs_ad_appl_all app, igs_ad_doc_stat doc, igs_ad_ou_stat ou, igs_or_inst_addr addr, igs_ad_acad_history_v aah ');

495: CLOSE c_revgr_addr;
496:
497: fnd_dsql.init;
498: fnd_dsql.add_text('SELECT apl.person_id,apl.admission_appl_number, apl.nominated_course_cd, apl.sequence_number, addr.country, addr.state ,addr.postal_code');
499: fnd_dsql.add_text(' FROM igs_pe_hz_parties hp, igs_ad_ps_appl_inst_all apl, igs_ad_appl_all app, igs_ad_doc_stat doc, igs_ad_ou_stat ou, igs_or_inst_addr addr, igs_ad_acad_history_v aah ');
500: fnd_dsql.add_text(' WHERE hp.party_id = apl.person_id AND hp.party_id = aah.person_id AND aah.CURRENT_INST = ');
501: fnd_dsql.add_bind('Y');
502: fnd_dsql.add_text(' AND aah.institution_code = addr.institution_cd AND addr.addr_type = ' );
503: fnd_dsql.add_bind(c_appl_revprof_group_cd_rec.site_use_code);