APPS.IGS_RE_GEN_003 dependencies on IGS_RE_THS_PNL_MR_TP

Line 330: IGS_RE_THS_PNL_MR_TP tpmt

326: cp_the_sequence_number IGS_RE_THS_PNL_MBR.the_sequence_number%TYPE,
327: cp_creation_dt IGS_RE_THS_PNL_MBR.creation_dt%TYPE) IS
328: SELECT tpm.person_id
329: FROM IGS_RE_THS_PNL_MBR tpm,
330: IGS_RE_THS_PNL_MR_TP tpmt
331: WHERE tpm.ca_person_id = cp_person_id AND
332: tpm.ca_sequence_number = cp_ca_sequence_number AND
333: tpm.the_sequence_number = cp_the_sequence_number AND
334: tpm.creation_dt = cp_creation_dt AND

Line 910: cp_panel_member_type IGS_RE_THS_PNL_MR_TP.panel_member_type%TYPE) IS

906: rst.research_supervisor_type = rsup.research_supervisor_type AND
907: rst.principal_supervisor_ind = 'Y'
908: ORDER BY rsup.supervision_percentage DESC;
909: CURSOR c_tmpt (
910: cp_panel_member_type IGS_RE_THS_PNL_MR_TP.panel_member_type%TYPE) IS
911: SELECT tmpt.tracking_type
912: FROM IGS_RE_THS_PNL_MR_TP tmpt
913: WHERE tmpt.panel_member_type = cp_panel_member_type;
914: CURSOR c_ts IS

Line 912: FROM IGS_RE_THS_PNL_MR_TP tmpt

908: ORDER BY rsup.supervision_percentage DESC;
909: CURSOR c_tmpt (
910: cp_panel_member_type IGS_RE_THS_PNL_MR_TP.panel_member_type%TYPE) IS
911: SELECT tmpt.tracking_type
912: FROM IGS_RE_THS_PNL_MR_TP tmpt
913: WHERE tmpt.panel_member_type = cp_panel_member_type;
914: CURSOR c_ts IS
915: SELECT ts.tracking_status
916: FROM IGS_TR_STATUS ts