1121:
1122: /* CURSOR fac_cur(assign_id NUMBER, geocode VARCHAR2) IS
1123: SELECT distinct paa.assignment_action_id,
1124: faic.context old_juri_code, faic.archive_item_id, ffc.context_id
1125: FROM ff_archive_items fai,
1126: ff_archive_item_contexts faic,
1127: pay_assignment_actions paa,
1128: pay_payroll_actions ppa,
1129: ff_contexts ffc
1152: SELECT distinct paa.assignment_action_id,
1153: faic.context old_juri_code,
1154: faic.archive_item_id,
1155: ffc.context_id
1156: FROM ff_archive_items fai,
1157: ff_archive_item_contexts faic,
1158: pay_assignment_actions paa,
1159: pay_payroll_actions ppa,
1160: ff_contexts ffc