APPS.IGS_AD_GEN_011 dependencies on IGS_PE_RES_DTLS_V

Line 1118: cp_residency_class igs_pe_res_dtls_v.residency_class%TYPE,

1114: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE,
1115: cp_adm_outcome_status igs_ad_ou_stat.adm_outcome_status%TYPE,
1116: cp_pgm_of_study igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
1117: cp_response_status igs_ad_ofr_resp_stat.adm_offer_resp_status%TYPE,
1118: cp_residency_class igs_pe_res_dtls_v.residency_class%TYPE,
1119: cp_residency_stat igs_pe_res_dtls_v.residency_status%TYPE,
1120: cp_org_unit_code igs_ps_ver.responsible_org_unit_cd%TYPE
1121: ) IS
1122: SELECT DISTINCT

Line 1119: cp_residency_stat igs_pe_res_dtls_v.residency_status%TYPE,

1115: cp_adm_outcome_status igs_ad_ou_stat.adm_outcome_status%TYPE,
1116: cp_pgm_of_study igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
1117: cp_response_status igs_ad_ofr_resp_stat.adm_offer_resp_status%TYPE,
1118: cp_residency_class igs_pe_res_dtls_v.residency_class%TYPE,
1119: cp_residency_stat igs_pe_res_dtls_v.residency_status%TYPE,
1120: cp_org_unit_code igs_ps_ver.responsible_org_unit_cd%TYPE
1121: ) IS
1122: SELECT DISTINCT
1123: aa.person_id person_id,

Line 1138: igs_pe_res_dtls_v prdv

1134: igs_ad_appl_ltr aal,
1135: igs_ad_ps_appl_inst acaiv, --Bug 3150054 Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst
1136: igs_ps_ver pv,
1137: igs_pe_addr_v padv,
1138: igs_pe_res_dtls_v prdv
1139: WHERE aa.acad_cal_type LIKE cp_acad_cal_type
1140: AND aa.acad_ci_sequence_number LIKE cp_acad_ci_sequence_number
1141: AND NVL(acaiv.adm_cal_type, aa.adm_cal_type) LIKE cp_adm_cal_type
1142: AND NVL(acaiv.adm_ci_sequence_number, aa.adm_ci_sequence_number) LIKE cp_adm_ci_sequence_number

Line 1327: igs_pe_res_dtls_v prdv

1323: igs_ad_appl_ltr aal,
1324: igs_ad_ps_appl_inst acaiv, --Bug 3150054 Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst
1325: igs_ps_ver pv,
1326: igs_pe_addr_v padv,
1327: igs_pe_res_dtls_v prdv
1328: WHERE aa.acad_cal_type LIKE :1
1329: AND aa.acad_ci_sequence_number LIKE :2
1330: AND NVL(acaiv.adm_cal_type, aa.adm_cal_type) LIKE :3
1331: AND NVL(acaiv.adm_ci_sequence_number,aa.adm_ci_sequence_number) LIKE :4

Line 1439: p_residency_class igs_pe_res_dtls_v.residency_class%TYPE;

1435: ** Start of code for enhancement# 1818444.
1436: */
1437: p_program_of_study igs_ad_ps_appl_inst.nominated_course_cd%TYPE;
1438: p_response_status igs_ad_ofr_resp_stat.adm_offer_resp_status%TYPE;
1439: p_residency_class igs_pe_res_dtls_v.residency_class%TYPE;
1440: p_residency_status igs_pe_res_dtls_v.residency_status%TYPE;
1441: p_person_id_group igs_pe_persid_group_all.group_id%TYPE;
1442: p_organization_unit igs_ps_ver.responsible_org_unit_cd%TYPE;
1443: p_sort_by fnd_lookups.lookup_code%TYPE;

Line 1440: p_residency_status igs_pe_res_dtls_v.residency_status%TYPE;

1436: */
1437: p_program_of_study igs_ad_ps_appl_inst.nominated_course_cd%TYPE;
1438: p_response_status igs_ad_ofr_resp_stat.adm_offer_resp_status%TYPE;
1439: p_residency_class igs_pe_res_dtls_v.residency_class%TYPE;
1440: p_residency_status igs_pe_res_dtls_v.residency_status%TYPE;
1441: p_person_id_group igs_pe_persid_group_all.group_id%TYPE;
1442: p_organization_unit igs_ps_ver.responsible_org_unit_cd%TYPE;
1443: p_sort_by fnd_lookups.lookup_code%TYPE;
1444: /*