[Home] [Help]
205: select 'X'
206: from as_accesses_all a
207: where a.sales_lead_id = p_sales_lead_id
208: and EXISTS (select 'x'
209: from as_rpt_managers_v rm
210: where a.salesforce_id = rm.resource_id
211: and rm.parent_resource_id = p_resource_id
212: and (rm.parent_resource_id = rm.resource_id
213: and a.owner_flag ='Y'
218: from as_accesses_all a
219: where a.sales_lead_id = p_sales_lead_id
220: and a.owner_flag = 'Y'
221: and (EXISTS (select 'x'
222: from as_rpt_managers_v rm
223: where a.salesforce_id = rm.resource_id
224: and rm.parent_resource_id = p_resource_id));
225:
226: cursor admin_access_csr is
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
509: select 'X'
510: from as_accesses_all a
511: where a.lead_id = p_lead_id
512: and EXISTS (select 'x'
513: from as_rpt_managers_v rm
514: where a.salesforce_id = rm.resource_id
515: and rm.parent_resource_id = p_resource_id
516: and (rm.parent_resource_id = rm.resource_id
517: and a.owner_flag ='Y'
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
531: from as_accesses_all a
532: where a.lead_id = p_lead_id
533: and a.owner_flag = 'Y'
534: and (EXISTS (select 'x'
535: from as_rpt_managers_v rm
536: where a.salesforce_id = rm.resource_id
537: and rm.parent_resource_id = p_resource_id));
538:
539: cursor admin_access_csr is
3287:
3288: cursor manager_access_csr(p_resource_id number) is
3289:
3290: select 'X'
3291: from as_accesses_all a, as_rpt_managers_v rm,
3292: hz_parties p,hz_relationships rel
3293: where a.customer_id = rel.object_id
3294: and rel.object_id = p.party_id
3295: and p.party_type in ('ORGANIZATION','PERSON')
3419: and a.sales_lead_id is null
3420: and rel.subject_table_name = 'HZ_PARTIES'
3421: and rel.object_table_name = 'HZ_PARTIES'
3422: and (EXISTS (select 'X'
3423: from as_rpt_managers_v rm
3424: where a.salesforce_id = rm.resource_id
3425: and rm.parent_resource_id = p_resource_id
3426: and ((rm.parent_resource_id = rm.resource_id
3427: and a.team_leader_flag = 'Y')
3437: and a.lead_id is null
3438: and a.sales_lead_id is null
3439: and a.team_leader_flag = 'Y'
3440: and (EXISTS (select 'x'
3441: from as_rpt_managers_v rm
3442: where a.salesforce_id = rm.resource_id
3443: and rm.parent_resource_id = p_resource_id));
3444:
3445: cursor admin_access_csr is
3592: select 'X'
3593: from as_accesses_all a
3594: where customer_id = p_customer_id
3595: and (EXISTS (select 'X'
3596: from as_rpt_managers_v rm
3597: where a.salesforce_id = rm.resource_id
3598: and rm.parent_resource_id = p_resource_id));
3599:
3600: cursor admin_access_csr is
3819: where customer_id = p_customer_id
3820: and lead_id is null
3821: and sales_lead_id is null
3822: and (EXISTS (select 'X'
3823: from as_rpt_managers_v rm
3824: where a.salesforce_id = rm.resource_id
3825: and rm.parent_resource_id = p_resource_id
3826: and ((rm.parent_resource_id = rm.resource_id
3827: and a.team_leader_flag = 'Y')
3834: and lead_id is null
3835: and sales_lead_id is null
3836: and a.team_leader_flag = 'Y'
3837: and (EXISTS (select 'x'
3838: from as_rpt_managers_v rm
3839: where a.salesforce_id = rm.resource_id
3840: and rm.parent_resource_id = p_resource_id));
3841:
3842: cursor admin_access_csr is
4104: select 'X'
4105: from as_accesses_all a
4106: where a.sales_lead_id = p_sales_lead_id
4107: and EXISTS (select 'x'
4108: from as_rpt_managers_v rm
4109: where a.salesforce_id = rm.resource_id
4110: and rm.parent_resource_id = p_resource_id
4111: and (rm.parent_resource_id = rm.resource_id
4112: and (a.team_leader_flag = 'Y' or a.owner_flag = 'Y')
4117: from as_accesses_all a
4118: where a.sales_lead_id = p_sales_lead_id
4119: and (a.team_leader_flag = 'Y' or a.owner_flag = 'Y')
4120: and (EXISTS (select 'x'
4121: from as_rpt_managers_v rm
4122: where a.salesforce_id = rm.resource_id
4123: and rm.parent_resource_id = p_resource_id));
4124:
4125: cursor admin_access_csr is
4145: and rm.parent_sales_group_id = p_admin_group_id);
4146:
4147: cursor am_mgr_access_csr(p_resource_id number) is
4148: select 'x'
4149: from as_sales_leads lead, as_accesses_all a, as_rpt_managers_v rm
4150: where lead.customer_id = a.customer_id
4151: and a.salesforce_id = rm.resource_id
4152: and a.salesforce_role_code = 'AM'
4153: and rm.parent_resource_id = p_resource_id
4403: select 'X'
4404: from as_accesses_all a
4405: where a.sales_lead_id = p_sales_lead_id
4406: and EXISTS (select 'x'
4407: from as_rpt_managers_v rm
4408: where a.salesforce_id = rm.resource_id
4409: and rm.parent_resource_id = p_resource_id);
4410:
4411:
4419: and rm.parent_sales_group_id = p_admin_group_id);
4420:
4421: cursor am_mgr_access_csr(p_resource_id number) is
4422: select 'x'
4423: from as_sales_leads lead, as_accesses_all a, as_rpt_managers_v rm
4424: where lead.customer_id = a.customer_id
4425: and a.salesforce_id = rm.resource_id
4426: and a.salesforce_role_code = 'AM'
4427: and rm.parent_resource_id = p_resource_id
4642: select 'X'
4643: from as_accesses_all a
4644: where a.lead_id = p_opportunity_id
4645: and (EXISTS (select 'x'
4646: from as_rpt_managers_v rm
4647: where a.salesforce_id = rm.resource_id
4648: and rm.parent_resource_id = p_resource_id
4649: and sysdate between rm.start_date_active and nvl(rm.end_date_active, sysdate)
4650: and ((rm.parent_resource_id = rm.resource_id
4656: from as_accesses_all a
4657: where a.lead_id = p_opportunity_id
4658: and a.team_leader_flag = 'Y'
4659: and (EXISTS (select 'x'
4660: from as_rpt_managers_v rm
4661: where a.salesforce_id = rm.resource_id
4662: and rm.parent_resource_id = p_resource_id
4663: and sysdate between rm.start_date_active and nvl(rm.end_date_active, sysdate)
4664: ));
4686: and rm.parent_sales_group_id = p_admin_group_id);
4687:
4688: cursor am_mgr_access_csr(p_resource_id number) is
4689: select 'x'
4690: from as_leads opp, as_accesses_all a, as_rpt_managers_v rm
4691: where opp.customer_id = a.customer_id
4692: and a.salesforce_id = rm.resource_id
4693: and a.salesforce_role_code = 'AM'
4694: and rm.parent_resource_id = p_resource_id
4991: select 'X'
4992: from as_accesses_all a
4993: where a.lead_id = p_opportunity_id
4994: and EXISTS (select 'x'
4995: from as_rpt_managers_v rm
4996: where a.salesforce_id = rm.resource_id
4997: and rm.parent_resource_id = p_resource_id
4998: and sysdate between rm.start_date_active and nvl(rm.end_date_active, sysdate)
4999: );
5009:
5010:
5011: cursor am_mgr_access_csr(p_resource_id number) is
5012: select 'x'
5013: from as_leads opp, as_accesses_all a, as_rpt_managers_v rm
5014: where opp.customer_id = a.customer_id
5015: and a.salesforce_id = rm.resource_id
5016: and a.salesforce_role_code = 'AM'
5017: and rm.parent_resource_id = p_resource_id