APPS.IGS_RE_GEN_003 dependencies on IGS_RE_SPRVSR_TYPE

Line 282: IGS_RE_SPRVSR_TYPE rst

278: WHERE user_id = fnd_global.user_id;
279: CURSOR c_rst_rsup IS
280: SELECT rsup.person_id
281: FROM IGS_RE_SPRVSR rsup,
282: IGS_RE_SPRVSR_TYPE rst
283: WHERE rsup.ca_person_id = p_person_id AND
284: rsup.ca_sequence_number = p_ca_sequence_number AND
285: rst.research_supervisor_type = rsup.research_supervisor_type AND
286: rst.principal_supervisor_ind = 'Y'

Line 903: IGS_RE_SPRVSR_TYPE rst

899: WHERE user_id = fnd_global.user_id;
900: CURSOR c_rst_rsup IS
901: SELECT rsup.person_id
902: FROM IGS_RE_SPRVSR rsup,
903: IGS_RE_SPRVSR_TYPE rst
904: WHERE rsup.ca_person_id = p_ca_person_id AND
905: rsup.ca_sequence_number = p_ca_sequence_number AND
906: rst.research_supervisor_type = rsup.research_supervisor_type AND
907: rst.principal_supervisor_ind = 'Y'