APPS.IGS_PR_GEN_003 dependencies on IGS_PR_S_OU_PRG_CONF

Line 158: v_org_unit_cd IGS_PR_S_OU_PRG_CONF.org_unit_cd%TYPE;

154: DECLARE
155: cst_course CONSTANT VARCHAR2(10) := 'COURSE';
156: cst_system CONSTANT VARCHAR2(10) := 'SYSTEM';
157: cst_ou CONSTANT VARCHAR2(10) := 'OU';
158: v_org_unit_cd IGS_PR_S_OU_PRG_CONF.org_unit_cd%TYPE;
159: v_ou_start_dt IGS_PR_S_OU_PRG_CONF.ou_start_dt%TYPE;
160: v_dummy VARCHAR2(1);
161: CURSOR c_scpc IS
162: SELECT 'X'

Line 159: v_ou_start_dt IGS_PR_S_OU_PRG_CONF.ou_start_dt%TYPE;

155: cst_course CONSTANT VARCHAR2(10) := 'COURSE';
156: cst_system CONSTANT VARCHAR2(10) := 'SYSTEM';
157: cst_ou CONSTANT VARCHAR2(10) := 'OU';
158: v_org_unit_cd IGS_PR_S_OU_PRG_CONF.org_unit_cd%TYPE;
159: v_ou_start_dt IGS_PR_S_OU_PRG_CONF.ou_start_dt%TYPE;
160: v_dummy VARCHAR2(1);
161: CURSOR c_scpc IS
162: SELECT 'X'
163: FROM IGS_PR_S_CRV_PRG_CON scpc

Line 174: FROM IGS_PR_S_OU_PRG_CONF sopc

170: scpca.version_number = p_version_number;
171: CURSOR c_sopc IS
172: SELECT sopc.org_unit_cd,
173: sopc.ou_start_dt
174: FROM IGS_PR_S_OU_PRG_CONF sopc
175: WHERE IGS_PR_GEN_001.PRGP_GET_CRV_CMT (
176: p_course_cd,
177: p_version_number,
178: sopc.org_unit_cd,

Line 315: cp_org_unit_cd IGS_PR_S_OU_PRG_CONF.org_unit_cd%TYPE,

311: sprgc.outcome_check_type
312: FROM IGS_PR_S_PRG_CONF sprgc
313: WHERE sprgc.s_control_num = 1;
314: CURSOR c_sopc (
315: cp_org_unit_cd IGS_PR_S_OU_PRG_CONF.org_unit_cd%TYPE,
316: cp_ou_start_dt IGS_PR_S_OU_PRG_CONF.ou_start_dt%TYPE) IS
317: SELECT sopc.apply_start_dt_alias,
318: sopc.apply_end_dt_alias,
319: sopc.end_benefit_dt_alias,

Line 316: cp_ou_start_dt IGS_PR_S_OU_PRG_CONF.ou_start_dt%TYPE) IS

312: FROM IGS_PR_S_PRG_CONF sprgc
313: WHERE sprgc.s_control_num = 1;
314: CURSOR c_sopc (
315: cp_org_unit_cd IGS_PR_S_OU_PRG_CONF.org_unit_cd%TYPE,
316: cp_ou_start_dt IGS_PR_S_OU_PRG_CONF.ou_start_dt%TYPE) IS
317: SELECT sopc.apply_start_dt_alias,
318: sopc.apply_end_dt_alias,
319: sopc.end_benefit_dt_alias,
320: sopc.end_penalty_dt_alias,

Line 332: FROM IGS_PR_S_OU_PRG_CONF sopc

328: sopc.count_exc_in_time_ind,
329: sopc.calculate_wam_ind,
330: sopc.calculate_gpa_ind,
331: sopc.outcome_check_type
332: FROM IGS_PR_S_OU_PRG_CONF sopc
333: WHERE sopc.org_unit_cd = cp_org_unit_cd AND
334: sopc.ou_start_dt = cp_ou_start_dt;
335: CURSOR c_scpc IS
336: SELECT scpc.apply_start_dt_alias,