DBA Data[Home] [Help]

APPS.IGS_AS_DERIVE_GRADE dependencies on IGS_CA_DA_INST_V

Line 1793: FROM igs_ca_da_inst_v dai1,

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

Line 1794: igs_ca_da_inst_v dai2

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