DBA Data[Home] [Help]

APPS.IGS_FI_1098T_EXTRACT_DATA dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 2833: FROM igs_pe_typ_instances_all ptyp,

2829: CURSOR cur_non_res_alien(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
2830: cp_d_start_date DATE,
2831: cp_d_end_date DATE) IS
2832: SELECT 'x'
2833: FROM igs_pe_typ_instances_all ptyp,
2834: igs_pe_person_types ptm
2835: WHERE ptyp.person_id = cp_n_person_id
2836: AND ptyp.person_type_code = ptm.person_type_code
2837: AND ptm.system_type IN ('EXCHG_VISITOR','NONIMG_STUDENT')