APPS.PAY_PAP_SHD SQL Statements

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

Line: 74

    select
		accrual_plan_id,
	business_group_id,
	accrual_plan_element_type_id,
	pto_input_value_id,
	co_input_value_id,
	residual_input_value_id,
	accrual_category,
	accrual_plan_name,
	accrual_start,
	accrual_units_of_measure,
	ineligible_period_length,
	ineligible_period_type,
	accrual_formula_id,
	co_formula_id,
	co_date_input_value_id,
	co_exp_date_input_value_id,
	residual_date_input_value_id,
	description,
        ineligibility_formula_id,
        payroll_formula_id,
        defined_balance_id,
        tagging_element_type_id,
        balance_element_type_id,
	object_version_number,
        information_category,
        information1,
  	information2,
  	information3,
  	information4,
  	information5,
  	information6,
  	information7,
  	information8,
  	information9,
  	information10,
  	information11,
  	information12,
  	information13,
 	information14,
	information15,
	information16,
	information17,
  	information18,
  	information19,
  	information20,
  	information21,
  	information22,
        information23,
        information24,
        information25,
        information26,
        information27,
        information28,
        information29,
        information30

    from	pay_accrual_plans
    where	accrual_plan_id = p_accrual_plan_id;

Line: 201

    select 	accrual_plan_id,
	business_group_id,
	accrual_plan_element_type_id,
	pto_input_value_id,
	co_input_value_id,
	residual_input_value_id,
	accrual_category,
	accrual_plan_name,
	accrual_start,
	accrual_units_of_measure,
	ineligible_period_length,
	ineligible_period_type,
	accrual_formula_id,
	co_formula_id,
	co_date_input_value_id,
	co_exp_date_input_value_id,
	residual_date_input_value_id,
	description,
        ineligibility_formula_id,
        payroll_formula_id,
        defined_balance_id,
        tagging_element_type_id,
        balance_element_type_id,
	object_version_number,
        information_category,
        information1,
        information2,
        information3,
        information4,
        information5,
        information6,
        information7,
        information8,
        information9,
        information10,
        information11,
        information12,
        information13,
        information14,
        information15,
        information16,
        information17,
        information18,
        information19,
        information20,
        information21,
        information22,
        information23,
        information24,
        information25,
        information26,
        information27,
        information28,
        information29,
        information30

    from	pay_accrual_plans
    where	accrual_plan_id = p_accrual_plan_id
    for	update nowait;