DBA Data[Home] [Help]

APPS.IGS_PE_VAL_PIGS dependencies on HZ_PARTIES

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