APPS.IGF_DB_SF_INTEGRATION dependencies on IGS_PE_PERSID_GROUP_ALL

Line 164: FUNCTION validate_persid_grp(p_persid_grp_id IN igs_pe_persid_group_all.group_id%TYPE)

160: RETURN FALSE;
161: END IF;
162: END validate_award_year;
163:
164: FUNCTION validate_persid_grp(p_persid_grp_id IN igs_pe_persid_group_all.group_id%TYPE)
165: RETURN BOOLEAN AS
166: /***********************************************************************************************
167:
168: Created By : Sarakshi

Line 176: existance of input person id group from igs_pe_persid_group_all

172: Known limitations,enhancements,remarks:
173: Change History
174: Who When What
175: smadathi 01-JUL-2004 Bug 3735396. Modified the cursor cur_val select to validate
176: existance of input person id group from igs_pe_persid_group_all
177: smadathi 31-DEC-2002 Bug 2620343. Modified the cursor cur_val select to fetch
178: the records from view igs_pe_persid_group instead of
179: igs_pe_persid_group_v. This fix is done to remove
180: Non-mergablity due to igs_pe_persid_group_v view and to reduce shared memory

Line 185: FROM igs_pe_persid_group_all

181: ********************************************************************************************** */
182:
183: CURSOR cur_val IS
184: SELECT 'X'
185: FROM igs_pe_persid_group_all
186: WHERE group_id = p_persid_grp_id
187: AND TRUNC(create_dt) <= TRUNC(SYSDATE)
188: AND NVL(closed_ind,'N') = 'N';
189: