[Home] [Help]
246: and rm.parent_sales_group_id = p_admin_group_id);
247:
248: cursor am_mgr_access_csr(p_resource_id number) is
249: select 'x'
250: from as_sales_leads lead, as_accesses_all a, as_rpt_managers_v rm
251: where lead.customer_id = a.customer_id
252: and a.salesforce_id = rm.resource_id
253: and a.salesforce_role_code = 'AM'
254: and rm.parent_resource_id = p_resource_id
255: and lead.sales_lead_id = p_sales_lead_id;
256:
257: cursor am_admin_access_csr is
258: select 'x'
259: from as_sales_leads lead, as_accesses_all a, as_rpt_admins_v rm
260: where lead.customer_id = a.customer_id
261: and a.salesforce_id = rm.salesforce_id
262: and a.salesforce_role_code = 'AM'
263: and rm.parent_sales_group_id = p_admin_group_id
1087: )
1088: IS
1089: CURSOR C_Sales_Lead_Id_Exists (X_Sales_Lead_Id NUMBER) IS
1090: SELECT 'X'
1091: FROM as_sales_leads
1092: WHERE sales_lead_id = X_Sales_Lead_Id;
1093:
1094: l_val VARCHAR2(1);
1095: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1661: and ld.status = st.status_code(+);
1662:
1663: cursor get_lead_open_flag_csr(pc_sales_lead_id number) is
1664: select decode(st.opp_open_status_flag,'N',NULL,st.opp_open_status_flag)
1665: from as_sales_leads ld, as_statuses_b st
1666: where ld.sales_lead_id = pc_sales_lead_id
1667: and ld.status_code = st.status_code(+);
1668:
1669: cursor get_lead_rank_score_csr(pc_sales_lead_id number) is
1667: and ld.status_code = st.status_code(+);
1668:
1669: cursor get_lead_rank_score_csr(pc_sales_lead_id number) is
1670: select rank.min_score
1671: from as_sales_lead_ranks_b rank, as_sales_leads sl
1672: where sl.sales_lead_id = pc_sales_lead_id
1673: and sl.lead_rank_id = rank.rank_id(+);
1674:
1675: cursor get_lead_creation_date_csr(pc_sales_lead_id number) is
1673: and sl.lead_rank_id = rank.rank_id(+);
1674:
1675: cursor get_lead_creation_date_csr(pc_sales_lead_id number) is
1676: select sl.creation_date
1677: from as_sales_leads sl
1678: where sl.sales_lead_id = pc_sales_lead_id;
1679:
1680: cursor get_dup_access_id_csr(p_sales_team_rec in SALES_TEAM_REC_TYPE) is
1681: select access_id
4146: and rm.parent_sales_group_id = p_admin_group_id);
4147:
4148: cursor am_mgr_access_csr(p_resource_id number) is
4149: select 'x'
4150: from as_sales_leads lead, as_accesses_all a, as_rpt_managers_v rm
4151: where lead.customer_id = a.customer_id
4152: and a.salesforce_id = rm.resource_id
4153: and a.salesforce_role_code = 'AM'
4154: and rm.parent_resource_id = p_resource_id
4155: and lead.sales_lead_id = p_sales_lead_id;
4156:
4157: cursor am_admin_access_csr is
4158: select 'x'
4159: from as_sales_leads lead, as_accesses_all a, as_rpt_admins_v rm
4160: where lead.customer_id = a.customer_id
4161: and a.salesforce_id = rm.salesforce_id
4162: and a.salesforce_role_code = 'AM'
4163: and rm.parent_sales_group_id = p_admin_group_id
4420: and rm.parent_sales_group_id = p_admin_group_id);
4421:
4422: cursor am_mgr_access_csr(p_resource_id number) is
4423: select 'x'
4424: from as_sales_leads lead, as_accesses_all a, as_rpt_managers_v rm
4425: where lead.customer_id = a.customer_id
4426: and a.salesforce_id = rm.resource_id
4427: and a.salesforce_role_code = 'AM'
4428: and rm.parent_resource_id = p_resource_id
4429: and lead.sales_lead_id = p_sales_lead_id;
4430:
4431: cursor am_admin_access_csr is
4432: select 'x'
4433: from as_sales_leads lead, as_accesses_all a, as_rpt_admins_v rm
4434: where lead.customer_id = a.customer_id
4435: and a.salesforce_id = rm.salesforce_id
4436: and a.salesforce_role_code = 'AM'
4437: and rm.parent_sales_group_id = p_admin_group_id