VIEW: APPS.HR_H2PI_ELEMENT_LINKS_V

Source

View Text - Preformatted

SELECT el.last_update_date, el.element_link_id, el.business_group_id, el.effective_start_date, el.effective_end_date, el.payroll_id, el.cost_allocation_keyflex_id, el.element_type_id, el.organization_id, el.location_id, el.pay_basis_id, el.link_to_all_payrolls_flag from pay_element_links_f el, hr_h2pi_element_types_v et WHERE et.element_type_id = el.element_type_id and el.effective_start_date between et.effective_start_date and et.effective_end_date

View Text - HTML Formatted

SELECT EL.LAST_UPDATE_DATE
, EL.ELEMENT_LINK_ID
, EL.BUSINESS_GROUP_ID
, EL.EFFECTIVE_START_DATE
, EL.EFFECTIVE_END_DATE
, EL.PAYROLL_ID
, EL.COST_ALLOCATION_KEYFLEX_ID
, EL.ELEMENT_TYPE_ID
, EL.ORGANIZATION_ID
, EL.LOCATION_ID
, EL.PAY_BASIS_ID
, EL.LINK_TO_ALL_PAYROLLS_FLAG
FROM PAY_ELEMENT_LINKS_F EL
, HR_H2PI_ELEMENT_TYPES_V ET
WHERE ET.ELEMENT_TYPE_ID = EL.ELEMENT_TYPE_ID
AND EL.EFFECTIVE_START_DATE BETWEEN ET.EFFECTIVE_START_DATE
AND ET.EFFECTIVE_END_DATE