APPS.AS_ACCESS_PVT dependencies on AS_LEADS_ALL

Line 522: from as_leads_all lead, as_accesses_all a, as_rpt_managers_v rm

518: or (rm.parent_resource_id <> rm.resource_id)));
519:
520: cursor am_mgr_access_csr(p_resource_id number) is
521: select 'x'
522: from as_leads_all lead, as_accesses_all a, as_rpt_managers_v rm
523: where lead.customer_id = a.customer_id
524: and a.salesforce_id = rm.resource_id
525: and a.salesforce_role_code = 'AM'
526: and rm.parent_resource_id = p_resource_id

Line 563: from as_leads_all lead, as_accesses_all a, as_rpt_admins_v rm

559: and rm.parent_sales_group_id = p_admin_group_id);
560:
561: cursor am_admin_access_csr is
562: select 'x'
563: from as_leads_all lead, as_accesses_all a, as_rpt_admins_v rm
564: where lead.customer_id = a.customer_id
565: and a.salesforce_id = rm.salesforce_id
566: and a.salesforce_role_code = 'AM'
567: and rm.parent_sales_group_id = p_admin_group_id

Line 1149: FROM as_leads_all

1145: )
1146: IS
1147: CURSOR C_Lead_Id_Exists (X_Lead_Id NUMBER) IS
1148: SELECT 'X'
1149: FROM as_leads_all
1150: WHERE lead_id = X_Lead_Id;
1151:
1152: l_val VARCHAR2(1);
1153: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 1659: from as_leads_all ld, as_statuses_b st

1655: l_lead_rank_score number;
1656:
1657: cursor get_opp_open_flag_csr(pc_lead_id number) is
1658: select decode(st.opp_open_status_flag,'N',NULL,st.opp_open_status_flag)
1659: from as_leads_all ld, as_statuses_b st
1660: where ld.lead_id = pc_lead_id
1661: and ld.status = st.status_code(+);
1662:
1663: cursor get_lead_open_flag_csr(pc_sales_lead_id number) is

Line 2162: update as_leads_all set object_version_number = nvl(object_version_number,0) + 1, owner_salesforce_id = l_sales_team_rec.salesforce_id,

2158: x_return_status := l_return_status;
2159:
2160: if is_sales_lead_owner_row(x_access_id)
2161: then
2162: update as_leads_all set object_version_number = nvl(object_version_number,0) + 1, owner_salesforce_id = l_sales_team_rec.salesforce_id,
2163: owner_sales_group_id = l_sales_team_rec.sales_group_id
2164: where lead_id = l_sales_team_rec.lead_id;
2165: end if;
2166:

Line 3142: update as_leads_all set object_version_number = nvl(object_version_number,0) + 1, owner_salesforce_id = l_sales_team_rec.salesforce_id,

3138: x_return_status := l_return_status;
3139:
3140: if is_sales_lead_owner_row(l_sales_team_rec.access_id)
3141: then
3142: update as_leads_all set object_version_number = nvl(object_version_number,0) + 1, owner_salesforce_id = l_sales_team_rec.salesforce_id,
3143: --owner_sales_group_id = l_sales_team_rec.sales_group_id
3144: owner_sales_group_id = (select sales_group_id from as_accesses_all where access_id = l_sales_team_rec.access_id)
3145: where lead_id = l_sales_team_rec.lead_id;
3146: end if;

Line 4709: from as_leads_all

4705: and opp.lead_id = p_opportunity_id;
4706:
4707: cursor find_lead_org is
4708: select org_id
4709: from as_leads_all
4710: where lead_id = p_opportunity_id;
4711:
4712: cursor c_org_access(p_org_id NUMBER) is
4713: select 'Y'

Line 5032: from as_leads_all

5028: and opp.lead_id = p_opportunity_id;
5029:
5030: cursor find_lead_org is
5031: select org_id
5032: from as_leads_all
5033: where lead_id = p_opportunity_id;
5034:
5035: cursor c_org_access(p_org_id NUMBER) is
5036: select 'Y'