APPS.IGS_GR_VAL_CRDP dependencies on IGS_GR_CRMN_ROUND

Line 15: FROM IGS_GR_CRMN_ROUND crd,

11: DECLARE
12: v_crd_daiv_exists VARCHAR2(1);
13: CURSOR c_crd_daiv IS
14: SELECT 'x'
15: FROM IGS_GR_CRMN_ROUND crd,
16: IGS_CA_DA_INST_V daiv
17: WHERE crd.grd_cal_type = p_grd_cal_type AND
18: crd.grd_ci_sequence_number = p_grd_ci_sequence_number AND
19: crd.end_dt_alias = daiv.dt_alias AND

Line 26: FROM IGS_GR_CRMN_ROUND crd,

22: crd.grd_ci_sequence_number = daiv.ci_sequence_number AND
23: TRUNC(daiv.alias_val) < TRUNC(SYSDATE);
24: CURSOR c_crd_daiv2 IS
25: SELECT 'x'
26: FROM IGS_GR_CRMN_ROUND crd,
27: IGS_CA_DA_INST_V daiv
28: WHERE crd.grd_cal_type = p_grd_cal_type AND
29: crd.grd_ci_sequence_number = p_grd_ci_sequence_number AND
30: crd.start_dt_alias = daiv.dt_alias AND

Line 43: --2. Return an error if IGS_GR_CRMN_ROUND end_dt_alias has a

39: IF p_grd_cal_type IS NULL OR
40: p_grd_ci_sequence_number IS NULL THEN
41: RETURN TRUE;
42: END IF;
43: --2. Return an error if IGS_GR_CRMN_ROUND end_dt_alias has a
44: -- value earlier than the current date.
45: OPEN c_crd_daiv;
46: FETCH c_crd_daiv INTO v_crd_daiv_exists;
47: IF c_crd_daiv%FOUND THEN

Line 53: --3. Return a warning if IGS_GR_CRMN_ROUND start_dt_alias has a

49: p_message_name := 'IGS_GR_CANNOT_UPD_DT_EXPIRED';
50: RETURN FALSE; -- Error
51: END IF;
52: CLOSE c_crd_daiv;
53: --3. Return a warning if IGS_GR_CRMN_ROUND start_dt_alias has a
54: -- value earlier than the current date.
55: OPEN c_crd_daiv2;
56: FETCH c_crd_daiv2 INTO v_crd_daiv_exists;
57: IF c_crd_daiv2%FOUND THEN