912:
913: /* CURSOR fac_cur(assign_id NUMBER, geocode VARCHAR2) IS
914: SELECT distinct paa.assignment_action_id,
915: faic.context old_juri_code, faic.archive_item_id, ffc.context_id
916: FROM ff_archive_items fai,
917: ff_archive_item_contexts faic,
918: pay_assignment_actions paa,
919: pay_payroll_actions ppa,
920: ff_contexts ffc
943: SELECT distinct paa.assignment_action_id,
944: faic.context old_juri_code,
945: faic.archive_item_id,
946: ffc.context_id
947: FROM ff_archive_items fai,
948: ff_archive_item_contexts faic,
949: pay_assignment_actions paa,
950: pay_payroll_actions ppa,
951: ff_contexts ffc