eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_ACCESS_PVT dependencies on AS_ACCESSES_ALL

Line 198: from as_accesses_all a

194: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
195:
196: cursor resource_access_csr is
197: select 'X'
198: from as_accesses_all a
199: where a.sales_lead_id = p_sales_lead_id
200: and a.owner_flag = 'Y'
201: and a.salesforce_id = p_identity_salesforce_id;
202:

Line 206: from as_accesses_all a

202:
203: cursor manager_access_csr(p_resource_id number) is
204:
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

Line 218: from as_accesses_all a

214: or (rm.parent_resource_id <> rm.resource_id)));
215:
216: cursor mgr_i_access_csr(p_resource_id number) is
217: select 'X'
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

Line 228: from as_accesses_all a

224: and rm.parent_resource_id = p_resource_id));
225:
226: cursor admin_access_csr is
227: select 'x'
228: from as_accesses_all a
229: where a.sales_lead_id = p_sales_lead_id
230: and EXISTS (select 'x'
231: from as_rpt_admins_v rm
232: where a.salesforce_id = rm.salesforce_id

Line 240: from as_accesses_all a

236: or (rm.salesforce_id <> p_identity_salesforce_id)));
237:
238: cursor admin_i_access_csr is
239: select 'x'
240: from as_accesses_all a
241: where a.sales_lead_id = p_sales_lead_id
242: and a.owner_flag = 'Y'
243: and EXISTS (select 'x'
244: from as_rpt_admins_v rm

Line 250: from as_sales_leads lead, as_accesses_all a, as_rpt_managers_v rm

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

Line 259: from as_sales_leads lead, as_accesses_all a, as_rpt_admins_v rm

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

Line 503: from as_accesses_all a

499: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
500:
501: cursor resource_access_csr is
502: select 'X'
503: from as_accesses_all a
504: where a.lead_id = p_lead_id
505: and a.owner_flag = 'Y'
506: and a.salesforce_id = p_identity_salesforce_id;
507:

Line 510: from as_accesses_all a

506: and a.salesforce_id = p_identity_salesforce_id;
507:
508: cursor manager_access_csr(p_resource_id number) is
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

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 531: from as_accesses_all a

527: and lead.lead_id = p_lead_id;
528:
529: cursor mgr_i_access_csr(p_resource_id number) is
530: select 'X'
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

Line 541: from as_accesses_all a

537: and rm.parent_resource_id = p_resource_id));
538:
539: cursor admin_access_csr is
540: select 'x'
541: from as_accesses_all a
542: where a.lead_id = p_lead_id
543: and EXISTS (select 'x'
544: from as_rpt_admins_v rm
545: where a.salesforce_id = rm.salesforce_id

Line 553: from as_accesses_all a

549: or (rm.salesforce_id <> p_identity_salesforce_id)));
550:
551: cursor admin_i_access_csr is
552: select 'x'
553: from as_accesses_all a
554: where a.lead_id = p_lead_id
555: and a.owner_flag = 'Y'
556: and EXISTS (select 'x'
557: from as_rpt_admins_v rm

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 760: from as_accesses_all

756: function is_account_manager (p_salesforce_id in number, p_customer_id in number)
757: RETURN BOOLEAN IS
758: cursor account_mgr_csr is
759: select 'x'
760: from as_accesses_all
761: where salesforce_id = p_salesforce_id
762: and salesforce_role_code = 'AM'
763: and customer_id = p_customer_id
764: and lead_id is null

Line 784: from as_accesses_all

780: function is_sales_lead_owner_row (p_access_id in number)
781: RETURN BOOLEAN IS
782: cursor owner_csr is
783: select 'x'
784: from as_accesses_all
785: where access_id = p_access_id
786: and owner_flag = 'Y';
787:
788: l_tmp varchar2(1);

Line 806: from as_accesses_all

802: procedure unmark_opp_owner_flag(p_lead_id in number, p_access_id in number) is
803:
804: cursor owner_exist_csr is
805: select 'x'
806: from as_accesses_all
807: where lead_id = p_lead_id
808: and access_id <> p_access_id
809: and owner_flag = 'Y';
810:

Line 819: update as_accesses_all

815: close owner_exist_csr;
816:
817: if l_var is not null
818: then
819: update as_accesses_all
820: set object_version_number = nvl(object_version_number,0) + 1, owner_flag = 'N'
821: where lead_id = p_lead_id
822: and access_id <> p_access_id;
823: end if;

Line 831: from as_accesses_all

827: procedure unmark_owner_flag(p_sales_lead_id in number, p_access_id in number) is
828:
829: cursor owner_exist_csr is
830: select 'x'
831: from as_accesses_all
832: where sales_lead_id = p_sales_lead_id
833: and access_id <> p_access_id
834: and owner_flag = 'Y';
835:

Line 844: update as_accesses_all

840: close owner_exist_csr;
841:
842: if l_var is not null
843: then
844: update as_accesses_all
845: set object_version_number = nvl(object_version_number,0) + 1, owner_flag = 'N'
846: where sales_lead_id = p_sales_lead_id
847: and access_id <> p_access_id;
848: end if;

Line 2664: from as_accesses_all

2660: for update of access_id nowait;
2661:
2662: cursor get_owner_flag (p_access_id number) is
2663: select owner_flag
2664: from as_accesses_all
2665: where access_id = p_access_id;
2666:
2667: cursor get_salesforce_role_code (p_access_id number) is
2668: select salesforce_role_code

Line 2669: from as_accesses_all

2665: where access_id = p_access_id;
2666:
2667: cursor get_salesforce_role_code (p_access_id number) is
2668: select salesforce_role_code
2669: from as_accesses_all
2670: where access_id = p_access_id;
2671:
2672: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2673: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acspv.Update_SalesTeam';

Line 3145: owner_sales_group_id = (select sales_group_id from as_accesses_all where access_id = l_sales_team_rec.access_id)

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

Line 3278: from as_accesses_all a, hz_parties p,hz_relationships rel

3274:
3275: cursor resource_access_csr is
3276:
3277: select 'X'
3278: from as_accesses_all a, hz_parties p,hz_relationships rel
3279: where a.customer_id = rel.object_id
3280: and rel.object_id = p.party_id
3281: and p.party_type in ('ORGANIZATION','PERSON')
3282: and rel.subject_id = p_customer_id

Line 3292: from as_accesses_all a, as_rpt_managers_v rm,

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')

Line 3313: and exists (select 1 from as_accesses_all a ,as_rpt_admins_v rm

3309: and p.party_type in ('ORGANIZATION','PERSON')
3310: and rel.subject_id = p_customer_id
3311: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3312: and rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
3313: and exists (select 1 from as_accesses_all a ,as_rpt_admins_v rm
3314: where a.salesforce_id = rm.salesforce_id
3315: and a.customer_id = rel.object_id
3316: and rm.parent_sales_group_id = p_admin_group_id)
3317: and rownum = 1;

Line 3398: from as_accesses_all a, hz_parties p,hz_relationships rel

3394:
3395: cursor resource_access_csr is
3396:
3397: select 'X'
3398: from as_accesses_all a, hz_parties p,hz_relationships rel
3399: where a.customer_id = rel.object_id
3400: and rel.object_id = p.party_id
3401: and p.party_type in ('ORGANIZATION','PERSON')
3402: and rel.subject_id = p_customer_id

Line 3413: from as_accesses_all a,

3409: and rownum = 1;
3410:
3411: cursor manager_access_csr(p_resource_id number) is
3412: select 'X'
3413: from as_accesses_all a,
3414: hz_parties p, hz_relationships rel
3415: where a.customer_id = rel.object_id
3416: and rel.object_id = p.party_id
3417: and p.party_type in ('ORGANIZATION','PERSON')

Line 3433: from as_accesses_all a, hz_parties p, hz_relationships rel

3429: or (rm.parent_resource_id <> rm.resource_id))));
3430:
3431: cursor mgr_i_access_csr(p_resource_id number) is
3432: select 'X'
3433: from as_accesses_all a, hz_parties p, hz_relationships rel
3434: where a.customer_id = rel.object_id
3435: and rel.object_id = p.party_id
3436: and p.party_type in ('ORGANIZATION','PERSON')
3437: and rel.subject_id = p_customer_id

