[Home] [Help]
205: CURSOR csr_element_link_id IS
206: select /*+ ORDERED
207: INDEX(PIV PAY_INPUT_VALUES_F_PK)
208: INDEX(PET PAY_ELEMENT_TYPES_F_PK)
209: INDEX(PEL PAY_ELEMENT_LINKS_F_N7) */
210: pel.rowid row_id,
211: pel.element_link_id element_link_id,
212: pel.costable_type costable_type,
213: piv.name input_value_name,
218: piv.min_value min_value,
219: piv.warning_or_error warning_or_error
220: from pay_input_values_f piv,
221: pay_element_types_f pet,
222: pay_element_links_f pel
223: where piv.input_value_id = p_parameter_value
224: and pet.element_type_id = piv.element_type_id
225: and piv.effective_start_date
226: between pet.effective_start_date and pet.effective_end_date
291: pel.last_updated_by,
292: pel.last_update_login,
293: NULL,
294: pel.creation_date
295: from pay_element_links_f pel
296: where pel.rowid=rec_element_link.row_id
297: and not exists(
298: select null
299: from pay_link_input_values_f
375: v_entry_id NUMBER;
376:
377: CURSOR csr_element_link_id IS
378: select element_link_id
379: from pay_element_links_f
380: where element_type_id=l_element_type_id;
381:
382: CURSOR csr_element_entry_id(
383: p_element_link_id IN NUMBER,
1089: cursor csr_entry
1090: is
1091: select /*+ ORDERED
1092: USE_NL(PEL, PEE, PEEV)
1093: INDEX(PEL PAY_ELEMENT_LINKS_F_N7)
1094: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51)
1095: INDEX(PEEV PAY_ELEMENT_ENTRY_VALUES_F_N50) */
1096: pee.element_entry_id,
1097: pee.effective_start_date,
1098: pee.effective_end_date,
1099: pee.object_version_number,
1100: peev.input_value_id,
1101: peev.screen_entry_value
1102: from pay_element_links_f pel,
1103: pay_element_entries_f pee,
1104: pay_element_entry_values_f peev
1105: where pel.element_type_id = c_com_hi_smr_elm_id
1106: and pel.business_group_id + 0 = p_business_group_id