APPS.HR_NO_UTILITY SQL Statements

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

Line: 68

      SELECT SUBSTR(LTRIM(RTRIM(
             RTRIM(p_first_name)
           ||DECODE(p_middle_name,NULL, '', ' ' || LTRIM(RTRIM(p_middle_name)))
           ||' '||LTRIM(p_last_name))
           ), 1, 240)
       INTO   l_full_name
       FROM   dual;

Line: 147

      SELECT SUBSTR(TRIM(p_last_name)||'   '||TRIM(p_first_name), 1, 240)
      INTO   l_order_name
      FROM   dual;

Line: 292

		select SOFT_CODING_KEYFLEX_ID
		from  PER_ALL_ASSIGNMENTS_F
		where assignment_id = p_assignment_id;

Line: 297

		select ORGANIZATION_ID
		from  PER_ALL_ASSIGNMENTS_F
		where assignment_id = p_assignment_id;

Line: 302

		select lookups.meaning
		from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups
		where scl.SOFT_CODING_KEYFLEX_ID = l_scl_id
		and lookups.lookup_type=l_information_code
		and lookups.enabled_flag = 'Y'
		and lookups.lookup_code = decode(l_information_code,'NO_JOB_STATUS',scl.segment5,
													   'NO_COND_OF_EMP',scl.segment6,
													   'NO_PART_FULL_TIME',scl.segment7,
													   'NO_SHIFT_WORK',scl.segment8,
													   'NO_PAYROLL_PERIOD',scl.segment9,
													   'NO_AGREED_WORKING_HOURS',scl.segment10,null);

Line: 315

		select lookups.meaning
		from hr_organization_units hou, hr_organization_information hoi , hr_lookups lookups
		where hou.organization_id = l_organization_id
		and hou.organization_id = hoi.organization_id
		and hoi.org_information_context = 'NO_EMPLOYMENT_DEFAULTS'
		and lookups.lookup_type = l_information_code
		and lookups.enabled_flag = 'Y'
		and lookups.lookup_code = decode(l_information_code,'NO_JOB_STATUS',hoi.org_information1,
                                                                   'NO_COND_OF_EMP',hoi.org_information2,
                                                                   'NO_PART_FULL_TIME',hoi.org_information3,
                                                                   'NO_SHIFT_WORK',hoi.org_information4,
                                                                   'NO_PAYROLL_PERIOD',hoi.org_information5,
                                                                   'NO_AGREED_WORKING_HOURS',hoi.org_information6,null);

Line: 330

		select nvl(hoi.org_information1,'NO_DATA')
		from hr_organization_units hou , hr_organization_information hoi
		where hou.organization_id = l_organization_id
		and hou.organization_id = hoi.organization_id
		and hoi.org_information_context = 'CLASS'
		and hoi.org_information1 = 'HR_ORG';

Line: 338

		 select segment2
		 from hr_soft_coding_keyflex
		 where soft_coding_keyflex_id = l_scl_id;

Line: 344

		select lookups.meaning
		from hr_organization_information hoi , hr_lookups lookups
		where hoi.organization_id = l_org_id
		and hoi.org_information_context = 'NO_EMPLOYMENT_DEFAULTS'
		and lookups.lookup_type = l_information_code
		and lookups.enabled_flag = 'Y'
		and lookups.lookup_code = decode(l_information_code,'NO_JOB_STATUS',hoi.org_information1,
													   'NO_COND_OF_EMP',hoi.org_information2,
													   'NO_PART_FULL_TIME',hoi.org_information3,
													   'NO_SHIFT_WORK',hoi.org_information4,
													   'NO_PAYROLL_PERIOD',hoi.org_information5,
													   'NO_AGREED_WORKING_HOURS',hoi.org_information6,null);

Line: 358

		select hoi2.organization_id
		from hr_organization_information hoi1 , hr_organization_information hoi2
		where hoi1.org_information1 = to_char(l_local_unit) and hoi1.org_information_context = 'NO_LOCAL_UNITS'
		and hoi2.org_information_context = 'CLASS' and hoi2.org_information1 = 'HR_LEGAL_EMPLOYER'
		and hoi2.organization_id = hoi1.organization_id;

Line: 366

		select business_group_id
		from hr_organization_units
		where organization_id = l_organization_id;

Line: 371

		select scl.segment10
		from HR_SOFT_CODING_KEYFLEX scl
		where scl.SOFT_CODING_KEYFLEX_ID = l_scl_id;

Line: 377

		select hoi.org_information6
		from hr_organization_units hou, hr_organization_information hoi
		where hou.organization_id = l_organization_id
		and hou.organization_id = hoi.organization_id
		and hoi.org_information_context = 'NO_EMPLOYMENT_DEFAULTS';

Line: 385

		select 	hoi.org_information6
		from hr_organization_information hoi
		where hoi.organization_id = l_org_id
		and hoi.org_information_context = 'NO_EMPLOYMENT_DEFAULTS';

Line: 641

        select  EFFECTIVE_START_DATE
        INTO    l_Date
        from    pay_element_entries_f
        where   element_entry_id=p_EE_ID
        and     p_date_earned between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;

Line: 668

        select  EFFECTIVE_END_DATE
        INTO    l_Date
        from    pay_element_entries_f
        where   element_entry_id=p_EE_ID
        and     p_date_earned between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;

Line: 701

    select pvr.LIST_PRICE
          ,pvr.REGISTRATION_NUMBER
          ,pvr.INITIAL_REGISTRATION
    INTO   p_list_price
          ,p_reg_number
          ,p_reg_date
    from   pqp_vehicle_allocations_f  pva
          ,pqp_vehicle_repository_f   pvr
    where  pva.assignment_id = p_assignment_id
    and    pvr.vehicle_repository_id = pva.vehicle_repository_id
    and    p_date_earned between pva.EFFECTIVE_START_DATE and pva.EFFECTIVE_END_DATE
    and    p_date_earned between pvr.EFFECTIVE_START_DATE and pvr.EFFECTIVE_END_DATE;