Line 3448: from as_accesses_all a, hz_parties p, hz_relationships rel

3444: and rm.parent_resource_id = p_resource_id));
3445:
3446: cursor admin_access_csr is
3447: select 'X'
3448: from as_accesses_all a, hz_parties p, hz_relationships rel
3449: where a.customer_id = rel.object_id
3450: and rel.object_id = p.party_id
3451: and p.party_type in ('ORGANIZATION','PERSON')
3452: and rel.subject_id = p_customer_id

Line 3467: from as_accesses_all a, hz_parties p, hz_relationships rel

3463: or (rm.salesforce_id <> p_identity_salesforce_id)));
3464:
3465: cursor admin_i_access_csr is
3466: select 'x'
3467: from as_accesses_all a, hz_parties p, hz_relationships rel
3468: where a.customer_id = rel.object_id
3469: and rel.object_id = p.party_id
3470: and p.party_type in ('ORGANIZATION', 'PERSON')
3471: and rel.subject_id = p_customer_id

Line 3587: from as_accesses_all

3583:
3584: cursor resource_access_csr is
3585:
3586: select 'X'
3587: from as_accesses_all
3588: where customer_id = p_customer_id
3589: and salesforce_id = p_identity_salesforce_id;
3590:
3591:

Line 3594: from as_accesses_all a

