eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.HR_PAY_INTERFACE_ELE_ENT_4_V

Source

View Text - Preformatted


SELECT
  pp.employee_number
, pp.full_name
, asg.assignment_number
, hou.name
, bgr.name
, ppr.payroll_name
, ptp.number_per_fiscal_year
, pet.processing_type
, DECODE (pee.effective_end_date,
          GREATEST(pee.effective_end_date,
                   HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE ), 'Y'
         ,'N')
, pet.reporting_name
, DECODE (piv1.hot_default_flag,
	 'N', pev1.screen_entry_value,
          DECODE(pev1.screen_entry_value,
	         NULL, HR_PAY_INTERFACE_PKG.get_hot_default
                         (piv1.input_value_id,
                          pel.element_link_id),
                 pev1.screen_entry_value))
, DECODE (piv2.hot_default_flag,
	 'N', pev2.screen_entry_value,
          DECODE(pev2.screen_entry_value,
	         NULL, HR_PAY_INTERFACE_PKG.get_hot_default
                         (piv2.input_value_id,
                          pel.element_link_id),
                 pev2.screen_entry_value))
, DECODE (piv3.hot_default_flag,
	 'N', pev3.screen_entry_value,
          DECODE(pev3.screen_entry_value,
	         NULL, HR_PAY_INTERFACE_PKG.get_hot_default
                         (piv3.input_value_id,
                          pel.element_link_id),
                 pev3.screen_entry_value))
, DECODE (piv4.hot_default_flag,
	 'N', pev4.screen_entry_value,
          DECODE(pev4.screen_entry_value,
	         NULL, HR_PAY_INTERFACE_PKG.get_hot_default
                         (piv4.input_value_id,
                          pel.element_link_id),
                 pev4.screen_entry_value))
, min(pee2.effective_start_date)
, max(pee2.effective_start_date)
, pee.creator_type
, pet.element_information1
, pet.element_information2
, pet.element_information3
, pet.input_currency_code
, pet.output_currency_code
, asg.assignment_id
, hou.organization_id
, bgr.organization_id
, GREATEST(
  GREATEST(NVL(pet.last_update_date,
	TO_DATE('1900/01/01','YYYY/MM/DD')),
        pet.effective_start_date)
, GREATEST(NVL(pee.last_update_date,
	TO_DATE('1900/01/01','YYYY/MM/DD')),
        pee.effective_start_date)
, GREATEST(NVL(pel.last_update_date,
	TO_DATE('1900/01/01','YYYY/MM/DD')),
        pel.effective_start_date)
	)
, GREATEST(NVL(pet.last_update_date,
	TO_DATE('1900/01/01','YYYY/MM/DD')),
        pet.effective_start_date)
, GREATEST(NVL(pee.last_update_date,
	TO_DATE('1900/01/01','YYYY/MM/DD')),
        pee.effective_start_date)
, GREATEST(NVL(pel.last_update_date,
	TO_DATE('1900/01/01','YYYY/MM/DD')),
        pel.effective_start_date)
FROM
  per_all_people_f           pp
, per_time_period_types      ptp
, hr_all_organization_units  hou
, hr_all_organization_units  bgr
, pay_payrolls_f             ppr
, per_all_assignments_f      asg
, pay_element_entry_values_f pev1
, pay_element_entry_values_f pev2
, pay_element_entry_values_f pev3
, pay_element_entry_values_f pev4
, pay_input_values_f         piv1
, pay_input_values_f         piv2
, pay_input_values_f         piv3
, pay_input_values_f         piv4
, pay_element_entries_f      pee
, pay_element_entries_f      pee2
, pay_element_links_f        pel
, pay_element_types_f        pet
WHERE
  HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE between
      pp.effective_start_date AND pp.effective_end_date
AND pp.person_id = asg.person_id
AND asg.assignment_type = 'E'
AND asg.effective_start_date =
    (SELECT MAX(asg02.effective_start_date)
       FROM per_all_assignments_f  asg02
      WHERE asg.assignment_id = asg02.assignment_id
        AND asg02.effective_start_date <=
             HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE)
