APPS.IGS_PE_VAL_PIGS dependencies on IGS_PE_PERSID_GROUP_ALL

Line 7: p_group_id IN IGS_PE_PERSID_GROUP_ALL.group_id%TYPE ,

3:
4: --
5: -- Validate IGS_PE_PERSON id group security ins/upd/del security
6: FUNCTION idgp_val_pigs_iud(
7: p_group_id IN IGS_PE_PERSID_GROUP_ALL.group_id%TYPE ,
8: p_person_id IN NUMBER ,
9: p_message_name OUT NOCOPY VARCHAR2 )
10: RETURN BOOLEAN IS
11: gv_other_detail VARCHAR2(255);

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