DBA Data[Home] [Help]

APPS.IGS_RE_VAL_RSUP dependencies on IGS_PE_TYP_INSTANCES

Line 211: igs_pe_typ_instances pti

207: CURSOR c_funding IS
208: SELECT NVL(SUM(rsup.funding_percentage),0),count(*)
209: FROM IGS_RE_SPRVSR rsup,
210: igs_pe_person_types pt,
211: igs_pe_typ_instances pti
212: WHERE rsup.ca_person_id = p_ca_person_id
213: AND rsup.ca_sequence_number = p_ca_sequence_number
214: AND rsup.person_id = pti.person_id
215: AND pti.person_type_code = pt.person_type_code