[Home] [Help]
997: tp.end_date
998: from pay_assignment_actions aa,
999: pay_payroll_actions pa,
1000: pay_quickpay_inclusions qi,
1001: pay_element_links_f el,
1002: pay_element_entries_f ee,
1003: per_time_periods tp
1004: where aa.assignment_id = p_assignment_id
1005: and pa.payroll_action_id = aa.payroll_action_id
2203: elk.location_id,
2204: elk.pay_basis_id,
2205: elk.employment_category,
2206: elk.people_group_id
2207: from pay_element_links_f elk
2208: where elk.element_type_id = c_elt_id
2209: and c_eff_date
2210: between elk.effective_start_date and elk.effective_end_date;
2211: --
2229: )
2230: is
2231: select el.element_link_id
2232: from per_all_assignments_f asg,
2233: pay_element_links_f el
2234: where asg.assignment_id = c_asg_id
2235: and el.business_group_id = asg.business_group_id
2236: and el.element_type_id = c_elt_id
2237: and c_eff_date
2535: ele.object_version_number,
2536: ele.creator_id,
2537: ele.creator_type
2538: from pay_element_entries_f ele,
2539: pay_element_links_f elk,
2540: pay_element_types_f elt
2541: where ele.effective_start_date = (select min(ele2.effective_start_date)
2542: from pay_element_entries_f ele2
2543: where ele2.element_entry_id
2955: ele.object_version_number,
2956: elv.screen_entry_value
2957: from pay_element_entries_f ele,
2958: pay_element_entry_values_f elv,
2959: pay_element_links_f elk
2960: where ele.creator_id = p_enrt_rslt_id
2961: and ele.creator_type = 'F'
2962: and ele.entry_type = 'E'
2963: and ele.effective_start_date > p_effective_date
3165: INDEX(ee pay_element_entries_f_n51) */
3166: ee.*
3167: FROM pay_element_entries_f ee,
3168: pay_element_types_f et,
3169: pay_element_links_f el,
3170: pay_element_entry_values_f ev
3171: WHERE el.element_link_id = ee.element_link_id
3172: AND el.element_link_id = l_elem_link_id
3173: AND el.element_type_id = et.element_type_id
7240: pet.multiple_entries_allowed_flag,
7241: pel.element_type_id,
7242: pev.input_value_id
7243: from per_all_assignments_f asg,
7244: pay_element_links_f pel,
7245: pay_element_types_f pet,
7246: pay_element_entries_f pee,
7247: pay_element_entry_values_f pev
7248: where asg.person_id = p_person_id
7280: pev.screen_entry_value,
7281: ele.object_version_number
7282: from pay_element_entries_f ele,
7283: pay_element_entry_values_f pev,
7284: pay_element_links_f elk
7285: where ele.creator_id = p_prtt_enrt_rslt_id
7286: and ele.creator_type = 'F'
7287: and ele.entry_type = 'E'
7288: and ele.assignment_id = p_assignment_id
7306: ele.effective_start_date,
7307: ele.effective_end_date,
7308: ele.object_version_number
7309: from pay_element_entries_f ele,
7310: pay_element_links_f elk
7311: where p_effective_date between ele.effective_start_date
7312: and ele.effective_end_date
7313: and ele.assignment_id = p_assignment_id
7314: and ele.element_link_id = elk.element_link_id
8649: pev.input_value_id,
8650: pet.element_name,
8651: pet.processing_type
8652: from pay_element_types_f pet,
8653: pay_element_links_f pel,
8654: pay_element_entries_f pee,
8655: pay_element_entry_values_f pev
8656: where pev.element_entry_value_id = p_element_entry_value_id
8657: and pee.element_entry_id = pev.element_entry_id
8682: pee.entry_type,
8683: pee.element_link_id,
8684: pev.screen_entry_value
8685: from per_all_assignments_f asg,
8686: pay_element_links_f pel,
8687: pay_element_entries_f pee,
8688: pay_element_entry_values_f pev
8689: where asg.person_id = p_person_id
8690: and pee.assignment_id = asg.assignment_id
8714: pee.effective_start_date,
8715: pee.effective_end_date,
8716: pee.object_version_number
8717: from pay_element_entries_f pee,
8718: pay_element_links_f pel
8719: where pee.assignment_id = p_assignment_id
8720: and pee.creator_id = p_enrt_rslt_id
8721: and pee.creator_type = 'F'
8722: and pee.entry_type = 'E'
10649: elk.element_type_id,
10650: elk.effective_end_date
10651: from pay_element_entry_values_f elv,
10652: pay_element_entries_f ele,
10653: pay_element_links_f elk,
10654: pay_element_types_f elt
10655: where elv.element_entry_value_id = p_element_entry_value_id
10656: and elv.element_entry_id = ele.element_entry_id
10657: and elv.effective_start_date between ele.effective_start_date