APPS.IGS_CO_VAL_SCOTR dependencies on HZ_PARTIES

Line 13: CURSOR c_person(cp_person_id hz_parties.party_id%TYPE) IS

9: BEGIN
10: DECLARE
11: v_person_id IGS_PE_PERSON.person_id%TYPE;
12: -- skpandey, Bug#4937960: Changed c_person cursor definition to optimize query
13: CURSOR c_person(cp_person_id hz_parties.party_id%TYPE) IS
14: SELECT person_id
15: FROM igs_pe_person_base_v
16: WHERE person_id = cp_person_id;
17: BEGIN