APPS.IGS_CA_GEN_002 dependencies on IGS_CA_TYPE

Line 101: IGS_CA_TYPE ct,

97: CURSOR c_m_alias_val1 IS
98: SELECT TRUNC(dai.absolute_val)
99: FROM IGS_CA_DA_INST dai,
100: IGS_CA_INST ci,
101: IGS_CA_TYPE ct,
102: IGS_CA_STAT cs
103: WHERE dai.CAL_TYPE = ci.CAL_TYPE AND
104: dai.ci_sequence_number = ci.sequence_number AND
105: ci.CAL_TYPE = ct.CAL_TYPE AND

Line 115: IGS_CA_TYPE ct,

111: CURSOR c_m_alias_val2 IS
112: SELECT TRUNC(dai.absolute_val)
113: FROM IGS_CA_DA_INST dai,
114: IGS_CA_INST ci,
115: IGS_CA_TYPE ct,
116: IGS_CA_STAT cs
117: WHERE dai.CAL_TYPE = ci.CAL_TYPE AND
118: dai.ci_sequence_number = ci.sequence_number AND
119: ci.CAL_TYPE = ct.CAL_TYPE AND

Line 128: FROM IGS_CA_TYPE ct

124:
125: CURSOR c_holiday (
126: cp_alias_val IGS_CA_DA_INST.absolute_val%TYPE) IS
127: SELECT 'x'
128: FROM IGS_CA_TYPE ct
129: WHERE ct.S_CAL_CAT = cst_holiday AND
130: EXISTS (SELECT 'x'
131: FROM IGS_CA_INST ci,
132: IGS_CA_STAT cs

Line 257: IGS_CA_TYPE ct,

253: FROM IGS_CA_DA_INST dai1,
254: IGS_CA_DA_INST dai2,
255: IGS_CA_DA_INST_PAIR daip,
256: IGS_CA_INST ci,
257: IGS_CA_TYPE ct,
258: IGS_CA_STAT cs
259: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
260: ct.S_CAL_CAT = cst_holiday AND
261: cs.CAL_STATUS = ci.CAL_STATUS AND

Line 280: IGS_CA_TYPE ct,

276: FROM IGS_CA_DA_INST dai1,
277: IGS_CA_DA_INST dai2,
278: IGS_CA_DA_INST_PAIR daip,
279: IGS_CA_INST ci,
280: IGS_CA_TYPE ct,
281: IGS_CA_STAT cs
282: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
283: ct.S_CAL_CAT = cst_holiday AND
284: cs.CAL_STATUS = ci.CAL_STATUS AND

Line 300: FROM IGS_CA_TYPE ct

296:
297: CURSOR c_instbreak (
298: cp_alias_val IGS_CA_DA_INST.absolute_val%TYPE) IS
299: SELECT 'x'
300: FROM IGS_CA_TYPE ct
301: WHERE ct.S_CAL_CAT = cst_holiday AND
302: EXISTS (SELECT 'x'
303: FROM IGS_CA_INST ci,
304: IGS_CA_STAT cs

Line 622: IGS_CA_TYPE ct,

618: CURSOR c_m_alias_val IS
619: SELECT TRUNC(max(dai.absolute_val)), TRUNC(min(dai.absolute_val))
620: FROM IGS_CA_DA_INST dai,
621: IGS_CA_INST ci,
622: IGS_CA_TYPE ct,
623: IGS_CA_STAT cs
624: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
625: ct.S_CAL_CAT = cst_holiday AND
626: cs.s_cal_status = ci.CAL_STATUS AND

Line 632: FROM IGS_CA_TYPE ct

628: dai.CAL_TYPE = ci.CAL_TYPE;
629: CURSOR c_holiday (
630: cp_alias_val IGS_CA_DA_INST.absolute_val%TYPE) IS
631: SELECT 'x'
632: FROM IGS_CA_TYPE ct
633: WHERE ct.S_CAL_CAT = cst_holiday AND
634: EXISTS (SELECT 'x'
635: FROM IGS_CA_INST ci,
636: IGS_CA_STAT cs

Line 745: IGS_CA_TYPE ct,

741: FROM IGS_CA_DA_INST dai1,
742: IGS_CA_DA_INST dai2,
743: IGS_CA_DA_INST_PAIR daip,
744: IGS_CA_INST ci,
745: IGS_CA_TYPE ct,
746: IGS_CA_STAT cs
747: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
748: ct.S_CAL_CAT = cst_holiday AND
749: cs.s_cal_status = ci.CAL_STATUS AND

Line 763: FROM IGS_CA_TYPE ct

759: dai2.ci_sequence_number = daip.related_ci_sequence_number;
760: CURSOR c_instbreak (
761: cp_alias_val IGS_CA_DA_INST.absolute_val%TYPE) IS
762: SELECT 'x'
763: FROM IGS_CA_TYPE ct
764: WHERE ct.S_CAL_CAT = cst_holiday AND
765: EXISTS (SELECT 'x'
766: FROM IGS_CA_INST ci,
767: IGS_CA_STAT cs

Line 1262: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;

1258: p_cal_type IN VARCHAR2 ,
1259: p_message_name OUT NOCOPY VARCHAR2)
1260: RETURN BOOLEAN AS
1261: v_other_detail VARCHAR2(255);
1262: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;
1263: CURSOR c_get_closed_ind IS
1264: SELECT closed_ind
1265: FROM IGS_CA_TYPE
1266: WHERE CAL_TYPE = p_cal_type;

Line 1265: FROM IGS_CA_TYPE

1261: v_other_detail VARCHAR2(255);
1262: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;
1263: CURSOR c_get_closed_ind IS
1264: SELECT closed_ind
1265: FROM IGS_CA_TYPE
1266: WHERE CAL_TYPE = p_cal_type;
1267: BEGIN
1268: p_message_name := NULL;
1269: OPEN c_get_closed_ind;