[Home] [Help]
28:
29: ) is
30: CURSOR element_csr IS
31: SELECT element_type_id
32: FROM pay_element_types_f
33: WHERE element_name = 'IE P45P3_P46 Information'
34: AND nvl(business_group_id, p_business_group_id) = p_business_group_id
35: AND nvl(legislation_code, 'IE') = 'IE'
36: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
215: --13359423
216: ) is
217: CURSOR element_csr IS
218: SELECT element_type_id
219: FROM pay_element_types_f
220: WHERE element_name = 'IE P45P3_P46 Information'
221: AND nvl(business_group_id, p_business_group_id) = p_business_group_id
222: AND nvl(legislation_code, 'IE') = 'IE'
223: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
246: l_tax_yr_start_date date;
247: CURSOR entry_csr IS
248: SELECT pee.element_entry_id, pee.effective_start_date, pee.object_version_number
249: FROM pay_element_entries_f pee,
250: pay_element_types_f pet,
251: pay_element_links_f pel
252: WHERE pee.element_link_id = pel.element_link_id AND
253: pee.assignment_id = p_assignment_id AND
254: --p_effective_date between pee.effective_start_date and pee.effective_end_date AND
271: /*
272: CURSOR entry_csr_any IS
273: SELECT pee.element_entry_id, pee.effective_start_date
274: FROM pay_element_entries_f pee,
275: pay_element_types_f pet,
276: pay_element_links_f pel
277: WHERE pee.element_link_id = pel.element_link_id AND
278: pee.assignment_id = p_assignment_id AND
279: --p_effective_date between pee.effective_start_date and pee.effective_end_date AND
478: -- eff date condition is not used since we are not keeping the datetrack records.
479: CURSOR entry_csr IS
480: SELECT pee.element_entry_id, pee.effective_start_date, pee.object_version_number
481: FROM pay_element_entries_f pee,
482: pay_element_types_f pet,
483: pay_element_links_f pel
484: WHERE pee.element_link_id = pel.element_link_id AND
485: pee.assignment_id = p_assignment_id AND
486: --p_effective_date between pee.effective_start_date and pee.effective_end_date AND
540: --13359423
541: ) is
542: CURSOR element_csr IS
543: SELECT element_type_id
544: FROM pay_element_types_f
545: WHERE element_name = 'IE P45 Information'
546: AND nvl(business_group_id, p_business_group_id) = p_business_group_id
547: AND nvl(legislation_code, 'IE') = 'IE'
548: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
688: rather than just deleting the one.
689:
690: CURSOR entry_csr IS
691: SELECT pee.element_entry_id
692: FROM pay_element_entries_f pee, pay_element_types_f pet, pay_element_links_f pel
693: WHERE pee.element_link_id = pel.element_link_id
694: AND pee.assignment_id = p_assignment_id
695: AND p_effective_date BETWEEN pee.effective_start_Date AND pee.effective_end_Date
696: AND pel.element_type_id = pet.element_type_id
706: l_tax_yr_start_date date;
707: CURSOR entry_csr IS
708: SELECT pee.element_entry_id, pee.effective_start_date
709: FROM pay_element_entries_f pee,
710: pay_element_types_f pet,
711: pay_element_links_f pel
712: WHERE pee.element_link_id = pel.element_link_id AND
713: pee.assignment_id = p_assignment_id AND
714: pee.effective_start_date >= l_tax_yr_start_date and
1311: l_tax_yr_start_date date;
1312: /* CURSOR future_entry_csr IS
1313: SELECT pee.element_entry_id, pee.effective_start_date
1314: FROM pay_element_entries_f pee,
1315: pay_element_types_f pet,
1316: pay_element_links_f pel
1317: WHERE pee.element_link_id = pel.element_link_id AND
1318: pee.assignment_id = l_assignment_id AND
1319: pee.effective_start_date >= l_tax_yr_start_date and
1332: pay_payroll_actions ppa,
1333: pay_assignment_actions paa,
1334: pay_run_results prr,
1335: pay_run_result_values prrv,
1336: pay_element_types_f petf,
1337: pay_element_entries_f peef
1338: where ppa.business_group_id = l_business_group_id
1339: and ppa.action_type = 'B'
1340: and ppa.action_status = 'C'