APPS.IGS_RE_VAL_TPM dependencies on IGS_RE_THS_PNL_MR_TP

Line 101: IGS_RE_THS_PNL_MR_TP tpmpt

97: v_loop_bool BOOLEAN DEFAULT FALSE;
98: CURSOR c_tpm_tpmpt IS
99: SELECT 'X'
100: FROM IGS_RE_THS_PNL_MBR tpm,
101: IGS_RE_THS_PNL_MR_TP tpmpt
102: WHERE tpm.ca_person_id = p_ca_person_id AND
103: tpm.ca_sequence_number = p_ca_sequence_number AND
104: tpm.the_sequence_number = p_the_sequence_number AND
105: tpm.creation_dt = p_creation_dt AND

Line 443: v_tpmt_rec IGS_RE_THS_PNL_MR_TP.closed_ind%TYPE;

439: BEGIN -- resp_val_tpm_tpmt
440: -- Description: Validate the IGS_RE_THS_PNL_MBR.panel_member_type, checking
441: -- for: Closed type.
442: DECLARE
443: v_tpmt_rec IGS_RE_THS_PNL_MR_TP.closed_ind%TYPE;
444: CURSOR c_tpmt IS
445: SELECT tpmt.closed_ind
446: FROM IGS_RE_THS_PNL_MR_TP tpmt
447: WHERE tpmt.panel_member_type = p_panel_member_type;

Line 446: FROM IGS_RE_THS_PNL_MR_TP tpmt

442: DECLARE
443: v_tpmt_rec IGS_RE_THS_PNL_MR_TP.closed_ind%TYPE;
444: CURSOR c_tpmt IS
445: SELECT tpmt.closed_ind
446: FROM IGS_RE_THS_PNL_MR_TP tpmt
447: WHERE tpmt.panel_member_type = p_panel_member_type;
448: BEGIN
449: p_message_name := NULL;
450: OPEN c_tpmt;