DBA Data[Home] [Help]

APPS.PV_ASSIGN_UTIL_PVT dependencies on PV_PARTNER_ACCESSES

Line 1029: pv_partner_accesses PT_ACC,

1025: SELECT distinct -- user could have both CM roles
1026: pt_acc.resource_id rs_id,
1027: 'INTERNAL' origin
1028: FROM
1029: pv_partner_accesses PT_ACC,
1030: pv_partner_profiles PT_PROF,
1031: jtf_rs_resource_extns extn,
1032: per_all_people_f per,
1033: jtf_rs_role_relations rel,

Line 1137: (select distinct a.partner_id, 'Y' indirectly_managed_flag from pv_partner_accesses a, pv_partner_profiles b

1133: hz_relationships pr,
1134: hz_organization_profiles op,
1135: ar_lookups ar,
1136: hz_parties pt,
1137: (select distinct a.partner_id, 'Y' indirectly_managed_flag from pv_partner_accesses a, pv_partner_profiles b
1138: where a.partner_id = pc_party_rel_id
1139: and a.vad_partner_id = b.partner_id and b.status = 'A') imp
1140: where pf.partner_id = pc_party_rel_id
1141: and pf.partner_id = imp.partner_id (+)

Line 1161: pv_partner_accesses PT_ACC,

1157: SELECT distinct -- user could have both CM roles
1158: pt_acc.resource_id rs_id,
1159: 'EXTERNAL' origin
1160: FROM
1161: pv_partner_accesses PT_ACC,
1162: pv_partner_profiles PT_PROF,
1163: jtf_rs_resource_extns extn,
1164: hz_relationships emp,
1165: jtf_rs_role_relations rel,