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_PE_ADDR_V

Line 127: l_pe_country igs_pe_addr_v.country_cd%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:
131:

Line 128: l_pe_state igs_pe_addr_v.state%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:
131:
132: l_addr_include_ind BOOLEAN;

Line 129: l_pe_postal_code igs_pe_addr_v.postal_code%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:
131:
132: l_addr_include_ind BOOLEAN;
133: l_addr_excluded_ind BOOLEAN;

Line 871: fnd_dsql.add_text(' FROM hz_parties hp, hz_party_site_uses psu, igs_ad_ps_appl_inst_all apl, igs_ad_appl_all app, igs_ad_doc_stat doc, igs_ad_ou_stat ou, igs_pe_addr_v addr ');

867:
868:
869: fnd_dsql.init;
870: fnd_dsql.add_text(' SELECT apl.person_id,apl.admission_appl_number, apl.nominated_course_cd, apl.sequence_number , addr.country_cd, addr.state, addr.postal_code ');
871: fnd_dsql.add_text(' FROM hz_parties hp, hz_party_site_uses psu, igs_ad_ps_appl_inst_all apl, igs_ad_appl_all app, igs_ad_doc_stat doc, igs_ad_ou_stat ou, igs_pe_addr_v addr ');
872: fnd_dsql.add_text(' WHERE hp.party_id = apl.person_id AND hp.party_id = addr.person_id AND addr.party_site_id = psu.party_site_id AND psu.site_use_type = ');
873: fnd_dsql.add_bind(c_appl_revprof_group_cd_rec.site_use_code);
874: fnd_dsql.add_text(' AND doc.s_adm_doc_status = ' );
875: fnd_dsql.add_bind(l_satisfied);