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.

[Home] [Help]

APPS.IGS_AD_PS_APPL_INST_PKG dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 396: FROM igs_pe_typ_instances_all pti,

392: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
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

Line 1788: FROM igs_pe_typ_instances_all pti,

1784: p_deleting IN BOOLEAN
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

Line 1837: FROM igs_pe_typ_instances_all pti,

1833: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
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

Line 1853: FROM igs_pe_typ_instances_all pti,

1849: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
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