Line: 767

    Select  COUNT(*)
    INTO    l_num_of_periods
    from    PER_TIME_PERIODS
    where   PAYROLL_ID=p_payroll_id
    and     REGULAR_PAYMENT_DATE <> p_start_date
    and     REGULAR_PAYMENT_DATE between l_start_date and p_end_date
    and     REGULAR_PAYMENT_DATE <= to_date('31-12-' || to_char(p_curr_pay_start_date,'RRRR'),'DD-MM-RRRR');

Line: 806

    Select  COUNT(*)
    INTO    l_num_of_periods
    from    PER_TIME_PERIODS
    where   PAYROLL_ID=p_payroll_id
    and     to_char(REGULAR_PAYMENT_DATE,'mm-yyyy') = to_char(p_curr_per_pay_date,'mm-yyyy');

Line: 837

    Select  REGULAR_PAYMENT_DATE
    INTO    l_regular_pay_date
    from    PER_TIME_PERIODS
    where   PAYROLL_ID=p_payroll_id
    and     START_DATE = p_Curr_Pay_Start_Date;

Line: 886

SELECT user_table_id
FROM   pay_user_tables
WHERE  legislation_code = 'NO'
AND    UPPER(user_table_name) = UPPER(p_table_name);

Line: 892

SELECT user_column_id
FROM   pay_user_columns
WHERE  legislation_code = 'NO'
AND    UPPER(user_column_name) = UPPER(p_column_name)
AND    user_table_id = l_user_table_id;

Line: 902

SELECT user_row_id
FROM   pay_user_rows_f
WHERE  legislation_code = 'NO'
AND    UPPER(row_low_range_or_name) = UPPER(p_return_type)
AND    user_table_id = l_user_table_id
AND    fnd_date.canonical_to_date(p_Date_Earned) BETWEEN effective_start_date AND effective_end_date;

Line: 911

SELECT user_row_id
FROM   pay_user_rows_f
WHERE  legislation_code = 'NO'
AND    UPPER(row_low_range_or_name) = UPPER(p_return_type)
AND    user_table_id = l_user_table_id
AND    p_Date_Earned BETWEEN effective_start_date AND effective_end_date;

Line: 922

SELECT value
FROM   pay_user_column_instances_f
WHERE  legislation_code = 'NO'
AND    user_column_id = l_user_column_id
AND    user_row_id = l_user_row_id
AND    fnd_date.canonical_to_date(p_Date_Earned) BETWEEN effective_start_date AND effective_end_date;

Line: 932

SELECT value
FROM   pay_user_column_instances_f
WHERE  legislation_code = 'NO'
AND    user_column_id = l_user_column_id
AND    user_row_id = l_user_row_id
AND    p_Date_Earned BETWEEN effective_start_date AND effective_end_date;

Line: 945

SELECT fnd_number.canonical_to_number(value)
FROM   pay_user_column_instances_f
WHERE  legislation_code = 'NO'
AND    user_column_id = l_user_column_id
AND    user_row_id = l_user_row_id
AND    p_Date_Earned BETWEEN effective_start_date AND effective_end_date;

Line: 1005

   select null from hr_document_extra_info
    where person_id = p_person_id
      and document_type_id = p_document_type_id
      and (date_from between p_date_from and p_date_to or
           date_to between p_date_from and p_date_to or
           p_date_from between date_from and date_to);

Line: 1013

SELECT 1 FROM HR_DOCUMENT_EXTRA_INFO WHERE
DOCUMENT_TYPE_ID=P_DOCUMENT_TYPE_ID AND
(P_DATE_FROM< DATE_TO AND P_DATE_TO > DATE_FROM );*/

Line: 1033

PROCEDURE UPDATE_NO_DEI_INFO
(P_PERSON_ID	 IN NUMBER DEFAULT NULL,
P_ISSUED_DATE IN DATE  DEFAULT NULL,
P_DATE_FROM	 IN DATE,
P_DATE_TO IN DATE,
P_DOCUMENT_NUMBER IN VARCHAR2  DEFAULT NULL,
P_DOCUMENT_EXTRA_INFO_ID IN NUMBER,
P_DOCUMENT_TYPE_ID	 IN NUMBER
)IS
 l_exists varchar2(1);

Line: 1044

   select null from hr_document_extra_info
    where person_id = p_person_id
      and document_type_id = p_document_type_id
      and (date_from between p_date_from and p_date_to or
           date_to between p_date_from and p_date_to or
           p_date_from between date_from and date_to)
      and document_extra_info_id <> p_document_extra_info_id;

Line: 1055

SELECT 1 FROM HR_DOCUMENT_EXTRA_INFO WHERE
DOCUMENT_TYPE_ID=P_DOCUMENT_TYPE_ID AND
(P_DATE_FROM< DATE_TO AND P_DATE_TO > DATE_FROM );*/

Line: 1090

        SELECT tag
          FROM fnd_lookup_values
          WHERE lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
          AND lookup_code = SUBSTR(USERENV('LANGUAGE'),
                                    INSTR(USERENV('LANGUAGE'), '.') + 1)
          AND language = 'US';

Line: 1162

 SELECT GLOBAL_VALUE
 FROM ff_globals_f
 WHERE global_name = l_global_name
 AND LEGISLATION_CODE = 'NO'
 AND BUSINESS_GROUP_ID IS NULL
 AND l_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE ;