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.

[Home] [Help]

APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_HE_PROG_OU_CC

Line 4621: CURSOR prg_cc_dtls_cur( cp_course_cd IGS_HE_PROG_OU_CC.course_cd%TYPE,

4617: AND poo.location_cd = p_location_cd;
4618:
4619:
4620: -- Cost Centers at Program Version Level
4621: CURSOR prg_cc_dtls_cur( cp_course_cd IGS_HE_PROG_OU_CC.course_cd%TYPE,
4622: cp_version_number IGS_HE_PROG_OU_CC.version_number%TYPE) IS
4623: SELECT 'X'
4624: FROM
4625: IGS_HE_PROG_OU_CC pcc,

Line 4622: cp_version_number IGS_HE_PROG_OU_CC.version_number%TYPE) IS

4618:
4619:
4620: -- Cost Centers at Program Version Level
4621: CURSOR prg_cc_dtls_cur( cp_course_cd IGS_HE_PROG_OU_CC.course_cd%TYPE,
4622: cp_version_number IGS_HE_PROG_OU_CC.version_number%TYPE) IS
4623: SELECT 'X'
4624: FROM
4625: IGS_HE_PROG_OU_CC pcc,
4626: IGS_PS_OWN pown

Line 4625: IGS_HE_PROG_OU_CC pcc,

4621: CURSOR prg_cc_dtls_cur( cp_course_cd IGS_HE_PROG_OU_CC.course_cd%TYPE,
4622: cp_version_number IGS_HE_PROG_OU_CC.version_number%TYPE) IS
4623: SELECT 'X'
4624: FROM
4625: IGS_HE_PROG_OU_CC pcc,
4626: IGS_PS_OWN pown
4627: WHERE
4628: pcc.course_cd = p_course_cd
4629: AND pcc.version_number = p_version_number

Line 4819: FROM igs_he_prog_ou_cc pcc,

4815: CLOSE prg_cc_dtls_cur;
4816:
4817: OPEN c_cc FOR
4818: SELECT cost_centre, subject, SUM(proportion*percentage/100) proportion
4819: FROM igs_he_prog_ou_cc pcc,
4820: igs_ps_own pown
4821: WHERE pcc.course_cd = p_course_cd
4822: AND pcc.version_number = p_version_number
4823: AND pcc.course_cd = pown.course_cd