DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ARCHIVE dependencies on FF_DATABASE_ITEMS

Line 181: ff_database_items fdi

177: 'TRANSFER_SUI_WAGE_BASE=P',
178: nvl(FFAI.value,' ')
179: from pay_state_rules SR,
180: ff_archive_items ffai,
181: ff_database_items fdi
182: where SR.state_code = pay_magtape_generic.get_parameter_value
183: ('TRANSFER_STATE')
184: and ffai.user_entity_id = fdi.user_entity_id
185: and fdi.user_name = 'A_SUI_TAXABLE_WAGE_BASE'

Line 457: ff_database_items fdi,

453: 'TRANSFER_REPORT_CATEGORY=P', pay_magtape_generic.get_parameter_value
454: ('TRANSFER_REPORT_CATEGORY')
455: from pay_state_rules SR,
456: ff_archive_items ffai,
457: ff_database_items fdi,
458: -- hr_organization_information hoi,
459: pay_payroll_actions ppa
460: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
461: ('TRANSFER_PAYROLL_ACTION_ID')