APPS.ASN_MIG_SALES_TEAM_PVT dependencies on AS_ACCESSES_ALL_LEAD_TEMP

Line 412: FROM AS_ACCESSES_ALL_LEAD_TEMP

408: l_user_id NUMBER;
409:
410: CURSOR c_leads_in_range(p_start_id NUMBER, p_end_id NUMBER) IS
411: SELECT DISTINCT sales_lead_id
412: FROM AS_ACCESSES_ALL_LEAD_TEMP
413: WHERE sales_lead_id BETWEEN p_start_id AND p_end_id;
414:
415:
416:

Line 438: FROM AS_ACCESSES_ALL_LEAD_TEMP -- AS_ACCESSES_ALL

434: max(FREEZE_FLAG) freeze_flag,
435: max(TEAM_LEADER_FLAG) team_leader_flag,
436: max(OWNER_FLAG) owner_flag,
437: max(CONTRIBUTOR_FLAG) contributor_flag
438: FROM AS_ACCESSES_ALL_LEAD_TEMP -- AS_ACCESSES_ALL
439: WHERE sales_lead_id = p_sales_lead_id
440: GROUP BY salesforce_id, sales_group_id;
441:
442: --Code added for ASN migration approach suggested by lester -- End

Line 688: INSERT /*+ APPEND PARALLEL(CUST) */ into AS_ACCESSES_ALL_LEAD_TEMP CUST

684: partner_cont_party_id
685: HAVING count(access_id) > 1;
686: COMMIT;
687:
688: INSERT /*+ APPEND PARALLEL(CUST) */ into AS_ACCESSES_ALL_LEAD_TEMP CUST
689: (sales_lead_id,
690: code_access_id,
691: salesforce_id,
692: sales_group_id,

Line 780: From AS_ACCESSES_ALL_LEAD_TEMP;

776: ORDER BY customer_id;
777: ELSE -- lead
778: Select count(DISTINCT sales_lead_id),min(sales_lead_id),max(sales_lead_id)
779: into l_dup_count_lead,l_dup_min_lead,l_max_id
780: From AS_ACCESSES_ALL_LEAD_TEMP;
781:
782: l_max_num_rows := l_dup_count_lead;
783: l_start_id := l_dup_min_lead-1;
784: ls_program := 'ASN_MIG_DUP_ST_LEAD_PRG';

Line 788: FROM AS_ACCESSES_ALL_LEAD_TEMP

784: ls_program := 'ASN_MIG_DUP_ST_LEAD_PRG';
785: Select distinct sales_lead_id
786: BULK COLLECT INTO
787: l_id_list
788: FROM AS_ACCESSES_ALL_LEAD_TEMP
789: ORDER BY sales_lead_id;
790: END IF;
791: --Code added for ASN migration approach suggested by lester --Bug#5816258 -- End
792: --