DBA Data[Home] [Help]

APPS.JTF_UM_WF_APPROVAL dependencies on JTF_AUTH_PERMISSIONS_B

Line 957: from jtf_auth_domains_b domains_b, jtf_auth_permissions_b perm,

953: and nvl (fnd.end_date, sysdate + 1) > sysdate
954:
955: and exists (
956: select prin_b.principal_name
957: from jtf_auth_domains_b domains_b, jtf_auth_permissions_b perm,
958: jtf_auth_principal_maps prin_maps, jtf_auth_role_perms role_perms,
959: jtf_auth_principals_b prin_b, jtf_auth_principals_b prin_b2
960: where prin_b.jtf_auth_principal_id = prin_maps.jtf_auth_principal_id
961: and prin_maps.jtf_auth_parent_principal_id = prin_b2.jtf_auth_principal_id