[Home] [Help]
915: hoi.org_information9||hoi.org_information10||hoi.org_information11),1,255) EMPLOYER_ADDRESS,
916: peev.effective_end_date PREV_SWOT_TERM_DATE
917: from hr_organization_information hoi,
918: pay_element_entry_values_f peev,
919: pay_element_entries_f pee
920: where hoi.organization_id(+) = cp_itax_organization_id
921: and hoi.org_information_context(+) = 'JP_TAX_SWOT_INFO'
922: -- Previous SWOT term date
923: and cp_date_earned between peev.effective_start_date and peev.effective_end_date
1099: employer_name.screen_entry_value PJOB_EMPLOYER_NAME
1100: from (select /*+ ORDERED
1101: INDEX(PETF PAY_ELEMENT_TYPES_F_PK)
1102: INDEX(PELF PAY_ELEMENT_LINKS_F_N7)
1103: INDEX(PEEF PAY_ELEMENT_ENTRIES_F_N51) */
1104: peef.element_entry_id
1105: from pay_element_types_f petf,
1106: pay_element_links_f pelf,
1107: pay_element_entries_f peef
1103: INDEX(PEEF PAY_ELEMENT_ENTRIES_F_N51) */
1104: peef.element_entry_id
1105: from pay_element_types_f petf,
1106: pay_element_links_f pelf,
1107: pay_element_entries_f peef
1108: where petf.element_type_id = p_pjob_ele_type_id
1109: and pelf.element_type_id = petf.element_type_id
1110: and pelf.business_group_id +0 = p_business_group_id
1111: and peef.element_link_id = pelf.element_link_id
2084: select /*+ ORDERED
2085: USE_NL(PLIV1, PLIV2, PEE, PEEV1, PEEV2)
2086: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV1)
2087: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV2)
2088: INDEX(PAY_ELEMENT_ENTRIES_F_N51 PEE)
2089: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV1)
2090: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV2) */
2091: pee.element_entry_id ee_id,
2092: pee.effective_start_date ee_esd,
2094: peev1.screen_entry_value applied_mth,
2095: peev2.screen_entry_value new_std_mth_comp
2096: from pay_link_input_values_f pliv1,
2097: pay_link_input_values_f pliv2,
2098: pay_element_entries_f pee,
2099: pay_element_entry_values_f peev1,
2100: pay_element_entry_values_f peev2
2101: where pliv1.input_value_id = p_applied_mth_iv_id
2102: and pliv2.input_value_id = p_new_std_mth_comp_iv_id