APPS.IGS_EN_SPA_TERMS_API dependencies on IGS_EN_PLAN_UNITS

Line 472: CURSOR c_check_planning_sheet (p_person_id IGS_EN_PLAN_UNITS.PERSON_ID%TYPE,

468: FROM IGS_EN_SPA_TERMS spat
469: WHERE spat.term_record_id = cp_term_record_id;
470:
471: vc_cur_spat_rec cur_spat%ROWTYPE;
472: CURSOR c_check_planning_sheet (p_person_id IGS_EN_PLAN_UNITS.PERSON_ID%TYPE,
473: p_course_cd IGS_EN_PLAN_UNITS.COURSE_CD%TYPE,
474: p_term_cal_type IGS_EN_PLAN_UNITS.TERM_CAL_TYPE%TYPE,
475: p_term_ci_sequence IGS_EN_PLAN_UNITS.TERM_CI_SEQUENCE_NUMBER%TYPE
476: ) IS

Line 473: p_course_cd IGS_EN_PLAN_UNITS.COURSE_CD%TYPE,

469: WHERE spat.term_record_id = cp_term_record_id;
470:
471: vc_cur_spat_rec cur_spat%ROWTYPE;
472: CURSOR c_check_planning_sheet (p_person_id IGS_EN_PLAN_UNITS.PERSON_ID%TYPE,
473: p_course_cd IGS_EN_PLAN_UNITS.COURSE_CD%TYPE,
474: p_term_cal_type IGS_EN_PLAN_UNITS.TERM_CAL_TYPE%TYPE,
475: p_term_ci_sequence IGS_EN_PLAN_UNITS.TERM_CI_SEQUENCE_NUMBER%TYPE
476: ) IS
477: SELECT person_id

Line 474: p_term_cal_type IGS_EN_PLAN_UNITS.TERM_CAL_TYPE%TYPE,

470:
471: vc_cur_spat_rec cur_spat%ROWTYPE;
472: CURSOR c_check_planning_sheet (p_person_id IGS_EN_PLAN_UNITS.PERSON_ID%TYPE,
473: p_course_cd IGS_EN_PLAN_UNITS.COURSE_CD%TYPE,
474: p_term_cal_type IGS_EN_PLAN_UNITS.TERM_CAL_TYPE%TYPE,
475: p_term_ci_sequence IGS_EN_PLAN_UNITS.TERM_CI_SEQUENCE_NUMBER%TYPE
476: ) IS
477: SELECT person_id
478: FROM IGS_EN_PLAN_UNITS

Line 475: p_term_ci_sequence IGS_EN_PLAN_UNITS.TERM_CI_SEQUENCE_NUMBER%TYPE

471: vc_cur_spat_rec cur_spat%ROWTYPE;
472: CURSOR c_check_planning_sheet (p_person_id IGS_EN_PLAN_UNITS.PERSON_ID%TYPE,
473: p_course_cd IGS_EN_PLAN_UNITS.COURSE_CD%TYPE,
474: p_term_cal_type IGS_EN_PLAN_UNITS.TERM_CAL_TYPE%TYPE,
475: p_term_ci_sequence IGS_EN_PLAN_UNITS.TERM_CI_SEQUENCE_NUMBER%TYPE
476: ) IS
477: SELECT person_id
478: FROM IGS_EN_PLAN_UNITS
479: WHERE person_id = p_person_id

Line 478: FROM IGS_EN_PLAN_UNITS

474: p_term_cal_type IGS_EN_PLAN_UNITS.TERM_CAL_TYPE%TYPE,
475: p_term_ci_sequence IGS_EN_PLAN_UNITS.TERM_CI_SEQUENCE_NUMBER%TYPE
476: ) IS
477: SELECT person_id
478: FROM IGS_EN_PLAN_UNITS
479: WHERE person_id = p_person_id
480: AND course_cd = p_course_cd
481: AND term_cal_type = p_term_cal_type
482: AND term_ci_sequence_number = p_term_ci_sequence