APPS.IGS_PR_GEN_003 dependencies on IGS_OR_UNIT

Line 24: v_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE;

20: cst_course CONSTANT VARCHAR2(10) := 'COURSE';
21: cst_ou CONSTANT VARCHAR2(10) := 'OU';
22: v_basic_level VARCHAR2(10);
23: v_calendar_level VARCHAR2(10);
24: v_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE;
25: v_ou_start_dt IGS_OR_UNIT.start_dt%TYPE;
26: v_stream_number IGS_PR_S_PRG_CAL.stream_num%TYPE;
27: v_show_cause_length IGS_PR_S_PRG_CAL.show_cause_length%TYPE;
28: v_appeal_length IGS_PR_S_PRG_CAL.appeal_length%TYPE;

Line 25: v_ou_start_dt IGS_OR_UNIT.start_dt%TYPE;

21: cst_ou CONSTANT VARCHAR2(10) := 'OU';
22: v_basic_level VARCHAR2(10);
23: v_calendar_level VARCHAR2(10);
24: v_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE;
25: v_ou_start_dt IGS_OR_UNIT.start_dt%TYPE;
26: v_stream_number IGS_PR_S_PRG_CAL.stream_num%TYPE;
27: v_show_cause_length IGS_PR_S_PRG_CAL.show_cause_length%TYPE;
28: v_appeal_length IGS_PR_S_PRG_CAL.appeal_length%TYPE;
29: CURSOR c_scpca IS

Line 38: cp_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,

34: WHERE scpca.course_cd = p_course_cd AND
35: scpca.version_number = p_version_number AND
36: scpca.prg_cal_type = p_prg_cal_type;
37: CURSOR c_sopca (
38: cp_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,
39: cp_ou_start_dt IGS_OR_UNIT.start_dt%TYPE) IS
40: SELECT sopca.stream_num,
41: sopca.show_cause_length,
42: sopca.appeal_length

Line 39: cp_ou_start_dt IGS_OR_UNIT.start_dt%TYPE) IS

35: scpca.version_number = p_version_number AND
36: scpca.prg_cal_type = p_prg_cal_type;
37: CURSOR c_sopca (
38: cp_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,
39: cp_ou_start_dt IGS_OR_UNIT.start_dt%TYPE) IS
40: SELECT sopca.stream_num,
41: sopca.show_cause_length,
42: sopca.appeal_length
43: FROM IGS_PR_S_OU_PRG_CAL sopca

Line 294: v_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE;

290: cst_system CONSTANT VARCHAR2(10) := 'SYSTEM';
291: cst_ou CONSTANT VARCHAR2(10) := 'OU';
292: v_basic_level VARCHAR2(10);
293: v_calendar_level VARCHAR2(10);
294: v_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE;
295: v_ou_start_dt IGS_OR_UNIT.start_dt%TYPE;
296: CURSOR c_sprgc IS
297: SELECT sprgc.apply_start_dt_alias,
298: sprgc.apply_end_dt_alias,

Line 295: v_ou_start_dt IGS_OR_UNIT.start_dt%TYPE;

291: cst_ou CONSTANT VARCHAR2(10) := 'OU';
292: v_basic_level VARCHAR2(10);
293: v_calendar_level VARCHAR2(10);
294: v_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE;
295: v_ou_start_dt IGS_OR_UNIT.start_dt%TYPE;
296: CURSOR c_sprgc IS
297: SELECT sprgc.apply_start_dt_alias,
298: sprgc.apply_end_dt_alias,
299: sprgc.end_benefit_dt_alias,