AND asg.organization_id = hou.organization_id
AND asg.business_group_id = bgr.organization_id
AND asg.payroll_id = ppr.payroll_id
AND ppr.period_type = ptp.period_type
AND asg.assignment_id = pee.assignment_id
AND pee.element_link_id = pel.element_link_id
AND pel.element_type_id = pet.element_type_id
AND pet.attribute1 = 'Y'
AND pee.element_entry_id = pee2.element_entry_id
AND ( pee.element_entry_id = pev1.element_entry_id
    AND  pev1.input_value_id + 0 = piv1.input_value_id
    AND  piv1.display_sequence = 1
    AND  piv1.name <> 'Pay Value'
    AND  piv1.element_type_id = pet.element_type_id )
AND ( pee.element_entry_id = pev2.element_entry_id
    AND  pev2.input_value_id + 0 = piv2.input_value_id
    AND  piv2.display_sequence = 2
    AND  piv2.element_type_id = pet.element_type_id )
AND ( pee.element_entry_id = pev3.element_entry_id
    AND  pev3.input_value_id + 0 = piv3.input_value_id
    AND  piv3.display_sequence = 3
    AND  piv3.element_type_id = pet.element_type_id )
AND ( pee.element_entry_id = pev4.element_entry_id
    AND  pev4.input_value_id + 0 = piv4.input_value_id
    AND  piv4.display_sequence = 4
    AND  piv4.element_type_id = pet.element_type_id )
AND pel.effective_start_date =
    (SELECT MAX(pel2.effective_start_date)
       FROM pay_element_links_f pel2
      WHERE (pel2.effective_start_date <=
             HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE
        AND pel2.element_link_id = pel.element_link_id))
AND pee.effective_start_date =
    (SELECT MAX(pee02.effective_start_date)
       FROM pay_element_entries_f  pee02
      WHERE pee02.element_entry_id = pee.element_entry_id
        AND pee02.effective_start_date <=
             HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE)
AND ppr.effective_start_date =
    (SELECT MAX(ppr02.effective_start_date)
       FROM pay_payrolls_f  ppr02
      WHERE ppr02.payroll_id = ppr.payroll_id
        AND ppr02.effective_start_date <=
             HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE)
AND pet.effective_start_date =
    (SELECT MAX(pet02.effective_start_date)
       FROM pay_element_types_f  pet02
      WHERE pet02.element_type_id = pet.element_type_id
        AND pet02.effective_start_date <=
             HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE)
AND piv1.effective_start_date =
    (SELECT MAX(piv12.effective_start_date)
       FROM pay_input_values_f   piv12
      WHERE piv1.input_value_id = piv12.input_value_id
        AND piv12.effective_start_date <=
             HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE)
AND piv2.effective_start_date =
    (SELECT MAX(piv22.effective_start_date)
       FROM pay_input_values_f   piv22
      WHERE piv2.input_value_id = piv22.input_value_id
        AND piv22.effective_start_date <=
             HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE)
AND piv3.effective_start_date =
    (SELECT MAX(piv32.effective_start_date)
       FROM pay_input_values_f   piv32
      WHERE piv3.input_value_id = piv32.input_value_id
        AND piv32.effective_start_date <=
             HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE)
AND piv4.effective_start_date =
    (SELECT MAX(piv42.effective_start_date)
       FROM pay_input_values_f   piv42
      WHERE piv4.input_value_id = piv42.input_value_id
        AND piv42.effective_start_date <=
             HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE)
AND pev1.effective_start_date =
    (SELECT MAX(pev12.effective_start_date)
       FROM pay_element_entry_values_f   pev12
      WHERE pev1.element_entry_value_id = pev12.element_entry_value_id
        AND pev12.effective_start_date <=
             HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE)
