APPS.IGS_RE_VAL_TEX dependencies on IGS_RE_THS_PNL_MBR

Line 199: FROM IGS_RE_THS_PNL_MBR tpm,

195: v_tex2_exists VARCHAR2(1);
196: v_dummy VARCHAR2(1);
197: CURSOR c_tpm IS
198: SELECT 'x'
199: FROM IGS_RE_THS_PNL_MBR tpm,
200: IGS_RE_THESIS_RESULT thr
201: WHERE tpm.person_id = p_person_id AND
202: tpm.ca_sequence_number = p_ca_sequence_number AND
203: tpm.the_sequence_number = p_the_sequence_number AND

Line 686: FROM IGS_RE_THS_PNL_MBR tpm

682: FROM IGS_RE_THESIS_RESULT thr
683: WHERE thr.thesis_result_cd = p_thesis_result_cd;
684: CURSOR c_tpm IS
685: SELECT tpm.thesis_result_cd
686: FROM IGS_RE_THS_PNL_MBR tpm
687: WHERE tpm.ca_person_id = p_person_id AND
688: tpm.ca_sequence_number = p_ca_sequence_number AND
689: tpm.the_sequence_number = p_the_sequence_number AND
690: tpm.creation_dt = p_creation_dt AND

Line 699: FROM IGS_RE_THS_PNL_MBR tpm

695: FROM IGS_RE_THS_PNL_TYPE tpt
696: WHERE tpt.thesis_panel_type = p_thesis_panel_type;
697: CURSOR c_tpmc IS
698: SELECT confirmed_dt
699: FROM IGS_RE_THS_PNL_MBR tpm
700: WHERE tpm.ca_person_id = p_person_id AND
701: tpm.ca_sequence_number = p_ca_sequence_number AND
702: tpm.the_sequence_number = p_the_sequence_number AND
703: tpm.creation_dt = p_creation_dt;