APPS.AS_ACCESS_PVT dependencies on HZ_RELATIONSHIPS

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 3293: hz_parties p,hz_relationships rel

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

Line 3307: from hz_parties p, hz_relationships rel

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

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 3414: hz_parties p, hz_relationships rel

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')
3418: and rel.subject_id = p_customer_id

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