APPS.AML_MONITOR_WF dependencies on AS_LOOKUPS

Line 787: from as_lookups

783: and mgr.reports_to_flag = 'Y';
784:
785: cursor c_get_meaning (c_lookup_type varchar2, c_lookup_code varchar2) is
786: select meaning
787: from as_lookups
788: where lookup_type = c_lookup_type
789: and lookup_code = c_lookup_code;
790:
791: cursor c_get_lead_status_meaning (c_status_code varchar2) is

Line 2257: from as_lookups

2253: where sales_lead_id = c_sales_lead_id;
2254:
2255: cursor c_chk_timelag_to_stage (c_lookup_code varchar2) is
2256: select 'Y'
2257: from as_lookups
2258: where lookup_type = 'TIME_LAG_TO_STAGE'
2259: and lookup_code = c_lookup_code;
2260:
2261: cursor c_chk_lead_accepted (c_sales_lead_id number) is