DBA Data[Home] [Help]

APPS.IGS_CO_VAL_SCOTR dependencies on IGS_PE_PERSON_BASE_V

Line 15: FROM igs_pe_person_base_v

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
18: -- validate the person_id is valid
19: OPEN c_person(p_person_id);