[Home] [Help]
55: ppf.effective_start_date and ppf.effective_end_date;
56: --
57: CURSOR cur_rows_assg IS
58: SELECT count(*)
59: FROM per_all_assignments_f
60: WHERE person_id = p_person_id
61: AND p_effective_date BETWEEN effective_start_date AND effective_end_date ;
62:
63: CURSOR cur_tax_reference IS
63: CURSOR cur_tax_reference IS
64: SELECT COUNT(hsck.segment1) Num, hsck.segment1 tax_district
65: FROM hr_soft_coding_keyflex hsck,
66: pay_all_payrolls_f papf,
67: per_all_assignments_f paaf,
68: per_assignment_status_types past
69: WHERE hsck.soft_coding_keyflex_id = papf.soft_coding_keyflex_id
70: AND papf.payroll_id =paaf.payroll_id
71: AND past.assignment_status_type_id = paaf.assignment_status_type_id
101: pay_element_entries_f ele,
102: pay_element_entry_values_f eev,
103: pay_input_values_f inv,
104: pay_element_links_f lnk, pay_element_types_f elt,
105: per_all_assignments_f paa,
106: pay_all_payrolls_f ppf,
107: hr_soft_coding_keyflex scl
108: where ele.element_entry_id = eev.element_entry_id
109: -- and p_effective_date between ele.effective_start_date and ele.effective_end_date
138: and ppf.effective_start_date <= p_end_date
139: and ppf.effective_end_date >= p_start_date
140:
141: and exists ( SELECT 1
142: FROM per_all_assignments_f paaf,
143: pay_all_payrolls_f papf,
144: hr_soft_coding_keyflex hsck,
145: per_assignment_status_types past
146: WHERE paaf.person_id = p_person_id
173: select count(*)
174: from pay_element_entries_f ele,
175: pay_element_links_f lnk,
176: pay_element_types_f elt,
177: per_all_assignments_f paa
178: where elt.element_name = 'PAYE Details'
179: and p_effective_date between elt.effective_start_date and elt.effective_end_date
180: and elt.element_type_id = lnk.element_type_id
181: and p_effective_date between lnk.effective_start_date and lnk.effective_end_date