Line 22: FROM IGS_PE_PERSID_GROUP_ALL pig, igs_pe_hz_parties pe, hz_parties hp
18:
19: -- skpandey, Bug#4937960: changed the definition of cursor
20: CURSOR c_pig IS
21: SELECT pig.creator_person_id 22: FROM IGS_PE_PERSID_GROUP_ALL pig, igs_pe_hz_parties pe, hz_parties hp 23: WHERE pig.group_id = p_group_id AND
24: pig.creator_person_id = hp.party_id AND
25: hp.party_id = pe.party_id (+) AND
26: pig.creator_person_id = pe.party_id AND