APPS.IGS_PS_GEN_002 dependencies on IGS_PS_GOVT_SPL_TYPE

Line 363: v_gsct_description igs_ps_govt_spl_type.description%TYPE;

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);
366: CURSOR c_find_ct_desc IS
367: SELECT description

Line 377: FROM igs_ps_govt_spl_type

373: WHERE party_number = p_responsible_org_unit_cd AND
374: start_dt = p_responsible_ou_start_dt;
375: CURSOR c_find_gsct_desc IS
376: SELECT description
377: FROM igs_ps_govt_spl_type
378: WHERE govt_special_course_type = p_govt_special_course_type;
379: /*************************************************************
380: Created By :
381: Date Created By :