[Home] [Help]
174: select paf.assignment_id assignment_id,
175: faic.context prov_cd,
176: paa.assignment_action_id,
177: paa.payroll_action_id
178: from per_assignments_f paf,
179: pay_assignment_actions paa,
180: ff_archive_items fai,
181: ff_contexts fc,
182: ff_archive_item_contexts faic
183: where paf.person_id between stperson
184: and endperson
185: and paf.primary_flag = 'Y'
186: and paf.effective_start_date = (select max(paf2.effective_start_date)
187: from per_assignments_f paf2
188: where paf2.assignment_id= paf.assignment_id
189: and paf2.primary_flag = 'Y'
190: and paf2.effective_start_date
191: <= l_session_date) --l_year_end
206: select paf.assignment_id assignment_id,
207: faic.context prov_cd,
208: paa.assignment_action_id,
209: paa.payroll_action_id
210: from per_assignments_f paf,
211: pay_assignment_actions paa,
212: ff_archive_items fai,
213: ff_contexts fc,
214: ff_archive_item_contexts faic
215: where paf.person_id between stperson
216: and endperson
217: and paf.primary_flag = 'Y'
218: and paf.effective_start_date = (select max(paf2.effective_start_date)
219: from per_assignments_f paf2
220: where paf2.assignment_id= paf.assignment_id
221: and paf2.primary_flag = 'Y'
222: and paf2.effective_start_date
223: <= l_session_date) --l_year_end
240: select paf.assignment_id assignment_id,
241: faic.context prov_cd,
242: paa.assignment_action_id,
243: paa.payroll_action_id
244: from per_assignments_f paf,
245: pay_assignment_actions paa,
246: ff_archive_items fai,
247: ff_archive_item_contexts faic,
248: ff_contexts fc
249: where paf.person_id >= stperson
250: and paf.person_id <= endperson
251: and paf.primary_flag = 'Y'
252: and paf.effective_start_date = (select max(paf2.effective_start_date)
253: from per_assignments_f paf2
254: where paf2.assignment_id= paf.assignment_id
255: and paf2.primary_flag = 'Y'
256: and paf2.effective_start_date
257: <= l_session_date) --l_year_end