DBA Data[Home] [Help]

APPS.JTF_AUTH_TRIGGERTEST SQL Statements

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

Line: 59

     select count(*) into v_count1 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPAL_MAPS_T4' and OWNER = 'APPS';
Line: 60

     select count(*) into v_count2 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_DOMAIN_TI' and OWNER = 'APPS';
Line: 61

     select count(*) into v_count3 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_ROLE_PERM_TI' and OWNER = 'APPS';
Line: 62

     select count(*) into v_count4 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PERMISSIONS_B_T1' and OWNER = 'APPS';
Line: 63

     select count(*) into v_count5 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_DOMAINS_B_T1' and OWNER = 'APPS';
Line: 64

     select count(*) into v_count6 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPALS_B_T1' and OWNER = 'APPS';
Line: 65

     select count(*) into v_count7 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPAL_MAPS_T3' and OWNER = 'APPS';