DBA Data[Home] [Help]

APPS.AML_MONITOR_CONDITIONS_PVT dependencies on FND_LOOKUP_VALUES

Line 782: FROM fnd_lookup_values

778: FROM as_statuses_b
779: WHERE lead_flag = 'Y' and enabled_flag = 'Y'
780: UNION ALL
781: SELECT lookup_code time_lag_to_stage
782: FROM fnd_lookup_values
783: WHERE lookup_type = 'TIME_LAG_TO_STAGE'
784: AND enabled_flag = 'Y'
785: AND (start_date_active IS NULL OR start_date_active < SYSDATE)
786: AND (end_date_active IS NULL OR end_date_active > SYSDATE))