[Home] [Help]
98: -- commenting this out as this range cursor is no longer valid
99: /*
100: sqlstr :=
101: 'SELECT distinct PAF.person_id
102: FROM per_assignments_f PAF,
103: pay_payrolls_f PPY,
104: pay_payroll_actions PPA
105: WHERE PPA.payroll_action_id = :payroll_action_id
106: AND PAF.business_group_id = PPA.business_group_id
111:
112: -- new range cursor
113: sqlstr :=
114: 'SELECT distinct PAF.person_id
115: FROM per_assignments_f PAF,
116: pay_payrolls_f PPY,
117: pay_payroll_actions PPA,
118: per_assignment_extra_info AEI
119: WHERE PPA.payroll_action_id = :payroll_action_id
153: , p_legal_entity_id NUMBER
154: )
155: IS
156: SELECT PAF.assignment_id
157: FROM per_assignments_f PAF
158: , per_assignment_extra_info aei
159: , per_time_periods ptp
160: WHERE PAF.payroll_id = nvl(p_payroll_id, PAF.payroll_id)
161: AND PAF.assignment_id = nvl(p_asg_id, PAF.assignment_id)
162: AND aei.assignment_id = PAF.assignment_id
163: AND aei.aei_information_category = 'ZA_SPECIFIC_INFO'
164: AND aei.aei_information7 = to_char(p_legal_entity_id)
165: AND PAF.effective_end_date = (select max(PAF2.effective_end_date)
166: from per_assignments_f PAF2
167: where PAF2.assignment_id = PAF.assignment_id
168: and PAF2.payroll_id = PAF.payroll_id)
169: AND PAF.person_id BETWEEN stperson and endperson
170: AND ptp.payroll_id = PAF.payroll_id
369: select ptp.prd_information1,PAF.payroll_id, ptp.time_period_id, ptp.prd_information2, ptp.pay_advice_date
370: into g_tax_year, g_payroll_id, g_end_period_id, l_qtr_num, l_pay_advice_date
371: from per_time_periods ptp
372: ,pay_assignment_actions paa
373: ,per_assignments_f PAF
374: where paa.assignment_action_id = p_assactid
375: and PAF.assignment_id = paa.assignment_id
376: and ptp.payroll_id = PAF.payroll_id
377: -- and g_end_period_date between PAF.effective_start_date and PAF.effective_end_date