APPS.PAY_HXC_DEPOSIT_INTERFACE SQL Statements

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

Line: 53

  select end_user_column_name
    from fnd_descr_flex_column_usages c, hxc_mapping_components mpc
   where c.application_id = 809
     and c.descriptive_flexfield_name = 'OTC Information Types'
     and c.descriptive_flex_context_code = 'ELEMENT - '||to_char(p_ele_type_id)
     and c.application_column_name = mpc.segment
     and upper(mpc.field_name) = p_ipv_segment;

Line: 106

   select piv.name, piv.input_value_id, piv.display_sequence,
          piv.effective_start_date, piv.effective_end_date,
          piv.uom
     from pay_input_values_f piv
    where piv.element_type_id = p_element_type_id
      and p_effective_date between piv.effective_start_date
                               and piv.effective_end_date
      order by piv.display_sequence
      ,        piv.name;

Line: 589

SELECT full_name,effective_start_date,effective_end_date
FROM per_people_f
WHERE person_id = p_person_id
  AND p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line: 664

SELECT paf.assignment_id,
       paf.business_group_id,
       fnd_number.canonical_to_number (bsg.cost_allocation_structure),
       paf.effective_start_date,
       paf.effective_end_date
 FROM per_all_assignments_f paf, per_business_groups bsg
 WHERE paf.person_id = p_person_id
   AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
   AND paf.assignment_type = 'E'
   AND paf.primary_flag = 'Y'
   AND bsg.enabled_flag = 'Y'
   AND paf.business_group_id = bsg.business_group_id;

Line: 745

select petl.element_name,
	   pet.effective_start_date,
	   pet.effective_end_date
from pay_element_types_f pet,
       pay_element_types_f_tl petl
 where pet.element_type_id = p_element_type_id
   and petl.element_type_id = pet.element_type_id
   and p_user_language = petl.language
   and p_effective_date between pet.effective_start_date
                            and pet.effective_end_date;

Line: 757

select  'Y'
from fnd_descr_flex_column_usages c
where c.application_id = 809
and c.descriptive_flexfield_name = 'OTC Information Types'
and c.descriptive_flex_context_code = 'ELEMENT - '||p_element_type_id;

Line: 813

                                           g_ele_type_ct.DELETE(p_element_type_id);

Line: 928

PROCEDURE pay_update_process
            (p_operation            IN     VARCHAR2) IS

l_blocks     hxc_self_service_time_deposit.timecard_info;

Line: 934

l_proc       VARCHAR2(100) := 'pay_hxc_deposit_interface.PAY_UPDATE_PROCESS';

Line: 954

pay_update_timecard
(p_attributes   => l_attributes,
 p_blocks       => l_blocks );

Line: 963

END pay_update_process;

Line: 968

PROCEDURE pay_update_timecard
           (p_attributes     IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
            p_blocks         in    hxc_self_service_time_deposit.timecard_info
	   )
is

l_index  NUMBER;

Line: 1021

    SELECT pas.BUSINESS_GROUP_ID
         , pas.effective_start_date
         , pas.effective_end_date
    FROM PER_ALL_ASSIGNMENTS_F pas,
         per_assignment_status_types typ
    WHERE pas.PERSON_ID = p_resource_id
       AND pas.ASSIGNMENT_TYPE in ('E','C')
       AND pas.PRIMARY_FLAG = 'Y'
       AND pas.ASSIGNMENT_STATUS_TYPE_ID = typ.ASSIGNMENT_STATUS_TYPE_ID
       AND typ.PER_SYSTEM_STATUS IN ( 'ACTIVE_ASSIGN','ACTIVE_CWK')
       AND p_evaluation_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;

Line: 1035

SELECT pnt.DATE_INPUT_VALUE_id DATE_INPUT_VALUE_id,
       pnt.accrual_plan_id accrual_plan_id
FROM PAY_NET_CALCULATION_RULES pnt,PAY_INPUT_VALUES_F piv
WHERE  piv.business_group_id=p_bg_id
and pnt.DATE_INPUT_VALUE_id=piv.INPUT_VALUE_ID
and piv.element_type_ID=p_element_type_id
AND p_effective_date between piv.effective_start_date and piv.effective_end_date
and piv.business_group_id=pnt.business_group_id;

Line: 1051

  select display_sequence, name, input_value_id, mandatory_flag
    from pay_input_values_f
   where element_type_id = p_element_type_id
     and p_effective_date between effective_start_date and effective_end_date
order by display_sequence, name;

Line: 1059

select  'Y'
from fnd_descr_flex_column_usages c, hxc_mapping_components mpc
where c.application_id = 809
and c.descriptive_flexfield_name = 'OTC Information Types'
and c.descriptive_flex_context_code = 'ELEMENT - '||p_element_type_id
and c.application_column_name = mpc.segment
 and mpc.field_name = 'InputValue'||p_iv_seq;

Line: 1130

		g_pto_assignment_info.DELETE;

Line: 1131

		g_pto_element.DELETE;

Line: 1182

l_new_iv_row.updated         := 'N';

Line: 1304

				g_pto_element.DELETE( l_element_type_id );

Line: 1321

BEGIN --pay_update_timecard

l_index  :=p_blocks.first;

Line: 1374

END pay_update_timecard;

Line: 1422

   SELECT 'X'
   FROM hxc_debug
   WHERE process = 'pay_validate_timecard'
   AND   trunc(debug_date) <= sysdate;

Line: 1675

      l_field_name.delete;

Line: 1676

      l_value.delete;

Line: 1677

      l_attribute_ids.delete;

Line: 1821

         l_input_value.delete;

Line: 1822

         l_segment.delete;