[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
3288:
3289: cursor manager_access_csr(p_resource_id number) is
3290:
3291: select 'X'
3292: from as_accesses_all a, as_rpt_managers_v rm,
3293: hz_parties p,hz_relationships rel
3294: where a.customer_id = rel.object_id
3295: and rel.object_id = p.party_id
3296: and p.party_type in ('ORGANIZATION','PERSON')
3420: and a.sales_lead_id is null
3421: and rel.subject_table_name = 'HZ_PARTIES'
3422: and rel.object_table_name = 'HZ_PARTIES'
3423: and (EXISTS (select 'X'
3424: from as_rpt_managers_v rm
3425: where a.salesforce_id = rm.resource_id
3426: and rm.parent_resource_id = p_resource_id
3427: and ((rm.parent_resource_id = rm.resource_id
3428: and a.team_leader_flag = 'Y')
3438: and a.lead_id is null
3439: and a.sales_lead_id is null
3440: and a.team_leader_flag = 'Y'
3441: and (EXISTS (select 'x'
3442: from as_rpt_managers_v rm
3443: where a.salesforce_id = rm.resource_id
3444: and rm.parent_resource_id = p_resource_id));
3445:
3446: cursor admin_access_csr is
3593: select 'X'
3594: from as_accesses_all a
3595: where customer_id = p_customer_id
3596: and (EXISTS (select 'X'
3597: from as_rpt_managers_v rm
3598: where a.salesforce_id = rm.resource_id
3599: and rm.parent_resource_id = p_resource_id));
3600:
3601: cursor admin_access_csr is
3820: where customer_id = p_customer_id
3821: and lead_id is null
3822: and sales_lead_id is null
3823: and (EXISTS (select 'X'
3824: from as_rpt_managers_v rm
3825: where a.salesforce_id = rm.resource_id
3826: and rm.parent_resource_id = p_resource_id
3827: and ((rm.parent_resource_id = rm.resource_id
3828: and a.team_leader_flag = 'Y')
3835: and lead_id is null
3836: and sales_lead_id is null
3837: and a.team_leader_flag = 'Y'
3838: and (EXISTS (select 'x'
3839: from as_rpt_managers_v rm
3840: where a.salesforce_id = rm.resource_id
3841: and rm.parent_resource_id = p_resource_id));
3842:
3843: cursor admin_access_csr is
4105: select 'X'
4106: from as_accesses_all a
4107: where a.sales_lead_id = p_sales_lead_id
4108: and EXISTS (select 'x'
4109: from as_rpt_managers_v rm
4110: where a.salesforce_id = rm.resource_id
4111: and rm.parent_resource_id = p_resource_id
4112: and (rm.parent_resource_id = rm.resource_id
4113: and (a.team_leader_flag = 'Y' or a.owner_flag = 'Y')
4118: from as_accesses_all a
4119: where a.sales_lead_id = p_sales_lead_id
4120: and (a.team_leader_flag = 'Y' or a.owner_flag = 'Y')
4121: and (EXISTS (select 'x'
4122: from as_rpt_managers_v rm
4123: where a.salesforce_id = rm.resource_id
4124: and rm.parent_resource_id = p_resource_id));
4125:
4126: cursor admin_access_csr is
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
4404: select 'X'
4405: from as_accesses_all a
4406: where a.sales_lead_id = p_sales_lead_id
4407: and EXISTS (select 'x'
4408: from as_rpt_managers_v rm
4409: where a.salesforce_id = rm.resource_id
4410: and rm.parent_resource_id = p_resource_id);
4411:
4412:
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
4643: select 'X'
4644: from as_accesses_all a
4645: where a.lead_id = p_opportunity_id
4646: and (EXISTS (select 'x'
4647: from as_rpt_managers_v rm
4648: where a.salesforce_id = rm.resource_id
4649: and rm.parent_resource_id = p_resource_id
4650: and sysdate between rm.start_date_active and nvl(rm.end_date_active, sysdate)
4651: and ((rm.parent_resource_id = rm.resource_id
4657: from as_accesses_all a
4658: where a.lead_id = p_opportunity_id
4659: and a.team_leader_flag = 'Y'
4660: and (EXISTS (select 'x'
4661: from as_rpt_managers_v rm
4662: where a.salesforce_id = rm.resource_id
4663: and rm.parent_resource_id = p_resource_id
4664: and sysdate between rm.start_date_active and nvl(rm.end_date_active, sysdate)
4665: ));
4687: and rm.parent_sales_group_id = p_admin_group_id);
4688:
4689: cursor am_mgr_access_csr(p_resource_id number) is
4690: select 'x'
4691: from as_leads opp, as_accesses_all a, as_rpt_managers_v rm
4692: where opp.customer_id = a.customer_id
4693: and a.salesforce_id = rm.resource_id
4694: and a.salesforce_role_code = 'AM'
4695: and rm.parent_resource_id = p_resource_id
4992: select 'X'
4993: from as_accesses_all a
4994: where a.lead_id = p_opportunity_id
4995: and EXISTS (select 'x'
4996: from as_rpt_managers_v rm
4997: where a.salesforce_id = rm.resource_id
4998: and rm.parent_resource_id = p_resource_id
4999: and sysdate between rm.start_date_active and nvl(rm.end_date_active, sysdate)
5000: );
5010:
5011:
5012: cursor am_mgr_access_csr(p_resource_id number) is
5013: select 'x'
5014: from as_leads opp, as_accesses_all a, as_rpt_managers_v rm
5015: where opp.customer_id = a.customer_id
5016: and a.salesforce_id = rm.resource_id
5017: and a.salesforce_role_code = 'AM'
5018: and rm.parent_resource_id = p_resource_id