APPS.XLE_UTILITIES_GRP dependencies on XLE_HISTORIES

Line 777: FROM XLE_HISTORIES xlh1

773: xlh1.source_column_value,
774: xlh1.effective_from,
775: xlh1.effective_to,
776: xlh1.comments
777: FROM XLE_HISTORIES xlh1
778: where trunc(to_date(l_effective_date,'DD-MM-YYYY'))
779: between (trunc(to_date(effective_from,'DD-MM-YYYY'))) and
780: trunc(nvl(to_date(effective_to,'DD-MM-YYYY'),sysdate))
781: AND xlh1.source_table = l_source_table

Line 793: FROM XLE_HISTORIES xlh1

789: xlh1.source_column_value,
790: xlh1.effective_from,
791: xlh1.effective_to,
792: xlh1.comments
793: FROM XLE_HISTORIES xlh1
794: WHERE xlh1.source_table = l_source_table
795: AND xlh1.source_id = l_entity_id;
796:
797: l_index number := 1;