APPS.IGS_TR_GEN_002 dependencies on IGS_PE_PERSON

Line 960: CURSOR c_person (cp_person_id igs_pe_person.person_id%TYPE) IS

956: FROM igs_tr_type
957: WHERE tracking_type = p_tracking_type;
958:
959: -- person exists check from person_base_v
960: CURSOR c_person (cp_person_id igs_pe_person.person_id%TYPE) IS
961: SELECT 'x'
962: FROM igs_pe_person_base_v
963: WHERE person_id = cp_person_id;
964:

Line 962: FROM igs_pe_person_base_v

958:
959: -- person exists check from person_base_v
960: CURSOR c_person (cp_person_id igs_pe_person.person_id%TYPE) IS
961: SELECT 'x'
962: FROM igs_pe_person_base_v
963: WHERE person_id = cp_person_id;
964:
965: CURSOR c_tri_nxt_seq_num IS
966: SELECT igs_tr_item_tr_id_s.NEXTVAL