52: -- Who When What
53: --
54: -------------------------------------------------------------------------------------------------
55:
56: CURSOR cur_get_supervisor( p_ca_person_id igs_re_sprvsr.ca_person_id%TYPE,
57: p_ca_sequence_number igs_re_sprvsr.ca_sequence_number%TYPE) IS
58: SELECT person_id
59: FROM igs_re_sprvsr
60: WHERE ca_person_id = p_ca_person_id
53: --
54: -------------------------------------------------------------------------------------------------
55:
56: CURSOR cur_get_supervisor( p_ca_person_id igs_re_sprvsr.ca_person_id%TYPE,
57: p_ca_sequence_number igs_re_sprvsr.ca_sequence_number%TYPE) IS
58: SELECT person_id
59: FROM igs_re_sprvsr
60: WHERE ca_person_id = p_ca_person_id
61: AND ca_sequence_number = p_ca_sequence_number ;
55:
56: CURSOR cur_get_supervisor( p_ca_person_id igs_re_sprvsr.ca_person_id%TYPE,
57: p_ca_sequence_number igs_re_sprvsr.ca_sequence_number%TYPE) IS
58: SELECT person_id
59: FROM igs_re_sprvsr
60: WHERE ca_person_id = p_ca_person_id
61: AND ca_sequence_number = p_ca_sequence_number ;
62:
63:
427:
428: CURSOR cur_res_start_dt IS
429: SELECT
430: start_dt
431: FROM igs_re_sprvsr
432: WHERE
433: ca_person_id = p_personid
434: AND ca_sequence_number = p_ca_seq_num
435: AND person_id = p_rep_person_id