1789: cp_start_date_alias IN VARCHAR2,
1790: cp_end_date_alias IN VARCHAR2
1791: ) IS
1792: SELECT 'Y'
1793: FROM igs_ca_da_inst_v dai1,
1794: igs_ca_da_inst_v dai2
1795: WHERE dai1.alias_val >= TRUNC (SYSDATE)
1796: AND dai2.alias_val <= TRUNC (SYSDATE)
1797: AND dai1.cal_type = dai2.cal_type
1790: cp_end_date_alias IN VARCHAR2
1791: ) IS
1792: SELECT 'Y'
1793: FROM igs_ca_da_inst_v dai1,
1794: igs_ca_da_inst_v dai2
1795: WHERE dai1.alias_val >= TRUNC (SYSDATE)
1796: AND dai2.alias_val <= TRUNC (SYSDATE)
1797: AND dai1.cal_type = dai2.cal_type
1798: AND dai1.ci_sequence_number = dai2.ci_sequence_number