APPS.PAY_GB_ENROLL_PEN_REPORTING SQL Statements

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

Line: 7

SELECT  pay_element_entries_f.element_entry_id element_entry_id, per_all_assignments_f.assignment_id assignment_id
    FROM    pay_element_entries_f, pay_element_types_f , per_all_assignments_f,PER_ASSIGNMENT_STATUS_TYPES PAST
    WHERE   pay_element_entries_f.element_type_id = pay_element_types_f.element_type_id
    AND per_all_assignments_f.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID
    AND PAST.PER_SYSTEM_STATUS         ='ACTIVE_ASSIGN'
		and 		pay_element_entries_f.assignment_id = per_all_assignments_f.assignment_id
		and 		pay_element_types_f.ELEMENT_NAME like 'Pensions Information'
		and			per_all_assignments_f.payroll_id = p_payroll_id
		and 		p_end_date between pay_element_entries_f.effective_start_date and pay_element_entries_f.effective_end_date
		and 		p_end_date between pay_element_types_f.effective_start_date and pay_element_types_f.effective_end_date
		and 		p_end_date between per_all_assignments_f.effective_start_date and per_all_assignments_f.effective_end_date;

Line: 20

select
		MAX(DECODE ( name , 'Qualifying Scheme Name', INPUT_VALUE_ID )) qualifying_scheme_name,
		MAX(DECODE ( name , 'Auto Enrollment Date', INPUT_VALUE_ID )) auto_enrollment_date,
		MAX(DECODE ( name , 'Pension Classification', INPUT_VALUE_ID )) pension_classification,
		MAX(DECODE ( name , 'Opt Out Period End Date', INPUT_VALUE_ID )) opt_out_period_end_date,
		MAX(DECODE ( name , 'Total Earning PRP', INPUT_VALUE_ID )) total_earning_PRP,
    MAX(DECODE ( name , 'Postponement Type', INPUT_VALUE_ID )) postponement_type,
    MAX(DECODE ( name , 'Postponement End Date', INPUT_VALUE_ID )) postponement_end_date,
    MAX(DECODE ( name , 'Qualifying scheme exists', INPUT_VALUE_ID )) qualifying_scheme_exists,
    MAX(DECODE ( name , 'Opt in Date', INPUT_VALUE_ID )) opt_in_Date,
    MAX(DECODE ( name , 'Eligible Job Holder Date', INPUT_VALUE_ID )) first_found_elig_date,
    MAX(DECODE ( name , 'Postponement End Date', INPUT_VALUE_ID )) post_period_end_date
FROM
 (SELECT  input_value_id, name from pay_input_values_f);

Line: 37

select
		MAX(DECODE ( input_value_id , p_input_id.qualifying_scheme_name, SCREEN_ENTRY_VALUE )) qualifying_scheme_name,
		MAX(DECODE ( input_value_id , p_input_id.auto_enrollment_date, SCREEN_ENTRY_VALUE )) auto_enrollment_date,
		MAX(DECODE ( input_value_id , p_input_id.pension_classification, SCREEN_ENTRY_VALUE )) pension_classification,
		MAX(DECODE ( input_value_id , p_input_id.opt_out_period_end_date, SCREEN_ENTRY_VALUE )) opt_out_period_end_date,
		MAX(DECODE ( input_value_id , p_input_id.total_earning_PRP, SCREEN_ENTRY_VALUE )) total_earning_PRP,
    MAX(DECODE ( input_value_id , p_input_id.postponement_type, SCREEN_ENTRY_VALUE )) postponement_type,
    MAX(DECODE ( input_value_id , p_input_id.postponement_end_date, SCREEN_ENTRY_VALUE )) postponement_end_date,
    MAX(DECODE ( input_value_id , p_input_id.qualifying_scheme_exists, SCREEN_ENTRY_VALUE )) qualifying_scheme_exists,
    MAX(DECODE ( input_value_id , p_input_id.first_found_elig_date, SCREEN_ENTRY_VALUE )) first_found_elig_date,
		MAX(DECODE ( input_value_id , p_input_id.opt_in_Date, SCREEN_ENTRY_VALUE ))opt_in_date,
    MAX(DECODE ( input_value_id , p_input_id.post_period_end_date, SCREEN_ENTRY_VALUE ))post_period_end_date

FROM
 (SELECT  input_value_id,SCREEN_ENTRY_VALUE from pay_element_entry_values_f
where element_entry_id = p_elem_entry_id
and p_end_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
 );

Line: 57

SELECT   assignment_number,person_id
      FROM    per_all_assignments_f
      WHERE   assignment_id = p_assignment_id
      AND      p_end_date  between effective_start_date and effective_end_date;

Line: 63

select start_date,end_date,period_name
from per_time_periods
where TIME_PERIOD_ID=p_period and payroll_id =p_payroll_id;

Line: 68

select payroll_name from pay_all_payrolls_f where payroll_id = p_payroll
AND   p_end_date between effective_start_date and effective_end_date;

Line: 155

      SELECT
              (full_name)
            , extract (year FROM sysdate)  - extract (year FROM date_of_birth)
      INTO    l_full_name
            , l_age
      FROM    per_all_people_f
      WHERE   person_id = l_person_assign_num.person_id
    	AND        l_period.end_date between effective_start_date and effective_end_date;

Line: 219

      SELECT
              (full_name)
            , extract (year FROM sysdate)  - extract (year FROM date_of_birth)
      INTO    l_full_name
            , l_age
      FROM    per_all_people_f
      WHERE   person_id = l_person_assign_num.person_id
    AND        l_period.end_date between effective_start_date and effective_end_date;

Line: 280

      SELECT
              (full_name)
            , extract (year FROM sysdate)  - extract (year FROM date_of_birth)
      INTO    l_full_name
            , l_age
      FROM    per_all_people_f
      WHERE   person_id = l_person_assign_num.person_id
    	AND        l_period.end_date between effective_start_date and effective_end_date;

Line: 377

      SELECT
              (full_name)
            , extract (year FROM sysdate)  - extract (year FROM date_of_birth)
      INTO    l_full_name
            , l_age
      FROM    per_all_people_f
      WHERE   person_id = l_person_assign_num.person_id
   		AND     l_period.end_date between effective_start_date and effective_end_date;