DBA Data[Home] [Help]

APPS.PAY_US_MMREF_REPORTING_MT dependencies on FF_ARCHIVE_ITEMS

Line 310: ff_archive_items arch,

306: pay_action_interlocks AI,
307: pay_assignment_actions AA,
308: pay_assignment_actions paa,
309: pay_payroll_actions PA,
310: ff_archive_items arch,
311: ff_user_entities fue
312: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
313: ('TRANSFER_PAYROLL_ACTION_ID')
314: AND AA.payroll_action_id = PA.payroll_action_id

Line 385: from ff_archive_items fai,

381: */
382: CURSOR IN_LOCAL_MMRF_EMPLOYEE IS
383: SELECT 'JURISDICTION_CODE=C', rtrim(ltrim(faic.context)),
384: 'TRANSFER_YE_JURISDICTION_CODE=P', ltrim(rtrim(faic.context))
385: from ff_archive_items fai,
386: ff_contexts fc, -- JD
387: ff_database_items fdi,
388: ff_archive_item_contexts faic, -- JD
389: pay_assignment_actions paa

Line 407: from ff_archive_items fai,

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