[Home] [Help]
906: hoi.org_information9||hoi.org_information10||hoi.org_information11),1,255) EMPLOYER_ADDRESS,
907: peev.effective_end_date PREV_SWOT_TERM_DATE
908: from hr_organization_information hoi,
909: pay_element_entry_values_f peev,
910: pay_element_entries_f pee
911: where hoi.organization_id(+) = cp_itax_organization_id
912: and hoi.org_information_context(+) = 'JP_TAX_SWOT_INFO'
913: -- Previous SWOT term date
914: and cp_date_earned between peev.effective_start_date and peev.effective_end_date
1090: employer_name.screen_entry_value PJOB_EMPLOYER_NAME
1091: from (select /*+ ORDERED
1092: INDEX(PETF PAY_ELEMENT_TYPES_F_PK)
1093: INDEX(PELF PAY_ELEMENT_LINKS_F_N7)
1094: INDEX(PEEF PAY_ELEMENT_ENTRIES_F_N51) */
1095: peef.element_entry_id
1096: from pay_element_types_f petf,
1097: pay_element_links_f pelf,
1098: pay_element_entries_f peef
1094: INDEX(PEEF PAY_ELEMENT_ENTRIES_F_N51) */
1095: peef.element_entry_id
1096: from pay_element_types_f petf,
1097: pay_element_links_f pelf,
1098: pay_element_entries_f peef
1099: where petf.element_type_id = p_pjob_ele_type_id
1100: and pelf.element_type_id = petf.element_type_id
1101: and pelf.business_group_id +0 = p_business_group_id
1102: and peef.element_link_id = pelf.element_link_id
2075: select /*+ ORDERED
2076: USE_NL(PLIV1, PLIV2, PEE, PEEV1, PEEV2)
2077: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV1)
2078: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV2)
2079: INDEX(PAY_ELEMENT_ENTRIES_F_N51 PEE)
2080: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV1)
2081: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV2) */
2082: pee.element_entry_id ee_id,
2083: pee.effective_start_date ee_esd,
2085: peev1.screen_entry_value applied_mth,
2086: peev2.screen_entry_value new_std_mth_comp
2087: from pay_link_input_values_f pliv1,
2088: pay_link_input_values_f pliv2,
2089: pay_element_entries_f pee,
2090: pay_element_entry_values_f peev1,
2091: pay_element_entry_values_f peev2
2092: where pliv1.input_value_id = p_applied_mth_iv_id
2093: and pliv2.input_value_id = p_new_std_mth_comp_iv_id