DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_TECH_SUMMARY dependencies on STANDARD

Line 701: ||' decode(A.security_group,''STANDARD'',''Standard'',A.security_group) SecurityGroupName, '

697: l_resp_clob := get_clob_locator('RESPONSIBILITIES');
698: dbms_lob.createtemporary(l_resp_clob,TRUE);
699:
700: l_prejoin_sql := ' select distinct A.user_name , A.resp_key ResponsibilityName ,'
701: ||' decode(A.security_group,''STANDARD'',''Standard'',A.security_group) SecurityGroupName, '
702: ||' app.APPLICATION_NAME ApplicationName, A.start_date from ( ';
703:
704: dbms_lob.writeappend(l_resp_clob,length(l_prejoin_sql),l_prejoin_sql);
705: