DBA Data[Home] [Help]

APPS.PAY_US_MMREF_REPORTING dependencies on FF_ARCHIVE_ITEMS

Line 331: ff_archive_items arch,

327: pay_action_interlocks AI,
328: pay_assignment_actions AA,
329: pay_assignment_actions paa,
330: pay_payroll_actions PA,
331: ff_archive_items arch,
332: ff_user_entities fue
333: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
334: ('TRANSFER_PAYROLL_ACTION_ID')
335: AND AA.payroll_action_id = PA.payroll_action_id

Line 406: from ff_archive_items fai,

402: */
403: CURSOR IN_LOCAL_MMRF_EMPLOYEE IS
404: SELECT 'JURISDICTION_CODE=C', rtrim(ltrim(faic.context)),
405: 'TRANSFER_YE_JURISDICTION_CODE=P', ltrim(rtrim(faic.context))
406: from ff_archive_items fai,
407: ff_contexts fc, -- JD
408: ff_database_items fdi,
409: ff_archive_item_contexts faic, -- JD
410: pay_assignment_actions paa

Line 428: from ff_archive_items fai,

424: /* Ohio Cursor */
425: CURSOR OH_LOCAL_MMRF_EMPLOYEE IS
426: SELECT 'JURISDICTION_CODE=C',ltrim(rtrim(faic.context)),
427: 'TRANSFER_YE_JURISDICTION_CODE=P',ltrim(rtrim(faic.context))
428: from ff_archive_items fai,
429: ff_contexts fc, -- JD
430: ff_database_items fdi,
431: ff_archive_item_contexts faic, -- JD
432: pay_assignment_actions paa