APPS.IGS_AD_GEN_011 dependencies on IGS_PS_VER

Line 1120: cp_org_unit_code igs_ps_ver.responsible_org_unit_cd%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,
1124: aa.admission_appl_number admission_appl_number,

Line 1136: igs_ps_ver pv,

1132: padv.postal_code postal_code
1133: FROM igs_ad_appl aa,
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

Line 1325: igs_ps_ver pv,

1321: padv.postal_code postal_code
1322: FROM igs_ad_appl aa,
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

Line 1442: p_organization_unit igs_ps_ver.responsible_org_unit_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: /*
1445: ** End of code for enhancement# 1818444.
1446: */