APPS.IGS_FI_GET_SUAEH dependencies on IGS_PS_COURSE

Line 10: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,

6: --
7:
8: PROCEDURE FINP_GET_SUAEH(
9: p_person_id IN NUMBER ,
10: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,
11: p_unit_cd IN IGS_PS_UNIT.unit_cd%TYPE ,
12: p_effective_dt IN DATE ,
13: p_table_index IN OUT NOCOPY BINARY_INTEGER ,
14: p_suaeh_table IN OUT NOCOPY IGS_FI_GET_SUAEH.t_suaeh_dtl)

Line 29: CURSOR c_suah ( cp_course_cd IGS_PS_COURSE.course_cd%TYPE,

25: (p_course_cd IS NULL OR
26: sua.course_cd = p_course_cd) AND
27: (p_unit_cd IS NULL OR
28: sua.unit_cd = p_unit_cd);
29: CURSOR c_suah ( cp_course_cd IGS_PS_COURSE.course_cd%TYPE,
30: cp_unit_cd IGS_PS_UNIT.unit_cd%TYPE,
31: cp_effective_dt DATE) IS
32: SELECT PERSON_ID ,
33: COURSE_CD ,

Line 394: cp_course_cd IGS_PS_COURSE.course_cd%TYPE,

390: AS
391: BEGIN
392: DECLARE
393: CURSOR c_suahv_last_enr (
394: cp_course_cd IGS_PS_COURSE.course_cd%TYPE,
395: cp_unit_cd IGS_PS_UNIT.unit_cd%TYPE,
396: cp_effective_dt DATE) IS
397: SELECT *
398: FROM IGS_AS_SUA_H_V suahv