APPS.PV_EXT_TEAM_COMMON_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 35

  SELECT 'Y'
  FROM   jtf_auth_principal_maps jtfpm,
         jtf_auth_principals_b jtfp1,
         jtf_auth_domains_b jtfd,
         jtf_auth_principals_b jtfp2,
         jtf_auth_role_perms jtfrp,
         jtf_auth_permissions_b jtfperm
  WHERE  jtfp1.principal_name = cv_user_name
  AND    jtfp1.is_user_flag=1
  AND    jtfp1.jtf_auth_principal_id = jtfpm.jtf_auth_principal_id
  AND    jtfpm.jtf_auth_parent_principal_id = jtfp2.jtf_auth_principal_id
  AND    jtfp2.is_user_flag=0
  AND    jtfp2.jtf_auth_principal_id = jtfrp.jtf_auth_principal_id
  AND    jtfrp.positive_flag = 1
  AND    jtfrp.jtf_auth_permission_id = jtfperm.jtf_auth_permission_id
  AND    jtfperm.permission_name = 'PV_OPPTY_CONTACT'
  AND    jtfd.jtf_auth_domain_id=jtfpm.jtf_auth_domain_id
  AND    jtfd.domain_name='CRM_DOMAIN';