APPS.IGS_PE_VAL_PIGM dependencies on IGS_PE_HZ_PARTIES

Line 47: FROM IGS_PE_PERSID_GROUP_ALL pig, igs_pe_hz_parties pe

43:
44: --skpandey, Bug#4937960: Changed c_pig cursor definition to optimize query
45: CURSOR c_pig(cp_group_id IGS_PE_PERSID_GROUP_ALL.group_id%TYPE) IS
46: SELECT pig.creator_person_id
47: FROM IGS_PE_PERSID_GROUP_ALL pig, igs_pe_hz_parties pe
48: WHERE pig.group_id = cp_group_id
49: AND pig.creator_person_id = pe.party_id
50: AND pe.oracle_username = fnd_global.user_name;
51:

Line 58: IGS_PE_HZ_PARTIES pe

54: SELECT pigs.insert_ind,
55: pigs.update_ind,
56: pigs.delete_ind
57: FROM IGS_PE_PRSID_GRP_SEC pigs,
58: IGS_PE_HZ_PARTIES pe
59: WHERE pigs.group_id = cp_group_id
60: AND pigs.person_id = pe.party_id
61: AND pe.oracle_username = fnd_global.user_name;
62: