APPS.PAY_PAYWSQEE_PKG SQL Statements

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

Line: 93

	select	iv.input_value_id,
		ivtl.name,
		iv.lookup_type,
		iv.uom,
      iv.value_set_id
		--
	from	pay_input_values_f iv,
                pay_input_values_f_tl ivtl
		--
	where	p_effective_date between iv.effective_start_date
					and iv.effective_end_date
	and	iv.element_type_id	= p_element_type_id
        and     ivtl.INPUT_VALUE_ID     = iv.INPUT_VALUE_ID
        and     ivtl.LANGUAGE           = userenv('LANG')
	order by iv.display_sequence, iv.name;

Line: 394

	select	iv.input_value_id,
		ivtl.name,
		iv.lookup_type,
		iv.uom
		--
	from	pay_input_values_f iv,
                pay_input_values_f_tl ivtl
		--
	where	p_effective_date between iv.effective_start_date
					and iv.effective_end_date
	and	iv.element_type_id	= p_element_type_id
        and     ivtl.INPUT_VALUE_ID     = iv.INPUT_VALUE_ID
        and     ivtl.LANGUAGE           = userenv('LANG')
	order by iv.display_sequence, iv.name;

Line: 604

  select pac.payroll_action_id
    from pay_payroll_actions pac
   where pac.action_type = 'BEE'
     and pac.batch_id = p_batch_id
     and pac.batch_process_mode = 'TRANSFER'
   order by pac.payroll_action_id;

Line: 613

  select fnd_number.canonical_to_number(parameter_value)
    from pay_action_parameters
   where parameter_name = 'BEE_MAX_WAIT_SEC';

Line: 618

  select fnd_number.canonical_to_number(parameter_value)
    from pay_action_parameters
   where parameter_name = 'BEE_INTERVAL_WAIT_SEC';

Line: 627

       select to_char(action_parameter_group_id)
        from  pay_action_parameter_groups
       where  action_parameter_group_name=r_action_parameter_group_name;

Line: 632

         select default_type,default_value
           from FND_DESCR_FLEX_COLUMN_USAGES
          where descriptive_flexfield_name='$SRS$.PAYLINK'
            and end_user_column_name='Action Parameter Group';

Line: 804

	select	nvl (max (batch_sequence), 0) +1
	from	pay_batch_lines
	where	batch_id = p_batch_id;

Line: 830

	select	control_status STATUS
	from	pay_batch_control_totals
	where	batch_id = p_batch_id
	union
	select	batch_line_status
	from	pay_batch_lines
	where	batch_id = p_batch_id
	union
	select	batch_status
	from	pay_batch_headers
	where	batch_id = p_batch_id
        union
        select  'Y'
        from    pay_batch_headers bth
        where   bth.batch_id = p_batch_id
        and     bth.batch_status = 'T'
        -- and     not exists
        --         (select null
        --          from   pay_batch_control_totals ctl
        --          where ctl.batch_id = bth.batch_id
        --          and   ctl.control_status <> 'T')
        order by 1 desc;

Line: 923

select  distinct elt.element_type_id, elt.element_name
        from    pay_element_types_f     ELT,
                pay_batch_lines         LINE
        where line.batch_id = p_batch_id and
              line.element_type_id is not null and
              line.element_type_id = elt.element_type_id
union
select  distinct elt.element_type_id, elt.element_name
        from    pay_element_types_f     ELT,
                pay_batch_lines         LINE
        where line.batch_id = p_batch_id and
              line.element_type_id is null and
              upper (line.element_name) = upper(elt.element_name);

Line: 950

	select	distinct assignment_number
	from	per_assignments_f2
	where	assignment_id = p_assignment_id;

Line: 979

	select	cost_allocation_structure
	from	per_business_groups_perf
	where	business_group_id + 0 = p_business_group_id;

Line: 1002

	select	1
	from	pay_batch_headers
	where	(batch_id <> p_batch_id or p_batch_id is null)
	and	business_group_id = p_business_group_id
	and	upper (batch_name) = upper (p_batch_name);

Line: 1245

       select HL.meaning
         from hr_lookups HL
        where HL.lookup_type = p_lookup_type
          and HL.lookup_code = p_lookup_code;

Line: 1251

       select inv.UOM,
              inv.LOOKUP_TYPE,
              inv.VALUE_SET_ID,
              etp.input_currency_code
       from   pay_input_values_f  inv,
              pay_element_types_f etp
       where  inv.element_type_id   = p_element_type_id
       and    etp.element_type_id   = p_element_type_id
       and    p_session_date between inv.effective_start_date
                               and     inv.effective_end_date
       and    p_session_date between etp.effective_start_date
                               and     etp.effective_end_date
       order by inv.display_sequence
       ,        inv.name;

Line: 1267

      select bth.business_group_id
        from pay_batch_headers bth
       where bth.batch_id = p_batch_id;