APPS.AS_LEAD_ROUTING_WF dependencies on AS_SALES_LEADS_LOG

Line 443: FROM AS_SALES_LEADS_LOG LOG

439: WHERE ACC.SALES_LEAD_ID = c_sales_lead_id
440: AND ACC.CREATED_BY_TAP_FLAG = 'Y'
441: AND NOT EXISTS (
442: SELECT 1
443: FROM AS_SALES_LEADS_LOG LOG
444: WHERE LOG.SALES_LEAD_ID = c_sales_lead_id
445: AND LOG.ASSIGN_TO_SALESFORCE_ID = ACC.SALESFORCE_ID
446: AND (LOG.ASSIGN_SALES_GROUP_ID = ACC.SALES_GROUP_ID
447: OR LOG.ASSIGN_SALES_GROUP_ID IS NULL AND ACC.SALES_GROUP_ID IS NULL))

Line 962: AS_SALES_LEADS_LOG_PKG.Insert_Row(

958: l_qualified_flag, l_freeze_flag, l_status_code;
959: CLOSE c_sales_lead;
960:
961: -- Call API to create log entry
962: AS_SALES_LEADS_LOG_PKG.Insert_Row(
963: px_log_id => l_sales_lead_log_id ,
964: p_sales_lead_id => l_sales_lead_id,
965: p_created_by => fnd_global.user_id,
966: p_creation_date => SYSDATE,

Line 1311: FROM as_sales_leads_log

1307: l_sales_lead_id NUMBER;
1308:
1309: CURSOR c_checklog (resource_id_in number, sl_id_in number) IS
1310: SELECT count(log_id)
1311: FROM as_sales_leads_log
1312: WHERE assign_to_salesforce_id = resource_id_in
1313: and sales_lead_id = sl_id_in;
1314:
1315: BEGIN