APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_HE_OU_CC

Line 4606: igs_he_ou_cc org,

4602: -- Cost Centers at POOUS / ORG Level
4603: CURSOR poo_org_cc_dtls_cur IS
4604: SELECT 'X'
4605: FROM
4606: igs_he_ou_cc org,
4607: igs_he_poous_ou_all poo
4608: WHERE
4609: org.org_unit_cd = poo.organization_unit
4610: AND poo.course_cd = p_course_cd

Line 4639: igs_he_ou_cc org,

4635: -- Cost Centers at Program / Org Level
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

Line 4671: igs_he_ou_cc org,

4667: -- Cost Centers at Unit / Org Level
4668: CURSOR unit_org_cc_dtls_cur IS
4669: SELECT 'X'
4670: FROM
4671: igs_he_ou_cc org,
4672: igs_ps_tch_resp ps,
4673: igs_en_su_attempt_all su
4674: WHERE
4675: org.org_unit_cd = ps.org_unit_cd

Line 4697: FROM igs_he_ou_cc org,

4693:
4694: -- Cost Centers at Module / Org Level
4695: CURSOR module_org_cc_dtls_cur IS
4696: SELECT 'X'
4697: FROM igs_he_ou_cc org,
4698: igs_ps_tch_resp ptr
4699: WHERE ptr.unit_cd = p_unit_cd
4700: AND ptr.version_number = p_uv_version_number
4701: AND ptr.org_unit_cd = org.org_unit_cd;

Line 4793: FROM igs_he_ou_cc org,

4789: OPEN c_cc FOR
4790: SELECT org.cost_centre,
4791: org.subject,
4792: SUM((NVL(poo.proportion,0) * org.proportion / 100)) proportion
4793: FROM igs_he_ou_cc org,
4794: igs_he_poous_ou_all poo
4795: WHERE org.org_unit_cd = poo.organization_unit
4796: AND poo.course_cd = p_course_cd
4797: AND poo.crv_version_number = p_version_number

Line 4842: FROM igs_he_ou_cc org,

4838: OPEN c_cc FOR
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

Line 4911: FROM igs_he_ou_cc org,

4907: OPEN c_cc FOR
4908: SELECT org.cost_centre,
4909: org.subject,
4910: SUM(ps.percentage * org.proportion / 100) proportion
4911: FROM igs_he_ou_cc org,
4912: igs_ps_tch_resp ps,
4913: igs_en_su_attempt_all su
4914: WHERE org.org_unit_cd = ps.org_unit_cd
4915: AND ps.unit_cd = su.unit_cd

Line 4974: FROM igs_he_ou_cc org,

4970: OPEN c_cc FOR
4971: SELECT cost_centre,
4972: subject,
4973: SUM(proportion*percentage/100) proportion
4974: FROM igs_he_ou_cc org,
4975: igs_ps_tch_resp ptr
4976: WHERE ptr.unit_cd = p_unit_cd
4977: AND ptr.version_number = p_uv_version_number
4978: AND ptr.org_unit_cd = org.org_unit_cd