120: per_assignment_extra_info paei,
121: ff_archive_items fai,
122: ff_archive_item_contexts faidn,
123: ff_contexts fc1,
124: ff_database_items fdi
125: where ppa.payroll_action_id =
126: nvl(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),
127: ppa.payroll_action_id)
128: and ppa.action_type = 'X'
191: ff_archive_items fai,
192: ff_archive_item_contexts faic2,
193: ff_contexts fc2,
194: pay_za_irp5_bal_codes code,
195: ff_database_items fdi
196: where fai.context1 =
197: pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ACTION_ID')
198: and fc2.context_name = 'SOURCE_NUMBER'
199: and faic2.context_id = fc2.context_id
222: '99999999999' SOURCE_NUMBER
223: FROM
224: ff_archive_items fai,
225: pay_za_irp5_bal_codes code,
226: ff_database_items fdi
227: Where fai.context1 =
228: pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ACTION_ID')
229: AND fdi.user_entity_id = fai.user_entity_id
230: AND fdi.user_name = code.user_name