APPS.IGF_SP_ASSIGN_PUB dependencies on IGS_PE_PERSON_BASE_V

Line 35: CURSOR c_check_valid_person (cp_n_person_id igs_pe_person_base_v.person_id%TYPE)

31: Change History
32:
33: Who When What
34: ******************************************************************************/
35: CURSOR c_check_valid_person (cp_n_person_id igs_pe_person_base_v.person_id%TYPE)
36: IS
37: SELECT 'x'
38: FROM igs_pe_person_base_v
39: WHERE person_id = cp_n_person_id;

Line 38: FROM igs_pe_person_base_v

34: ******************************************************************************/
35: CURSOR c_check_valid_person (cp_n_person_id igs_pe_person_base_v.person_id%TYPE)
36: IS
37: SELECT 'x'
38: FROM igs_pe_person_base_v
39: WHERE person_id = cp_n_person_id;
40: BEGIN
41: OPEN c_check_valid_person(p_n_person_id);
42: FETCH c_check_valid_person INTO g_c_temp;