APPS.IGS_PR_GEN_003 dependencies on IGS_PR_S_PRG_CAL

Line 26: v_stream_number IGS_PR_S_PRG_CAL.stream_num%TYPE;

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
30: SELECT scpca.stream_num,

Line 27: v_show_cause_length IGS_PR_S_PRG_CAL.show_cause_length%TYPE;

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
30: SELECT scpca.stream_num,
31: scpca.show_cause_length,

Line 28: v_appeal_length IGS_PR_S_PRG_CAL.appeal_length%TYPE;

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
30: SELECT scpca.stream_num,
31: scpca.show_cause_length,
32: scpca.appeal_length

Line 51: FROM IGS_PR_S_PRG_CAL spca

47: CURSOR c_spca IS
48: SELECT spca.stream_num,
49: spca.show_cause_length,
50: spca.appeal_length
51: FROM IGS_PR_S_PRG_CAL spca
52: WHERE spca.s_control_num = 1 AND
53: spca.prg_cal_type = p_prg_cal_type;
54: BEGIN
55: -- Call routine to determine configuration level