6: p_resources OUT NOCOPY resource_access_tbl_type) is
7:
8: cursor get_resources_for_party (p_cust_id NUMBER) is
9: select distinct salesforce_id
10: from as_accesses_all
11: where lead_id is null
12: and sales_lead_id is null
13: and team_leader_flag = 'Y'
14: and customer_id = p_cust_id;
24: where party_id = p_rel_party_id;
25:
26: cursor get_resources_for_rel (p_subject_id NUMBER, p_object_id NUMBER) is
27: select distinct salesforce_id
28: from as_accesses_all
29: where lead_id is null
30: and sales_lead_id is null
31: and team_leader_flag = 'Y'
32: and customer_id in (p_subject_id, p_object_id);