AND pev2.effective_start_date =
    (SELECT MAX(pev22.effective_start_date)
       FROM pay_element_entry_values_f   pev22
      WHERE pev2.element_entry_value_id = pev22.element_entry_value_id
        AND pev22.effective_start_date <=
             HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE)
AND pev3.effective_start_date =
    (SELECT MAX(pev32.effective_start_date)
       FROM pay_element_entry_values_f   pev32
      WHERE pev3.element_entry_value_id = pev32.element_entry_value_id
        AND pev32.effective_start_date <=
             HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE)
AND pev4.effective_start_date =
    (SELECT MAX(pev42.effective_start_date)
       FROM pay_element_entry_values_f   pev42
      WHERE pev4.element_entry_value_id = pev42.element_entry_value_id
        AND pev42.effective_start_date <=
             HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE)
GROUP BY
  pp.employee_number
, pp.full_name
, asg.assignment_id
, asg.assignment_number
, hou.organization_id
, hou.name
, bgr.organization_id
, bgr.name
, ppr.payroll_name
, ptp.number_per_fiscal_year
, pet.processing_type
, pee.effective_end_date
, pet.reporting_name
, pel.element_link_id
, piv1.input_value_id
, piv1.hot_default_flag
, pev1.screen_entry_value
, piv2.input_value_id
, piv2.hot_default_flag
, pev2.screen_entry_value
, piv3.input_value_id
, piv3.hot_default_flag
, pev3.screen_entry_value
, piv4.input_value_id
, piv4.hot_default_flag
, pev4.screen_entry_value
, pee.creator_type
, pp.last_update_date
, pp.effective_start_date
, hou.last_update_date
, hou.date_from
, asg.last_update_date
, asg.effective_start_date
, pp.last_update_date
, pp.effective_start_date
, hou.last_update_date
, hou.date_from
, asg.last_update_date
, asg.effective_start_date
, pet.element_information1
, pet.element_information2
, pet.element_information3
, pet.input_currency_code
, pet.output_currency_code
, pet.last_update_date
, pet.effective_start_date
, pee.last_update_date
, pee.effective_start_date
, pel.last_update_date
, pel.effective_start_date

View Text - HTML Formatted

