eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SP_AWARD dependencies on IGS_PE_PERSON_BASE_V

Line 278: -- to fetch the records from view igs_pe_person_base_v

274: --
275: --Change History:
276: --Who When What
277: --smadathi 30-Jan-2002 Bug 2620302. Cursor c_person_number select modified
278: -- to fetch the records from view igs_pe_person_base_v
279: -- instead of igs_pe_person. This fix is done to remove
280: -- Non-mergablity due to igs_pe_person view
281: -------------------------------------------------------------------------------------
282: -- cursor to get person number

Line 283: CURSOR c_person_number (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

279: -- instead of igs_pe_person. This fix is done to remove
280: -- Non-mergablity due to igs_pe_person view
281: -------------------------------------------------------------------------------------
282: -- cursor to get person number
283: CURSOR c_person_number (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
284: SELECT person_number
285: FROM igs_pe_person_base_v
286: WHERE person_id = cp_person_id;
287:

Line 285: FROM igs_pe_person_base_v

281: -------------------------------------------------------------------------------------
282: -- cursor to get person number
283: CURSOR c_person_number (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
284: SELECT person_number
285: FROM igs_pe_person_base_v
286: WHERE person_id = cp_person_id;
287:
288: l_person_number igs_pe_person.person_number%TYPE;
289: BEGIN