DBA Data[Home] [Help]

APPS.PAY_ZA_IRP5_MAGTAPE_PKG dependencies on FF_DATABASE_ITEMS

Line 124: ff_database_items fdi

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'

Line 195: ff_database_items fdi

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

Line 226: ff_database_items fdi

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