SELECT PP.EMPLOYEE_NUMBER
, PP.FULL_NAME
, ASG.ASSIGNMENT_NUMBER
, HOU.NAME
, BGR.NAME
, PPR.PAYROLL_NAME
, PTP.NUMBER_PER_FISCAL_YEAR
, PET.PROCESSING_TYPE
, DECODE (PEE.EFFECTIVE_END_DATE
, GREATEST(PEE.EFFECTIVE_END_DATE
, HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE )
, 'Y'
, 'N')
, PET.REPORTING_NAME
, DECODE (PIV1.HOT_DEFAULT_FLAG
, 'N'
, PEV1.SCREEN_ENTRY_VALUE
, DECODE(PEV1.SCREEN_ENTRY_VALUE
, NULL
, HR_PAY_INTERFACE_PKG.GET_HOT_DEFAULT (PIV1.INPUT_VALUE_ID
, PEL.ELEMENT_LINK_ID)
, PEV1.SCREEN_ENTRY_VALUE))
, DECODE (PIV2.HOT_DEFAULT_FLAG
, 'N'
, PEV2.SCREEN_ENTRY_VALUE
, DECODE(PEV2.SCREEN_ENTRY_VALUE
, NULL
, HR_PAY_INTERFACE_PKG.GET_HOT_DEFAULT (PIV2.INPUT_VALUE_ID
, PEL.ELEMENT_LINK_ID)
, PEV2.SCREEN_ENTRY_VALUE))
, DECODE (PIV3.HOT_DEFAULT_FLAG
, 'N'
, PEV3.SCREEN_ENTRY_VALUE
, DECODE(PEV3.SCREEN_ENTRY_VALUE
, NULL
, HR_PAY_INTERFACE_PKG.GET_HOT_DEFAULT (PIV3.INPUT_VALUE_ID
, PEL.ELEMENT_LINK_ID)
, PEV3.SCREEN_ENTRY_VALUE))
, DECODE (PIV4.HOT_DEFAULT_FLAG
, 'N'
, PEV4.SCREEN_ENTRY_VALUE
, DECODE(PEV4.SCREEN_ENTRY_VALUE
, NULL
, HR_PAY_INTERFACE_PKG.GET_HOT_DEFAULT (PIV4.INPUT_VALUE_ID
, PEL.ELEMENT_LINK_ID)
, PEV4.SCREEN_ENTRY_VALUE))
, MIN(PEE2.EFFECTIVE_START_DATE)
, MAX(PEE2.EFFECTIVE_START_DATE)
, PEE.CREATOR_TYPE
, PET.ELEMENT_INFORMATION1
, PET.ELEMENT_INFORMATION2
, PET.ELEMENT_INFORMATION3
, PET.INPUT_CURRENCY_CODE
, PET.OUTPUT_CURRENCY_CODE
, ASG.ASSIGNMENT_ID
, HOU.ORGANIZATION_ID
, BGR.ORGANIZATION_ID
, GREATEST( GREATEST(NVL(PET.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, PET.EFFECTIVE_START_DATE)
, GREATEST(NVL(PEE.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, PEE.EFFECTIVE_START_DATE)
, GREATEST(NVL(PEL.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, PEL.EFFECTIVE_START_DATE) )
, GREATEST(NVL(PET.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, PET.EFFECTIVE_START_DATE)
, GREATEST(NVL(PEE.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, PEE.EFFECTIVE_START_DATE)
, GREATEST(NVL(PEL.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, PEL.EFFECTIVE_START_DATE) FROM PER_ALL_PEOPLE_F PP
, PER_TIME_PERIOD_TYPES PTP
, HR_ALL_ORGANIZATION_UNITS HOU
, HR_ALL_ORGANIZATION_UNITS BGR
, PAY_PAYROLLS_F PPR
, PER_ALL_ASSIGNMENTS_F ASG
, PAY_ELEMENT_ENTRY_VALUES_F PEV1
, PAY_ELEMENT_ENTRY_VALUES_F PEV2
, PAY_ELEMENT_ENTRY_VALUES_F PEV3
, PAY_ELEMENT_ENTRY_VALUES_F PEV4
, PAY_INPUT_VALUES_F PIV1
, PAY_INPUT_VALUES_F PIV2
, PAY_INPUT_VALUES_F PIV3
, PAY_INPUT_VALUES_F PIV4
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_ELEMENT_ENTRIES_F PEE2
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_TYPES_F PET WHERE HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE BETWEEN PP.EFFECTIVE_START_DATE
AND PP.EFFECTIVE_END_DATE AND PP.PERSON_ID = ASG.PERSON_ID AND ASG.ASSIGNMENT_TYPE = 'E' AND ASG.EFFECTIVE_START_DATE = (SELECT MAX(ASG02.EFFECTIVE_START_DATE)
FROM PER_ALL_ASSIGNMENTS_F ASG02
WHERE ASG.ASSIGNMENT_ID = ASG02.ASSIGNMENT_ID
AND ASG02.EFFECTIVE_START_DATE <= HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE) AND ASG.ORGANIZATION_ID = HOU.ORGANIZATION_ID AND ASG.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID AND ASG.PAYROLL_ID = PPR.PAYROLL_ID AND PPR.PERIOD_TYPE = PTP.PERIOD_TYPE AND ASG.ASSIGNMENT_ID = PEE.ASSIGNMENT_ID AND PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID AND PEL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID AND PET.ATTRIBUTE1 = 'Y' AND PEE.ELEMENT_ENTRY_ID = PEE2.ELEMENT_ENTRY_ID AND ( PEE.ELEMENT_ENTRY_ID = PEV1.ELEMENT_ENTRY_ID
AND PEV1.INPUT_VALUE_ID + 0 = PIV1.INPUT_VALUE_ID
AND PIV1.DISPLAY_SEQUENCE = 1
AND PIV1.NAME <> 'PAY VALUE'
AND PIV1.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID ) AND ( PEE.ELEMENT_ENTRY_ID = PEV2.ELEMENT_ENTRY_ID
AND PEV2.INPUT_VALUE_ID + 0 = PIV2.INPUT_VALUE_ID
AND PIV2.DISPLAY_SEQUENCE = 2
AND PIV2.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID ) AND ( PEE.ELEMENT_ENTRY_ID = PEV3.ELEMENT_ENTRY_ID
AND PEV3.INPUT_VALUE_ID + 0 = PIV3.INPUT_VALUE_ID
AND PIV3.DISPLAY_SEQUENCE = 3
AND PIV3.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID ) AND ( PEE.ELEMENT_ENTRY_ID = PEV4.ELEMENT_ENTRY_ID
AND PEV4.INPUT_VALUE_ID + 0 = PIV4.INPUT_VALUE_ID
AND PIV4.DISPLAY_SEQUENCE = 4
AND PIV4.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID ) AND PEL.EFFECTIVE_START_DATE = (SELECT MAX(PEL2.EFFECTIVE_START_DATE)
FROM PAY_ELEMENT_LINKS_F PEL2
WHERE (PEL2.EFFECTIVE_START_DATE <= HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE
AND PEL2.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID)) AND PEE.EFFECTIVE_START_DATE = (SELECT MAX(PEE02.EFFECTIVE_START_DATE)
FROM PAY_ELEMENT_ENTRIES_F PEE02
WHERE PEE02.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND PEE02.EFFECTIVE_START_DATE <= HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE) AND PPR.EFFECTIVE_START_DATE = (SELECT MAX(PPR02.EFFECTIVE_START_DATE)
FROM PAY_PAYROLLS_F PPR02
WHERE PPR02.PAYROLL_ID = PPR.PAYROLL_ID
AND PPR02.EFFECTIVE_START_DATE <= HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE) AND PET.EFFECTIVE_START_DATE = (SELECT MAX(PET02.EFFECTIVE_START_DATE)
FROM PAY_ELEMENT_TYPES_F PET02
WHERE PET02.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PET02.EFFECTIVE_START_DATE <= HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE) AND PIV1.EFFECTIVE_START_DATE = (SELECT MAX(PIV12.EFFECTIVE_START_DATE)
FROM PAY_INPUT_VALUES_F PIV12
WHERE PIV1.INPUT_VALUE_ID = PIV12.INPUT_VALUE_ID
AND PIV12.EFFECTIVE_START_DATE <= HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE) AND PIV2.EFFECTIVE_START_DATE = (SELECT MAX(PIV22.EFFECTIVE_START_DATE)
FROM PAY_INPUT_VALUES_F PIV22
WHERE PIV2.INPUT_VALUE_ID = PIV22.INPUT_VALUE_ID
AND PIV22.EFFECTIVE_START_DATE <= HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE) AND PIV3.EFFECTIVE_START_DATE = (SELECT MAX(PIV32.EFFECTIVE_START_DATE)
FROM PAY_INPUT_VALUES_F PIV32
WHERE PIV3.INPUT_VALUE_ID = PIV32.INPUT_VALUE_ID
AND PIV32.EFFECTIVE_START_DATE <= HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE) AND PIV4.EFFECTIVE_START_DATE = (SELECT MAX(PIV42.EFFECTIVE_START_DATE)
FROM PAY_INPUT_VALUES_F PIV42
WHERE PIV4.INPUT_VALUE_ID = PIV42.INPUT_VALUE_ID
AND PIV42.EFFECTIVE_START_DATE <= HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE) AND PEV1.EFFECTIVE_START_DATE = (SELECT MAX(PEV12.EFFECTIVE_START_DATE)
FROM PAY_ELEMENT_ENTRY_VALUES_F PEV12
WHERE PEV1.ELEMENT_ENTRY_VALUE_ID = PEV12.ELEMENT_ENTRY_VALUE_ID
AND PEV12.EFFECTIVE_START_DATE <= HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE) AND PEV2.EFFECTIVE_START_DATE = (SELECT MAX(PEV22.EFFECTIVE_START_DATE)
FROM PAY_ELEMENT_ENTRY_VALUES_F PEV22
WHERE PEV2.ELEMENT_ENTRY_VALUE_ID = PEV22.ELEMENT_ENTRY_VALUE_ID
AND PEV22.EFFECTIVE_START_DATE <= HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE) AND PEV3.EFFECTIVE_START_DATE = (SELECT MAX(PEV32.EFFECTIVE_START_DATE)
FROM PAY_ELEMENT_ENTRY_VALUES_F PEV32
WHERE PEV3.ELEMENT_ENTRY_VALUE_ID = PEV32.ELEMENT_ENTRY_VALUE_ID
AND PEV32.EFFECTIVE_START_DATE <= HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE) AND PEV4.EFFECTIVE_START_DATE = (SELECT MAX(PEV42.EFFECTIVE_START_DATE)
FROM PAY_ELEMENT_ENTRY_VALUES_F PEV42
WHERE PEV4.ELEMENT_ENTRY_VALUE_ID = PEV42.ELEMENT_ENTRY_VALUE_ID
AND PEV42.EFFECTIVE_START_DATE <= HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE) GROUP BY PP.EMPLOYEE_NUMBER
, PP.FULL_NAME
, ASG.ASSIGNMENT_ID
, ASG.ASSIGNMENT_NUMBER
, HOU.ORGANIZATION_ID
, HOU.NAME
, BGR.ORGANIZATION_ID
, BGR.NAME
, PPR.PAYROLL_NAME
, PTP.NUMBER_PER_FISCAL_YEAR
, PET.PROCESSING_TYPE
, PEE.EFFECTIVE_END_DATE
, PET.REPORTING_NAME
, PEL.ELEMENT_LINK_ID
, PIV1.INPUT_VALUE_ID
, PIV1.HOT_DEFAULT_FLAG
, PEV1.SCREEN_ENTRY_VALUE
, PIV2.INPUT_VALUE_ID
, PIV2.HOT_DEFAULT_FLAG
, PEV2.SCREEN_ENTRY_VALUE
, PIV3.INPUT_VALUE_ID
, PIV3.HOT_DEFAULT_FLAG
, PEV3.SCREEN_ENTRY_VALUE
, PIV4.INPUT_VALUE_ID
, PIV4.HOT_DEFAULT_FLAG
, PEV4.SCREEN_ENTRY_VALUE
, PEE.CREATOR_TYPE
, PP.LAST_UPDATE_DATE
, PP.EFFECTIVE_START_DATE
, HOU.LAST_UPDATE_DATE
, HOU.DATE_FROM
, ASG.LAST_UPDATE_DATE
, ASG.EFFECTIVE_START_DATE
, PP.LAST_UPDATE_DATE
, PP.EFFECTIVE_START_DATE
, HOU.LAST_UPDATE_DATE
, HOU.DATE_FROM
, ASG.LAST_UPDATE_DATE
, ASG.EFFECTIVE_START_DATE
, PET.ELEMENT_INFORMATION1
, PET.ELEMENT_INFORMATION2
, PET.ELEMENT_INFORMATION3
, PET.INPUT_CURRENCY_CODE
, PET.OUTPUT_CURRENCY_CODE
, PET.LAST_UPDATE_DATE
, PET.EFFECTIVE_START_DATE
, PEE.LAST_UPDATE_DATE
, PEE.EFFECTIVE_START_DATE
, PEL.LAST_UPDATE_DATE
, PEL.EFFECTIVE_START_DATE