DBA Data[Home] [Help]

APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_PS_OWN

Line 4626: IGS_PS_OWN pown

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
4630: AND pcc.course_cd = pown.course_cd

Line 4640: igs_ps_own ps

4636: CURSOR prg_org_cc_dtls_cur IS
4637: SELECT 'X'
4638: FROM
4639: igs_he_ou_cc org,
4640: igs_ps_own ps
4641: WHERE
4642: org.org_unit_cd = ps.org_unit_cd
4643: AND ps.course_cd = p_course_cd
4644: AND ps.version_number = p_version_number;

Line 4820: igs_ps_own pown

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
4824: AND pcc.version_number = pown.version_number

Line 4843: igs_ps_own ps

4839: SELECT org.cost_centre,
4840: org.subject,
4841: SUM(ps.percentage * org.proportion / 100) proportion
4842: FROM igs_he_ou_cc org,
4843: igs_ps_own ps
4844: WHERE org.org_unit_cd = ps.org_unit_cd
4845: AND ps.course_cd = p_course_cd
4846: AND ps.version_number = p_version_number
4847: GROUP BY org.cost_centre, org.subject