[Home] [Help]
2502: ele.creator_id,
2503: ele.creator_type
2504: from pay_element_entries_f ele,
2505: pay_element_links_f elk,
2506: pay_element_types_f elt
2507: where ele.effective_start_date = (select min(ele2.effective_start_date)
2508: from pay_element_entries_f ele2
2509: where ele2.element_entry_id
2510: = ele.element_entry_id)
2760: p_effective_date in date) is
2761: select pet.element_name,
2762: pet.multiple_entries_allowed_flag,
2763: pet.processing_type
2764: from pay_element_types_f pet
2765: where pet.element_type_id = p_element_type_id
2766: and p_effective_date between pet.effective_start_date
2767: and pet.effective_end_date;
2768: --
6680: pel.element_type_id,
6681: pev.input_value_id
6682: from per_all_assignments_f asg,
6683: pay_element_links_f pel,
6684: pay_element_types_f pet,
6685: pay_element_entries_f pee,
6686: pay_element_entry_values_f pev
6687: where asg.person_id = p_person_id
6688: and asg.assignment_id = pee.assignment_id
8087: pel.element_type_id,
8088: pev.input_value_id,
8089: pet.element_name,
8090: pet.processing_type
8091: from pay_element_types_f pet,
8092: pay_element_links_f pel,
8093: pay_element_entries_f pee,
8094: pay_element_entry_values_f pev
8095: where pev.element_entry_value_id = p_element_entry_value_id
9745: and input_value_id = p_input_value_id;
9746: --
9747: cursor c_ety is
9748: select processing_type
9749: from pay_element_types_f
9750: where element_type_id = p_element_type_id
9751: and p_effective_date between effective_start_date
9752: and effective_end_date ;
9753: --
9911: elk.effective_end_date
9912: from pay_element_entry_values_f elv,
9913: pay_element_entries_f ele,
9914: pay_element_links_f elk,
9915: pay_element_types_f elt
9916: where elv.element_entry_value_id = p_element_entry_value_id
9917: and elv.element_entry_id = ele.element_entry_id
9918: and elv.effective_start_date between ele.effective_start_date
9919: and ele.effective_end_date