APPS.PER_IN_ENTRY_VALUE_LEG_HOOK SQL Statements

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

Line: 228

    SELECT pet.element_information1
      FROM pay_element_types_f pet
     WHERE pet.element_type_id = p_element_type_id_o
       AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date;

Line: 236

    SELECT pee.element_entry_id
      FROM pay_element_types_f pet
          ,pay_element_entries_f pee
     WHERE pet.element_type_id =pee.element_type_id
       AND pee.assignment_id = p_assignment_id_o
       AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date
       AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
       AND pet.element_information1 = p_element_name;

Line: 246

    SELECT pet.element_name
      FROM pay_element_types_f pet
     WHERE pet.element_type_id = p_element_type_id_o
       AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date;

Line: 253

   SELECT 1
     FROM per_assignment_extra_info pae
    WHERE assignment_id =  p_assignment_id_o
      AND ( (pae.aei_information_category = 'PER_IN_MEDICAL_BILLS' AND pae.aei_information10 = p_element_entry_id)
         OR (pae.aei_information_category = 'PER_IN_MEDICAL_BILLS' AND pae.aei_information11 = p_element_entry_id)
         OR (pae.aei_information_category = 'PER_IN_LTC_BILLS' AND pae.aei_information11 = p_element_entry_id));

Line: 379

    SELECT pet.ELEMENT_NAME
      FROM pay_element_types_f pet
     WHERE pet.element_type_id = p_element_type_id
       AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date;

Line: 385

   SELECT pee.element_entry_id
     FROM PAY_ELEMENT_ENTRIES_F pee, pay_element_entry_values_f peev
    WHERE pee.assignment_id =  p_assignment_id
      AND pee.element_entry_id =peev.element_entry_id
      AND pee.element_type_id= p_element_type_id
      AND peev.screen_entry_value ='Public Provident Fund'
      AND p_effective_date between pee.effective_start_date and pee.effective_end_date
      AND p_effective_date between peev.effective_start_date and peev.effective_end_date
      AND pee.effective_start_date between pay_in_tax_utils.get_financial_year_start(p_effective_date) and pay_in_tax_utils.get_financial_year_end (p_effective_date);

Line: 397

    SELECT fnd_number.canonical_to_number(peev.screen_entry_value) PPF_AMOUNT
     FROM PAY_ELEMENT_ENTRIES_F pee, pay_element_entry_values_f peev
    WHERE pee.assignment_id =  p_assignment_id
      AND pee.element_entry_id =peev.element_entry_id
      AND pee.element_type_id= p_element_type_id
      AND pee.element_entry_id= p_ppf_element_entry_id
      AND peev.screen_entry_value <>'Public Provident Fund'
      AND p_effective_date between pee.effective_start_date and pee.effective_end_date
      AND p_effective_date between peev.effective_start_date and peev.effective_end_date
      AND pee.effective_start_date between pay_in_tax_utils.get_financial_year_start(p_effective_date) and pay_in_tax_utils.get_financial_year_end (p_effective_date);

Line: 412

   SELECT global_value
     FROM ff_globals_f ffgf
    WHERE global_name = 'IN_PPF_MAX_EXEMPTION_LIMIT_80C'
      AND legislation_code = 'IN'
      AND p_effective_date between ffgf.effective_start_date and ffgf.effective_end_date;

Line: 522

    SELECT pet.ELEMENT_NAME
      FROM pay_element_types_f pet
     WHERE pet.element_type_id = p_element_type_id_O
       AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date;

Line: 528

   SELECT pee.element_entry_id
     FROM PAY_ELEMENT_ENTRIES_F pee, pay_element_entry_values_f peev
    WHERE pee.assignment_id =  p_assignment_id_O
      AND pee.element_entry_id =peev.element_entry_id
      AND pee.element_type_id= p_element_type_id_O
      AND peev.screen_entry_value ='Public Provident Fund'
      AND p_effective_date between pee.effective_start_date and pee.effective_end_date
      AND p_effective_date between peev.effective_start_date and peev.effective_end_date
      AND pee.effective_start_date between pay_in_tax_utils.get_financial_year_start(p_effective_date) and pay_in_tax_utils.get_financial_year_end (p_effective_date);

Line: 540

    SELECT fnd_number.canonical_to_number(peev.screen_entry_value) PPF_AMOUNT
     FROM PAY_ELEMENT_ENTRIES_F pee, pay_element_entry_values_f peev
    WHERE pee.assignment_id =  p_assignment_id_O
      AND pee.element_entry_id =peev.element_entry_id
      AND pee.element_type_id= p_element_type_id_O
      AND pee.element_entry_id= p_ppf_element_entry_id
      AND peev.screen_entry_value <>'Public Provident Fund'
      AND p_effective_date between pee.effective_start_date and pee.effective_end_date
      AND p_effective_date between peev.effective_start_date and peev.effective_end_date
      AND pee.effective_start_date between pay_in_tax_utils.get_financial_year_start(p_effective_date) and pay_in_tax_utils.get_financial_year_end (p_effective_date);

Line: 554

   SELECT global_value
     FROM ff_globals_f ffgf
    WHERE ffgf.global_name = 'IN_PPF_MAX_EXEMPTION_LIMIT_80C'
      AND ffgf.legislation_code = 'IN'
      AND p_effective_date between ffgf.effective_start_date and ffgf.effective_end_date;