DBA Data[Home] [Help]

APPS.IGS_PR_GEN_006 dependencies on IGS_PR_GEN_001

Line 304: WHERE IGS_PR_GEN_001.PRGP_GET_CRV_CMT( p_course_cd,

300: spc1.stream_num = spc2.stream_num) OR
301: EXISTS (SELECT 'x'
302: FROM IGS_PR_S_OU_PRG_CAL sopc1,
303: IGS_PR_S_OU_PRG_CAL sopc2
304: WHERE IGS_PR_GEN_001.PRGP_GET_CRV_CMT( p_course_cd,
305: cp_sca_version_number,
306: sopc1.org_unit_cd,
307: sopc1.ou_start_dt) = 'Y' AND
308: sopc1.prg_cal_type = cp_spo_prg_cal_type AND

Line 324: (IGS_PR_GEN_001.PRGP_get_drtn_efctv (

320: scpc2.version_number = scpc1.version_number AND
321: scpc2.prg_cal_type = ci.cal_type AND
322: scpc1.stream_num = scpc2.stream_num)) AND
323: (cp_spo_duration_type = cst_normal OR
324: (IGS_PR_GEN_001.PRGP_get_drtn_efctv (
325: ci.cal_type,
326: ci.sequence_number,
327: p_person_id,
328: p_course_cd) = 'Y') AND

Line 506: v_std_gpa := IGS_PR_GEN_001.PRGP_get_sca_gpa(

502: -- rule / configuration option.
503: DECLARE
504: v_std_gpa NUMBER := 0;
505: BEGIN
506: v_std_gpa := IGS_PR_GEN_001.PRGP_get_sca_gpa(
507: p_person_id,
508: p_course_cd,
509: NULL,
510: NULL,