APPS.AML_MONITOR_WF dependencies on AS_STATUSES_B

Line 2246: from as_statuses_b

2242: l_relative_to_expiration varchar2(1);
2243:
2244: cursor c_chk_is_timelag_lead_status (c_status_code varchar2) is
2245: select 'Y'
2246: from as_statuses_b
2247: where lead_flag = 'Y'
2248: and status_code = c_status_code;
2249:
2250: cursor c_chk_lead_current_status (c_sales_lead_id number) is

Line 2310: FROM as_statuses_b

2306: close c_chk_lead_current_status;
2307:
2308: SELECT nvl(opp_open_status_flag, 'Y')
2309: INTO l_opp_open_status_flag
2310: FROM as_statuses_b
2311: WHERE status_code = l_lead_current_status;
2312:
2313: if l_opp_open_status_flag = 'Y' then
2314: l_condition_true := 'Y'; --Need to validate other Timelag condition

Line 2373: FROM as_statuses_b

2369:
2370: --
2371: SELECT nvl(opp_open_status_flag, 'Y')
2372: INTO l_opp_open_status_flag
2373: FROM as_statuses_b
2374: WHERE status_code = l_lead_current_status;
2375:
2376: if l_opp_open_status_flag = 'Y' then
2377: l_condition_true := 'Y';