DBA Data[Home] [Help]

APPS.IGS_FI_1098T_EXTRACT_DATA dependencies on IGS_PE_PERSON_TYPES

Line 2834: igs_pe_person_types ptm

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')
2838: AND TRUNC(ptyp.start_date) <= TRUNC(cp_d_start_date)