APPS.SSP_SSPRPELR_XMLP_PKG SQL Statements

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

Line: 13

  select payroll_name
  into c_payroll_name
  from pay_payrolls_x
  where payroll_id = p_payroll_id;

Line: 21

	select ptp.period_name
	into c_time_period_name
	from per_time_periods ptp
	where ptp.time_period_id = p_time_period_id;

Line: 26

  select pcs.consolidation_set_name
  into c_consolidation_set_name
  from pay_consolidation_sets pcs
  where pcs.consolidation_set_id = p_consolidation_set;