APPS.PQH_EMPLOYMENT_CATEGORY SQL Statements

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

Line: 30

select  formula_id
from	ff_formulas_f
where	formula_name  = 'PQH_EMPLOYMENT_CATEGORY'
and     business_group_id = p_business_group_id
and 	l_effective_date  between effective_start_date and effective_end_date;

Line: 60

  insert into fnd_sessions (
	session_id, effective_date)
	values (userenv('sessionid'), l_effective_date);

Line: 154

   SELECT information1
   FROM   per_shared_types
   WHERE  lookup_type = 'QUALIFYING_UNITS'
   AND    business_group_id = p_business_group_id
   AND    system_type_cd = p_duration_units
 UNION ALL
   SELECT information1
   FROM   per_shared_types
   WHERE  lookup_type = 'QUALIFYING_UNITS'
   AND    business_group_id IS NULL
   AND    system_type_cd = p_duration_units;

Line: 195

SELECT  date_start
FROM    per_periods_of_service
WHERE   period_of_service_id = p_period_of_service_id;