[Home] [Help]
58:
59: /* pay reg code */
60:
61: sqlstr := 'select distinct to_number(fai4.value)
62: from ff_archive_items fai1,
63: ff_archive_items fai2,
64: ff_archive_items fai3,
65: ff_archive_items fai4,
66: pay_payroll_actions ppa,
59: /* pay reg code */
60:
61: sqlstr := 'select distinct to_number(fai4.value)
62: from ff_archive_items fai1,
63: ff_archive_items fai2,
64: ff_archive_items fai3,
65: ff_archive_items fai4,
66: pay_payroll_actions ppa,
67: pay_assignment_actions paa
60:
61: sqlstr := 'select distinct to_number(fai4.value)
62: from ff_archive_items fai1,
63: ff_archive_items fai2,
64: ff_archive_items fai3,
65: ff_archive_items fai4,
66: pay_payroll_actions ppa,
67: pay_assignment_actions paa
68: where ppa.payroll_action_id = :payroll_action_id
61: sqlstr := 'select distinct to_number(fai4.value)
62: from ff_archive_items fai1,
63: ff_archive_items fai2,
64: ff_archive_items fai3,
65: ff_archive_items fai4,
66: pay_payroll_actions ppa,
67: pay_assignment_actions paa
68: where ppa.payroll_action_id = :payroll_action_id
69: and fai1.user_entity_id = ' || l_uid_caeoy_tax_year ||
184: paa.payroll_action_id,
185: paf.effective_end_date
186: from per_assignments_f paf,
187: pay_assignment_actions paa,
188: ff_archive_items fai,
189: ff_contexts fc,
190: ff_archive_item_contexts faic
191: where paf.person_id between stperson
192: and endperson
218: paa.payroll_action_id,
219: paf.effective_end_date
220: from per_assignments_f paf,
221: pay_assignment_actions paa,
222: ff_archive_items fai,
223: ff_contexts fc,
224: ff_archive_item_contexts faic,
225: pay_population_ranges ppr
226: where --paf.person_id between stperson
255: paa.payroll_action_id,
256: paf.effective_end_date
257: from per_assignments_f paf,
258: pay_assignment_actions paa,
259: ff_archive_items fai,
260: ff_contexts fc,
261: ff_archive_item_contexts faic,
262: per_periods_of_service PDS
263: where paf.person_id between stperson
290: paa.payroll_action_id,
291: paf.effective_end_date
292: from per_assignments_f paf,
293: pay_assignment_actions paa,
294: ff_archive_items fai,
295: ff_contexts fc,
296: ff_archive_item_contexts faic,
297: pay_population_ranges ppr,
298: per_periods_of_service PDS
332: paa.payroll_action_id,
333: paf.effective_end_date
334: from per_assignments_f paf,
335: pay_assignment_actions paa,
336: ff_archive_items fai,
337: ff_contexts fc,
338: ff_archive_item_contexts faic
339: where paf.person_id between stperson
340: and endperson
368: paa.payroll_action_id,
369: paf.effective_end_date
370: from per_assignments_f paf,
371: pay_assignment_actions paa,
372: ff_archive_items fai,
373: ff_contexts fc,
374: ff_archive_item_contexts faic,
375: per_periods_of_service PDS
376: where paf.person_id between stperson
408: paa.payroll_action_id,
409: paf.effective_end_date
410: from per_assignments_f paf,
411: pay_assignment_actions paa,
412: ff_archive_items fai,
413: ff_archive_item_contexts faic,
414: ff_contexts fc
415: where paf.person_id >= stperson
416: and paf.person_id <= endperson
446: paa.payroll_action_id,
447: paf.effective_end_date
448: from per_assignments_f paf,
449: pay_assignment_actions paa,
450: ff_archive_items fai,
451: ff_archive_item_contexts faic,
452: ff_contexts fc,
453: pay_population_ranges ppr
454: where --paf.person_id >= stperson
487: paa.payroll_action_id,
488: paf.effective_end_date
489: from per_assignments_f paf,
490: pay_assignment_actions paa,
491: ff_archive_items fai,
492: ff_archive_item_contexts faic,
493: ff_contexts fc,
494: per_periods_of_service PDS
495: where paf.person_id >= stperson
527: paa.payroll_action_id,
528: paf.effective_end_date
529: from per_assignments_f paf,
530: pay_assignment_actions paa,
531: ff_archive_items fai,
532: ff_archive_item_contexts faic,
533: ff_contexts fc,
534: pay_population_ranges ppr,
535: per_periods_of_service PDS