APPS.BIM_I_LEAD_FACTS_PKG dependencies on AS_STATUSES_B

Line 705: ,as_statuses_b st

701: SET (facts.lead_closed_date, facts.lead_touched_date)
702: = (SELECT TRUNC(MIN(hist.creation_date)), TRUNC(MIN(hist.creation_date))
703: FROM
704: as_sales_leads_log hist
705: ,as_statuses_b st
706: WHERE
707: hist.last_update_date between p_start_date and l_sysdate
708: AND hist.status_code not in (l_conv_opp_status, l_dead_status)
709: AND hist.status_code = st.status_code

Line 720: ,as_statuses_b st

716: WHERE
717: EXISTS (SELECT 1
718: FROM
719: as_sales_leads_log hist
720: ,as_statuses_b st
721: WHERE
722: hist.last_update_date between p_start_date and l_sysdate
723: AND hist.status_code not in (l_conv_opp_status, l_dead_status)
724: AND hist.status_code = st.status_code

Line 1424: ,as_statuses_b st

1420: SET facts.lead_closed_date
1421: = (SELECT TRUNC(MIN(hist.creation_date))
1422: FROM
1423: as_sales_leads_log hist
1424: ,as_statuses_b st
1425: WHERE
1426: hist.last_update_date between p_start_date and l_sysdate
1427: AND hist.status_code not in (l_conv_opp_status, l_dead_status)
1428: AND hist.status_code = st.status_code

Line 1440: ,as_statuses_b st

1436: WHERE
1437: EXISTS (SELECT 1
1438: FROM
1439: as_sales_leads_log hist
1440: ,as_statuses_b st
1441: WHERE
1442: hist.last_update_date between p_start_date and l_sysdate
1443: AND hist.status_code not in (l_conv_opp_status, l_dead_status)
1444: AND hist.status_code = st.status_code