DBA Data[Home] [Help]

APPS.IGS_PE_VAL_PIGM dependencies on FND_GLOBAL

Line 50: AND pe.oracle_username = fnd_global.user_name;

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:
52: --skpandey, Bug#4937960: Changed c_pigs cursor definition to optimize query
53: CURSOR c_pigs(cp_group_id IGS_PE_PRSID_GRP_SEC.group_id%TYPE) IS
54: SELECT pigs.insert_ind,

Line 61: AND pe.oracle_username = fnd_global.user_name;

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:
63: BEGIN
64: -- 1.
65: IF (p_group_id IS NULL) THEN