[Home] [Help]
24:
25: ) is
26: CURSOR element_csr IS
27: SELECT element_type_id
28: FROM pay_element_types_f
29: WHERE element_name = 'IE P45P3_P46 Information'
30: AND nvl(business_group_id, p_business_group_id) = p_business_group_id
31: AND nvl(legislation_code, 'IE') = 'IE'
32: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
183: --, p_P45P3_Or_P46_Processed IN VARCHAR2
184: ) is
185: CURSOR element_csr IS
186: SELECT element_type_id
187: FROM pay_element_types_f
188: WHERE element_name = 'IE P45P3_P46 Information'
189: AND nvl(business_group_id, p_business_group_id) = p_business_group_id
190: AND nvl(legislation_code, 'IE') = 'IE'
191: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
213: l_tax_yr_start_date date;
214: CURSOR entry_csr IS
215: SELECT pee.element_entry_id, pee.effective_start_date, pee.object_version_number
216: FROM pay_element_entries_f pee,
217: pay_element_types_f pet,
218: pay_element_links_f pel
219: WHERE pee.element_link_id = pel.element_link_id AND
220: pee.assignment_id = p_assignment_id AND
221: --p_effective_date between pee.effective_start_date and pee.effective_end_date AND
238: /*
239: CURSOR entry_csr_any IS
240: SELECT pee.element_entry_id, pee.effective_start_date
241: FROM pay_element_entries_f pee,
242: pay_element_types_f pet,
243: pay_element_links_f pel
244: WHERE pee.element_link_id = pel.element_link_id AND
245: pee.assignment_id = p_assignment_id AND
246: --p_effective_date between pee.effective_start_date and pee.effective_end_date AND
412: -- eff date condition is not used since we are not keeping the datetrack records.
413: CURSOR entry_csr IS
414: SELECT pee.element_entry_id, pee.effective_start_date, pee.object_version_number
415: FROM pay_element_entries_f pee,
416: pay_element_types_f pet,
417: pay_element_links_f pel
418: WHERE pee.element_link_id = pel.element_link_id AND
419: pee.assignment_id = p_assignment_id AND
420: --p_effective_date between pee.effective_start_date and pee.effective_end_date AND
470: , p_lump_sum_payment IN NUMBER
471: ) is
472: CURSOR element_csr IS
473: SELECT element_type_id
474: FROM pay_element_types_f
475: WHERE element_name = 'IE P45 Information'
476: AND nvl(business_group_id, p_business_group_id) = p_business_group_id
477: AND nvl(legislation_code, 'IE') = 'IE'
478: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
592: rather than just deleting the one.
593:
594: CURSOR entry_csr IS
595: SELECT pee.element_entry_id
596: FROM pay_element_entries_f pee, pay_element_types_f pet, pay_element_links_f pel
597: WHERE pee.element_link_id = pel.element_link_id
598: AND pee.assignment_id = p_assignment_id
599: AND p_effective_date BETWEEN pee.effective_start_Date AND pee.effective_end_Date
600: AND pel.element_type_id = pet.element_type_id
610: l_tax_yr_start_date date;
611: CURSOR entry_csr IS
612: SELECT pee.element_entry_id, pee.effective_start_date
613: FROM pay_element_entries_f pee,
614: pay_element_types_f pet,
615: pay_element_links_f pel
616: WHERE pee.element_link_id = pel.element_link_id AND
617: pee.assignment_id = p_assignment_id AND
618: pee.effective_start_date >= l_tax_yr_start_date and
999: l_tax_yr_start_date date;
1000: /* CURSOR future_entry_csr IS
1001: SELECT pee.element_entry_id, pee.effective_start_date
1002: FROM pay_element_entries_f pee,
1003: pay_element_types_f pet,
1004: pay_element_links_f pel
1005: WHERE pee.element_link_id = pel.element_link_id AND
1006: pee.assignment_id = l_assignment_id AND
1007: pee.effective_start_date >= l_tax_yr_start_date and
1020: pay_payroll_actions ppa,
1021: pay_assignment_actions paa,
1022: pay_run_results prr,
1023: pay_run_result_values prrv,
1024: pay_element_types_f petf,
1025: pay_element_entries_f peef
1026: where ppa.business_group_id = l_business_group_id
1027: and ppa.action_type = 'B'
1028: and ppa.action_status = 'C'