DBA Data[Home] [Help]

APPS.PAY_US_MMREF_REPORTING1 dependencies on FF_ARCHIVE_ITEMS

Line 349: ff_archive_items arch,

345: pay_action_interlocks AI,
346: pay_assignment_actions AA,
347: pay_assignment_actions paa,
348: pay_payroll_actions PA,
349: ff_archive_items arch,
350: ff_user_entities fue
351: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
352: ('TRANSFER_PAYROLL_ACTION_ID')
353: AND AA.payroll_action_id = PA.payroll_action_id

Line 424: from ff_archive_items fai,

420: */
421: CURSOR IN_LOCAL_MMRF_EMPLOYEE IS
422: SELECT 'JURISDICTION_CODE=C', rtrim(ltrim(faic.context)),
423: 'TRANSFER_YE_JURISDICTION_CODE=P', ltrim(rtrim(faic.context))
424: from ff_archive_items fai,
425: ff_contexts fc, -- JD
426: ff_database_items fdi,
427: ff_archive_item_contexts faic, -- JD
428: pay_assignment_actions paa

Line 446: from ff_archive_items fai,

442: /* Ohio Cursor */
443: CURSOR OH_LOCAL_MMRF_EMPLOYEE IS
444: SELECT 'JURISDICTION_CODE=C',ltrim(rtrim(faic.context)),
445: 'TRANSFER_YE_JURISDICTION_CODE=P',ltrim(rtrim(faic.context))
446: from ff_archive_items fai,
447: ff_contexts fc, -- JD
448: ff_database_items fdi,
449: ff_archive_item_contexts faic, -- JD
450: pay_assignment_actions paa