[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
2169: elk.location_id,
2170: elk.pay_basis_id,
2171: elk.employment_category,
2172: elk.people_group_id
2173: from pay_element_links_f elk
2174: where elk.element_type_id = c_elt_id
2175: and c_eff_date
2176: between elk.effective_start_date and elk.effective_end_date;
2177: --
2195: )
2196: is
2197: select el.element_link_id
2198: from per_all_assignments_f asg,
2199: pay_element_links_f el
2200: where asg.assignment_id = c_asg_id
2201: and el.business_group_id = asg.business_group_id
2202: and el.element_type_id = c_elt_id
2203: and c_eff_date
2501: ele.object_version_number,
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
2824: ele.object_version_number,
2825: elv.screen_entry_value
2826: from pay_element_entries_f ele,
2827: pay_element_entry_values_f elv,
2828: pay_element_links_f elk
2829: where ele.creator_id = p_enrt_rslt_id
2830: and ele.creator_type = 'F'
2831: and ele.entry_type = 'E'
2832: and ele.effective_start_date > p_effective_date
6679: pet.multiple_entries_allowed_flag,
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
6719: pev.screen_entry_value,
6720: ele.object_version_number
6721: from pay_element_entries_f ele,
6722: pay_element_entry_values_f pev,
6723: pay_element_links_f elk
6724: where ele.creator_id = p_prtt_enrt_rslt_id
6725: and ele.creator_type = 'F'
6726: and ele.entry_type = 'E'
6727: and ele.assignment_id = p_assignment_id
6745: ele.effective_start_date,
6746: ele.effective_end_date,
6747: ele.object_version_number
6748: from pay_element_entries_f ele,
6749: pay_element_links_f elk
6750: where p_effective_date between ele.effective_start_date
6751: and ele.effective_end_date
6752: and ele.assignment_id = p_assignment_id
6753: and ele.element_link_id = elk.element_link_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
8096: and pee.element_entry_id = pev.element_entry_id
8121: pee.entry_type,
8122: pee.element_link_id,
8123: pev.screen_entry_value
8124: from per_all_assignments_f asg,
8125: pay_element_links_f pel,
8126: pay_element_entries_f pee,
8127: pay_element_entry_values_f pev
8128: where asg.person_id = p_person_id
8129: and pee.assignment_id = asg.assignment_id
8153: pee.effective_start_date,
8154: pee.effective_end_date,
8155: pee.object_version_number
8156: from pay_element_entries_f pee,
8157: pay_element_links_f pel
8158: where pee.assignment_id = p_assignment_id
8159: and pee.creator_id = p_enrt_rslt_id
8160: and pee.creator_type = 'F'
8161: and pee.entry_type = 'E'
9910: elk.element_type_id,
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