DBA Data[Home] [Help]

APPS.PAY_US_MMREF_REPORTING_MT dependencies on FF_ARCHIVE_ITEMS

Line 311: ff_archive_items arch,

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

Line 386: from ff_archive_items fai,

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

Line 408: from ff_archive_items fai,

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