DBA Data[Home] [Help]

APPS.JTF_TTY_WEBADI_SALSTEAM_UPDATE dependencies on FND_PROFILE

Line 480: OR rol.role_code = FND_PROFILE.VALUE('JTF_TTY_NA_PROXY_USER_ROLE')

476: AND rlt.role_relate_id = sgh.par_role_relate_id
477: AND dv.parent_group_id = sgh.group_id
478: AND sgh.resource_id = sgh.parent_resource_id
479: AND ( sgh.hierarchy_type IN ('MGR_TO_MGR')
480: OR rol.role_code = FND_PROFILE.VALUE('JTF_TTY_NA_PROXY_USER_ROLE')
481: )
482: AND mrsc.resource_id = sgh.resource_id ) MY_GRPS
483: WHERE ( rol.member_flag = 'Y' OR rol.manager_flag = 'Y' )
484: AND rlt.role_id = rol.role_id

Line 870: OR rol.role_code = FND_PROFILE.VALUE('JTF_TTY_NA_PROXY_USER_ROLE'))

866: AND rlt.role_relate_id = sgh.par_role_relate_id
867: AND dv.parent_group_id = sgh.group_id
868: AND sgh.resource_id = sgh.parent_resource_id
869: AND (sgh.hierarchy_type IN ('MGR_TO_MGR')
870: OR rol.role_code = FND_PROFILE.VALUE('JTF_TTY_NA_PROXY_USER_ROLE'))
871: AND mrsc.resource_id = sgh.resource_id
872: AND mrsc.user_id = l_user_id
873: ) MY_GRPS
874: WHERE grpmemo.resource_id = dir.resource_id