3590:
3591:
3592: cursor manager_access_csr(p_resource_id number) 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

Line 3603: from as_accesses_all a

3599: and rm.parent_resource_id = p_resource_id));
3600:
3601: cursor admin_access_csr is
3602: select 'X'
3603: from as_accesses_all a
3604: where customer_id = p_customer_id
3605: and EXISTS (select 'x'
3606: from as_rpt_admins_v rm
3607: where a.salesforce_id = rm.salesforce_id

Line 3809: from as_accesses_all

3805:
3806: cursor resource_access_csr is
3807:
3808: select 'X'
3809: from as_accesses_all
3810: where customer_id = p_customer_id
3811: and lead_id is null
3812: and sales_lead_id is null
3813: and team_leader_flag = 'Y'

Line 3819: from as_accesses_all a

3815:
3816:
3817: cursor manager_access_csr(p_resource_id number) is
3818: select 'X'
3819: from as_accesses_all a
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'

Line 3833: from as_accesses_all a

3829: or (rm.parent_resource_id <> rm.resource_id))));
3830:
3831: cursor mgr_i_access_csr(p_resource_id number) is
3832: select 'X'
3833: from as_accesses_all a
3834: where a.customer_id = p_customer_id
3835: and lead_id is null
3836: and sales_lead_id is null
3837: and a.team_leader_flag = 'Y'

Line 3845: from as_accesses_all a

3841: and rm.parent_resource_id = p_resource_id));
3842:
3843: cursor admin_access_csr is
3844: select 'X'
3845: from as_accesses_all a
3846: where customer_id = p_customer_id
3847: and lead_id is null
3848: and sales_lead_id is null
3849: and EXISTS (select 'x'

Line 3859: from as_accesses_all a

3855: or (rm.salesforce_id <> p_identity_salesforce_id)));
3856:
3857: cursor admin_i_access_csr is
3858: select 'x'
3859: from as_accesses_all a
3860: where a.customer_id = p_customer_id
3861: and lead_id is null
3862: and sales_lead_id is null
3863: and a.team_leader_flag = 'Y'

Line 4098: from as_accesses_all a

4094: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
4095:
4096: cursor resource_access_csr is
4097: select 'X'
4098: from as_accesses_all a
4099: where a.sales_lead_id = p_sales_lead_id
4100: and (a.team_leader_flag = 'Y' or a.owner_flag = 'Y')
4101: and a.salesforce_id = p_identity_salesforce_id;
4102:

Line 4106: from as_accesses_all a

4102:
4103: cursor manager_access_csr(p_resource_id number) is
4104:
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

Line 4118: from as_accesses_all a

4114: or (rm.parent_resource_id <> rm.resource_id)));
4115:
4116: cursor mgr_i_access_csr(p_resource_id number) is
4117: select 'X'
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

Line 4128: from as_accesses_all a

