APPS.IGS_PS_GEN_002 dependencies on IGS_PS_TYPE

Line 361: v_ct_description igs_ps_type.description%TYPE;

357: p_primary_program_rank IN NUMBER,
358: p_n_max_wlst_per_stud IN NUMBER,
359: p_n_annual_instruction_time IN NUMBER)
360: AS
361: v_ct_description igs_ps_type.description%TYPE;
362: v_ou_description igs_or_unit.description%TYPE;
363: v_gsct_description igs_ps_govt_spl_type.description%TYPE;
364: x_rowid VARCHAR(25);
365: l_org_id NUMBER(15);

Line 368: FROM igs_ps_type

364: x_rowid VARCHAR(25);
365: l_org_id NUMBER(15);
366: CURSOR c_find_ct_desc IS
367: SELECT description
368: FROM igs_ps_type
369: WHERE course_type = p_course_type;
370: CURSOR c_find_ou_desc IS
371: SELECT party_name description
372: FROM igs_or_inst_org_base_v