APPS.IGS_AD_PS_APPL_INST_PKG dependencies on IGS_PE_PERSON_TYPES

Line 397: igs_pe_person_types ppt

393: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
394: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
395: SELECT pti.rowid row_id
396: FROM igs_pe_typ_instances_all pti,
397: igs_pe_person_types ppt
398: WHERE pti.person_id = cp_person_id
399: AND pti.admission_appl_number = cp_admission_appl_number
400: AND pti.nominated_course_cd = cp_nominated_course_cd
401: AND pti.sequence_number = cp_sequence_number

Line 1789: igs_pe_person_types ppt,

1785: ) AS
1786: CURSOR c_pti (cp_person_id igs_pe_person.person_id%TYPE) IS
1787: SELECT pti.rowid row_id,pti.*, lv.lookup_code lv_end_method
1788: FROM igs_pe_typ_instances_all pti,
1789: igs_pe_person_types ppt,
1790: igs_lookup_values lv
1791: WHERE pti.person_id = cp_person_id
1792: AND ppt.person_type_code = pti.person_type_code
1793: AND ppt.system_type = 'PROSPECT'

Line 1838: igs_pe_person_types ppt

1834: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
1835: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
1836: SELECT pti.rowid row_id,pti.*
1837: FROM igs_pe_typ_instances_all pti,
1838: igs_pe_person_types ppt
1839: WHERE pti.person_id = cp_person_id
1840: AND pti.admission_appl_number = cp_admission_appl_number
1841: AND pti.nominated_course_cd = cp_nominated_course_cd
1842: AND pti.sequence_number = cp_sequence_number

Line 1854: igs_pe_person_types ppt

1850: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
1851: cp_end_method igs_lookup_values.lookup_code%TYPE) IS
1852: SELECT pti.rowid row_id,pti.*
1853: FROM igs_pe_typ_instances_all pti,
1854: igs_pe_person_types ppt
1855: WHERE pti.person_id = cp_person_id
1856: AND pti.admission_appl_number = cp_admission_appl_number
1857: AND pti.nominated_course_cd = cp_nominated_course_cd
1858: AND pti.sequence_number = cp_sequence_number