APPS.BIM_I_LEAD_FACTS_PKG dependencies on AS_SALES_LEADS_LOG

Line 704: as_sales_leads_log hist

700: UPDATE bim_i_lead_facts facts
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)

Line 719: as_sales_leads_log hist

715: )
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)

Line 1367: as_sales_leads_log hist

1363: UPDATE bim_i_lead_facts facts
1364: SET facts.lead_dead_date
1365: = (SELECT TRUNC(MIN(hist.creation_date))
1366: FROM
1367: as_sales_leads_log hist
1368: WHERE
1369: hist.last_update_date between p_start_date and l_sysdate
1370: AND hist.status_code = l_dead_status
1371: AND hist.sales_lead_id = facts.lead_id

Line 1380: as_sales_leads_log hist

1376: )
1377: WHERE
1378: EXISTS (SELECT 1
1379: FROM
1380: as_sales_leads_log hist
1381: WHERE
1382: hist.last_update_date between p_start_date and l_sysdate
1383: AND hist.status_code = l_dead_status
1384: AND hist.sales_lead_id = facts.lead_id

Line 1423: as_sales_leads_log hist

1419: UPDATE bim_i_lead_facts facts
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)

Line 1439: as_sales_leads_log hist

1435: )
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)