[Home] [Help]
263: --
264: cursor nonrecurring_entries (adjust_ee_source in varchar2) is
265: select 'Y'
266: from pay_run_results prr,
267: pay_element_entries_f pee
268: where pee.element_entry_id = p_element_entry_id
269: and p_effective_date between pee.effective_start_date
270: and pee.effective_end_date
271: and prr.source_id = decode(pee.entry_type,
952: begin
953:
954: dt_api.find_dt_upd_modes
955: (p_effective_date => p_effective_date,
956: p_base_table_name => 'PAY_ELEMENT_ENTRIES_F',
957: p_base_key_column => 'element_entry_id',
958: p_base_key_value => p_base_key_value,
959: p_correction => l_correction,
960: p_update => l_update,
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
1006: and pa.action_type = 'Q'
2534: ele.effective_end_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
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
2544: = ele.element_entry_id)
2545: and ele.effective_start_date > p_effective_date
2546: and ele.assignment_id = p_assignment_id
2825: ele.effective_start_date,
2826: ele.effective_end_date,
2827: ele.object_version_number,
2828: elv.element_entry_value_id
2829: from pay_element_entries_f ele,
2830: pay_element_entry_values_f elv
2831: where ele.element_link_id = p_element_link_id
2832: and ele.assignment_id = p_assignment_id
2833: and (p_enrt_rslt_id is null or
2848: ele.effective_start_date,
2849: ele.effective_end_date,
2850: ele.object_version_number,
2851: elv.element_entry_value_id
2852: from pay_element_entries_f ele,
2853: pay_element_entry_values_f elv
2854: where p_effective_date between ele.effective_start_date
2855: and ele.effective_end_date
2856: and elv.element_entry_id = ele.element_entry_id
2860: --
2861: -- 5229941: Fetch MAX end_date of the Element Entry.
2862: cursor get_max_ee_end_dt(p_element_entry_id in number) is
2863: select max(ele.effective_end_date) max_ee_end_date
2864: from pay_element_entries_f ele
2865: where ele.element_entry_id = p_element_entry_id;
2866: --
2867: --
2868: cursor get_current_value
2877: ee.creator_type,
2878: ee.effective_start_date,
2879: ee.effective_end_date
2880: from pay_element_entry_values_f eev,
2881: pay_element_entries_f ee
2882: where eev.element_entry_id = p_element_entry_id
2883: and eev.input_value_id = p_input_value_id
2884: and p_effective_date between eev.effective_start_date
2885: and eev.effective_end_date
2953: ele.effective_start_date,
2954: ele.effective_end_date,
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'
3161: /* Bug 12382133: Check if Non-Recurring element exists in the payroll period */
3162: CURSOR c_entry_exists(l_normal_pp_dt date, l_elem_link_id number, l_ass_id number,
3163: l_input_value_id number) IS
3164: SELECT /*+ LEADING(ee)
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,
3163: l_input_value_id number) IS
3164: SELECT /*+ LEADING(ee)
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
3194: l_input_value_id number,
3195: l_normal_pp_dt date,
3196: l_ELEMENT_ENTRY_ID number) is
3197: select prv.* from ben_prtt_rt_val prv,
3198: pay_element_entries_f et,
3199: pay_element_entry_values_f ev
3200: where et.element_type_id = l_element_type_id
3201: and ev.input_value_id = l_input_value_id
3202: and et.ELEMENT_ENTRY_ID = l_ELEMENT_ENTRY_ID
3480: pee.assignment_id,
3481: pee.element_type_id,
3482: pev.input_value_id,
3483: abr.ele_entry_val_cd -- Bug 5575402
3484: from pay_element_entries_f pee,
3485: pay_element_entry_values_f pev,
3486: ben_acty_base_rt_f abr
3487: where pev.element_entry_value_id = l_ee_id
3488: and pee.element_entry_id = pev.element_entry_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
7249: and asg.assignment_id = pee.assignment_id
7250: and pee.effective_start_date between asg.effective_start_date
7278: ele.effective_start_date,
7279: ele.effective_end_date,
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'
7305: select ele.element_entry_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
7323: --
7324: cursor c_min_max_dt(p_element_entry_id number) is
7325: select min(effective_start_date),
7326: max(effective_end_date)
7327: from pay_element_entries_f
7328: where element_entry_id = p_element_entry_id;
7329: --
7330: cursor c_chk_abs_ler (c_per_in_ler_id number,
7331: c_effective_date date) is
8173: -- bug 5768050
8174: CURSOR c_ee_ovn (v_element_entry_id IN NUMBER)
8175: IS
8176: SELECT object_version_number
8177: FROM pay_element_entries_f
8178: WHERE element_entry_id = v_element_entry_id
8179: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
8180:
8181: l_ovn pay_element_entries_f.object_version_number%TYPE;
8177: FROM pay_element_entries_f
8178: WHERE element_entry_id = v_element_entry_id
8179: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
8180:
8181: l_ovn pay_element_entries_f.object_version_number%TYPE;
8182:
8183: -- end bug 5768050
8184:
8185: l_per_month_amt number;
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
8658: and pev.effective_start_date between pee.effective_start_date
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
8691: and p_effective_date between asg.effective_start_date
8713: select pee.element_entry_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'
8726: and pel.effective_end_date
8727: and pel.element_type_id = p_element_type_id
8728: and pee.effective_start_date
8729: = (select min(pee2.effective_start_date)
8730: from pay_element_entries_f pee2
8731: where pee2.element_entry_id = pee.element_entry_id);
8732: l_future_ee_rec get_future_element_entry%rowtype;
8733:
8734: /* Bug 7597154: Commented the existing cursor c_dup_prv
8805: --
8806: cursor c_min_max_dt(p_element_entry_id number) is
8807: select min(effective_start_date),
8808: max(effective_end_date)
8809: from pay_element_entries_f
8810: where element_entry_id = p_element_entry_id;
8811: --
8812: cursor c_element_ovn(p_element_entry_id number,
8813: p_effective_date date) is
8811: --
8812: cursor c_element_ovn(p_element_entry_id number,
8813: p_effective_date date) is
8814: select object_version_number
8815: from pay_element_entries_f pee
8816: where pee.element_entry_id = p_element_entry_id
8817: and p_effective_date between pee.effective_start_date
8818: and pee.effective_end_date;
8819:
10648: elt.processing_type,
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
10666: l_ele_rec c_ele_info%rowtype;
10667: --
10668: cursor c_element_entry (p_element_entry_id number) is
10669: select object_version_number
10670: from pay_element_entries_f
10671: where element_entry_id = p_element_entry_id;
10672: --
10673: l_object_version_number number;
10674: l_element_entry_id number;