APPS.PAY_PAYRPENP_XML_PKG SQL Statements

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

Line: 18

    select template_name
    into l_template_name
    from xdo_templates_tl
    where application_short_name= p_app_short_name
    and	template_code= p_template_code
    and	language=userenv('LANG');

Line: 237

select typ.name
from per_absence_attendances att,
     per_absence_attendance_types typ
where att.person_id = c_person_id
and att.absence_attendance_type_id = typ.absence_attendance_type_id
and att.date_start <= c_period_end_date
and att.date_end   >= c_period_start_date;

Line: 511

select payroll_name
  from pay_payrolls_f
  where payroll_id = c_payroll_id;

Line: 520

select consolidation_set_name
  from pay_consolidation_sets
  where consolidation_set_id = c_consolidation_set_id;

Line: 529

select name
  from hr_organization_units
  where organization_id = c_organization_id;

Line: 538

select name
  from per_business_groups
  where business_group_id = c_business_group_id;

Line: 613

l_master_statement := 'select ' ||
                      l_group_column1 || ' column1,' ||
		      l_group_column2 || ' column2,' ||
		      l_group_column3 || ' column3 ' ||
		      ' from pay_asgs_not_processed_v where period_end_date between :1 and :2 ' ||
		      l_where_clause || ' group by ' ||
		      l_group_by_clause || ' order by ' ||
		      l_group_by_clause;

Line: 622

l_detail_statement := 'select ' ||
                      'payroll_name payroll_name,
                      assignment_number assignment_number,
                      order_name order_name,
                      full_name full_name,
                      user_status user_status,
                      period_start_date period_start_date,
                      fnd_date.date_to_displaydate(period_start_date, calendar_aware=>2) ICX_period_start_date, -- fnd_date.date_to_displaydate(period_start_date) ICX_period_start_date, /* FOR BUG 11830805 */
                      period_end_date period_end_date,
                      fnd_date.date_to_displaydate(period_end_date, calendar_aware=>2) ICX_period_end_date, -- fnd_date.date_to_displaydate(period_end_date) ICX_period_end_date, /* FOR BUG 11830805 */
                      location_code location_code,
                      pay_basis pay_basis,
                      assignment_id assignment_id,
                      person_id person_id,
                      organization_name organization_name,
                      consolidation_set_name consolidation_set_name
		      from
                      pay_asgs_not_processed_v
                      where
                      period_end_date between :1 and :2 ' ||
		      l_where_clause ||
		      ' and NVL ('|| l_group_column1 || ' , ''-1'' ) = NVL( :3, ''-1'')' ||
		      ' and NVL ('|| l_group_column2 || ' , ''-1'' ) = NVL( :4, ''-1'')' ||
		      ' and NVL ('|| l_group_column3 || ' , ''-1'' ) = NVL( :5, ''-1'')' ||
		      ' order by '||l_order_by_clause;