APPS.PER_RI_CONFIG_RESPON_PKG SQL Statements

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

Line: 12

	    SELECT lookup_code
	        FROM  hr_lookups
	        WHERE lookup_type  = 'PER_RI_CONFIG_PRODUCTS'
		AND   lookup_code in (select responsibility_application
				      from per_Ri_config_responsibility
				      where responsibility_application like p_responsibility_application
				      and territory_code like p_territory_code
				      and responsibility_key like p_responsibility_key);

Line: 28

		INSERT INTO PER_RI_CONFIG_RESPONSIBILITY (responsibility_application,territory_code,responsibility_key)
		VALUES  (p_responsibility_application,p_territory_code,p_responsibility_key);

Line: 46

	     SELECT responsibility_application
	     FROM   per_ri_config_responsibility
             WHERE  responsibility_application = p_responsibility_application
             AND    territory_code             = p_territory_code
             AND    responsibility_key         = p_responsibility_key;

Line: 66

	-- As all are key columns, there will ideally be no need for an update
	/*update_config_responsibility(p_responsibility_application => p_responsibility_application
	                            ,p_territory_code             => p_territory_code
	                            ,p_responsibility_key         => p_responsibility_key
	                            );