APPS.IGS_RE_WORKFLOW dependencies on IGS_RE_THS_PNL_MBR

Line 106: CURSOR cur_get_panelmem( p_ca_person_id igs_re_ths_pnl_mbr.ca_person_id%TYPE,

102: -- Who When What
103: --
104: -------------------------------------------------------------------------------------------------
105:
106: CURSOR cur_get_panelmem( p_ca_person_id igs_re_ths_pnl_mbr.ca_person_id%TYPE,
107: p_ca_sequence_number igs_re_ths_pnl_mbr.ca_sequence_number%TYPE,
108: p_the_sequence_number igs_re_ths_pnl_mbr.the_sequence_number%TYPE,
109: p_creation_dt igs_re_ths_pnl_mbr.creation_dt%TYPE) IS
110: SELECT person_id

Line 107: p_ca_sequence_number igs_re_ths_pnl_mbr.ca_sequence_number%TYPE,

103: --
104: -------------------------------------------------------------------------------------------------
105:
106: CURSOR cur_get_panelmem( p_ca_person_id igs_re_ths_pnl_mbr.ca_person_id%TYPE,
107: p_ca_sequence_number igs_re_ths_pnl_mbr.ca_sequence_number%TYPE,
108: p_the_sequence_number igs_re_ths_pnl_mbr.the_sequence_number%TYPE,
109: p_creation_dt igs_re_ths_pnl_mbr.creation_dt%TYPE) IS
110: SELECT person_id
111: FROM igs_re_ths_pnl_mbr

Line 108: p_the_sequence_number igs_re_ths_pnl_mbr.the_sequence_number%TYPE,

104: -------------------------------------------------------------------------------------------------
105:
106: CURSOR cur_get_panelmem( p_ca_person_id igs_re_ths_pnl_mbr.ca_person_id%TYPE,
107: p_ca_sequence_number igs_re_ths_pnl_mbr.ca_sequence_number%TYPE,
108: p_the_sequence_number igs_re_ths_pnl_mbr.the_sequence_number%TYPE,
109: p_creation_dt igs_re_ths_pnl_mbr.creation_dt%TYPE) IS
110: SELECT person_id
111: FROM igs_re_ths_pnl_mbr
112: WHERE ca_person_id = p_personid

Line 109: p_creation_dt igs_re_ths_pnl_mbr.creation_dt%TYPE) IS

105:
106: CURSOR cur_get_panelmem( p_ca_person_id igs_re_ths_pnl_mbr.ca_person_id%TYPE,
107: p_ca_sequence_number igs_re_ths_pnl_mbr.ca_sequence_number%TYPE,
108: p_the_sequence_number igs_re_ths_pnl_mbr.the_sequence_number%TYPE,
109: p_creation_dt igs_re_ths_pnl_mbr.creation_dt%TYPE) IS
110: SELECT person_id
111: FROM igs_re_ths_pnl_mbr
112: WHERE ca_person_id = p_personid
113: AND ca_sequence_number= p_ca_sequence_number

Line 111: FROM igs_re_ths_pnl_mbr

107: p_ca_sequence_number igs_re_ths_pnl_mbr.ca_sequence_number%TYPE,
108: p_the_sequence_number igs_re_ths_pnl_mbr.the_sequence_number%TYPE,
109: p_creation_dt igs_re_ths_pnl_mbr.creation_dt%TYPE) IS
110: SELECT person_id
111: FROM igs_re_ths_pnl_mbr
112: WHERE ca_person_id = p_personid
113: AND ca_sequence_number= p_ca_sequence_number
114: AND the_sequence_number= p_the_sequence_number
115: AND creation_dt= p_creation_dt ;