APPS.AS_ACCESS_PVT dependencies on HZ_RELATIONSHIPS

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

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

Line 3292: hz_parties p,hz_relationships rel

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')
3296: and a.salesforce_id = rm.resource_id

Line 3306: from hz_parties p, hz_relationships rel

3302:
3303: cursor admin_access_csr is
3304:
3305: select 'X'
3306: from hz_parties p, hz_relationships rel
3307: where rel.object_id = p.party_id
3308: and p.party_type in ('ORGANIZATION','PERSON')
3309: and rel.subject_id = p_customer_id
3310: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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

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

Line 3413: hz_parties p, hz_relationships rel

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

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

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

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

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

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

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