4124: and rm.parent_resource_id = p_resource_id));
4125:
4126: cursor admin_access_csr is
4127: select 'x'
4128: from as_accesses_all a
4129: where a.sales_lead_id = p_sales_lead_id
4130: and EXISTS (select 'x'
4131: from as_rpt_admins_v rm
4132: where a.salesforce_id = rm.salesforce_id

Line 4140: from as_accesses_all a

4136: or (rm.salesforce_id <> p_identity_salesforce_id)));
4137:
4138: cursor admin_i_access_csr is
4139: select 'x'
4140: from as_accesses_all a
4141: where a.sales_lead_id = p_sales_lead_id
4142: and (a.team_leader_flag = 'Y' or a.owner_flag = 'Y')
4143: and EXISTS (select 'x'
4144: from as_rpt_admins_v rm

Line 4150: from as_sales_leads lead, as_accesses_all a, as_rpt_managers_v rm

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

Line 4159: from as_sales_leads lead, as_accesses_all a, as_rpt_admins_v rm

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

Line 4398: from as_accesses_all a

4394: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
4395:
4396: cursor resource_access_csr is
4397: select 'X'
4398: from as_accesses_all a
4399: where a.sales_lead_id = p_sales_lead_id
4400: and a.salesforce_id = p_identity_salesforce_id;
4401:
4402: cursor manager_access_csr(p_resource_id number) is

Line 4405: from as_accesses_all a

4401:
4402: cursor manager_access_csr(p_resource_id number) is
4403:
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

Line 4415: from as_accesses_all a

4411:
4412:
4413: cursor admin_access_csr is
4414: select 'x'
4415: from as_accesses_all a
4416: where a.sales_lead_id = p_sales_lead_id
4417: and EXISTS (select 'x'
4418: from as_rpt_admins_v rm
4419: where a.salesforce_id = rm.salesforce_id

Line 4424: from as_sales_leads lead, as_accesses_all a, as_rpt_managers_v rm

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

Line 4433: from as_sales_leads lead, as_accesses_all a, as_rpt_admins_v rm

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

Line 4636: from as_accesses_all a

4632: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
4633:
4634: cursor resource_access_csr is
4635: select 'X'
4636: from as_accesses_all a
4637: where a.lead_id = p_opportunity_id
4638: and a.team_leader_flag = 'Y'
4639: and a.salesforce_id = p_identity_salesforce_id;
4640:

Line 4644: from as_accesses_all a

4640:
4641: cursor manager_access_csr(p_resource_id number) is
4642:
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

Line 4657: from as_accesses_all a

4653: or (rm.parent_resource_id <> rm.resource_id))));
4654:
4655: cursor mgr_i_access_csr(p_resource_id number) is
4656: select 'X'
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

Line 4669: from as_accesses_all a

4665: ));
4666:
4667: cursor admin_access_csr is
4668: select 'x'
4669: from as_accesses_all a
4670: where a.lead_id = p_opportunity_id
4671: and EXISTS (select 'x'
4672: from as_rpt_admins_v rm
4673: where a.salesforce_id = rm.salesforce_id

Line 4681: from as_accesses_all a

4677: or (rm.salesforce_id <> p_identity_salesforce_id)));
4678:
4679: cursor admin_i_access_csr is
4680: select 'x'
4681: from as_accesses_all a
4682: where a.lead_id = p_opportunity_id
4683: and a.team_leader_flag = 'Y'
4684: and EXISTS (select 'x'
4685: from as_rpt_admins_v rm

Line 4691: from as_leads opp, as_accesses_all a, as_rpt_managers_v rm

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

Line 4701: from as_leads opp, as_accesses_all a, as_rpt_admins_v rm

4697: and sysdate between rm.start_date_active and nvl(rm.end_date_active, sysdate);
4698:
4699: cursor am_admin_access_csr is
4700: select 'x'
4701: from as_leads opp, as_accesses_all a, as_rpt_admins_v rm
4702: where opp.customer_id = a.customer_id
4703: and a.salesforce_id = rm.salesforce_id
4704: and a.salesforce_role_code = 'AM'
4705: and rm.parent_sales_group_id = p_admin_group_id

Line 4986: from as_accesses_all a

4982: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
4983:
4984: cursor resource_access_csr is
4985: select 'X'
4986: from as_accesses_all a
4987: where a.lead_id = p_opportunity_id
4988: and a.salesforce_id = p_identity_salesforce_id;
4989:
4990: cursor manager_access_csr(p_resource_id number) is

Line 4993: from as_accesses_all a

4989:
4990: cursor manager_access_csr(p_resource_id number) is
4991:
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

Line 5004: from as_accesses_all a

5000: );
5001:
5002: cursor admin_access_csr is
5003: select 'x'
5004: from as_accesses_all a
5005: where a.lead_id = p_opportunity_id
5006: and EXISTS (select 'x'
5007: from as_rpt_admins_v rm
5008: where a.salesforce_id = rm.salesforce_id

Line 5014: from as_leads opp, as_accesses_all a, as_rpt_managers_v rm

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

Line 5024: from as_leads opp, as_accesses_all a, as_rpt_admins_v rm

5020: and sysdate between rm.start_date_active and nvl(rm.end_date_active, sysdate);
5021:
5022: cursor am_admin_access_csr is
5023: select 'x'
5024: from as_leads opp, as_accesses_all a, as_rpt_admins_v rm
5025: where opp.customer_id = a.customer_id
5026: and a.salesforce_id = rm.salesforce_id
5027: and a.salesforce_role_code = 'AM'
5028: and rm.parent_sales_group_id = p_admin_group_id