DBA Data[Home] [Help]

APPS.JTF_UM_WF_APPROVAL dependencies on JTF_AUTH_PERMISSIONS_B

Line 950: from jtf_auth_domains_b domains_b, jtf_auth_permissions_b perm,

946: and nvl (fnd.end_date, sysdate + 1) > sysdate
947:
948: and exists (
949: select prin_b.principal_name
950: from jtf_auth_domains_b domains_b, jtf_auth_permissions_b perm,
951: jtf_auth_principal_maps prin_maps, jtf_auth_role_perms role_perms,
952: jtf_auth_principals_b prin_b, jtf_auth_principals_b prin_b2
953: where prin_b.jtf_auth_principal_id = prin_maps.jtf_auth_principal_id
954: and prin_maps.jtf_auth_parent_principal_id = prin_b2.jtf_auth_principal_id