DBA Data[Home] [Help]

APPS.PAY_US_MMREF_REPORTING dependencies on FF_ARCHIVE_ITEMS

Line 321: ff_archive_items arch,

317: pay_action_interlocks AI,
318: pay_assignment_actions AA,
319: pay_assignment_actions paa,
320: pay_payroll_actions PA,
321: ff_archive_items arch,
322: ff_user_entities fue
323: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
324: ('TRANSFER_PAYROLL_ACTION_ID')
325: AND AA.payroll_action_id = PA.payroll_action_id

Line 396: from ff_archive_items fai,

392: */
393: CURSOR IN_LOCAL_MMRF_EMPLOYEE IS
394: SELECT 'JURISDICTION_CODE=C', rtrim(ltrim(faic.context)),
395: 'TRANSFER_YE_JURISDICTION_CODE=P', ltrim(rtrim(faic.context))
396: from ff_archive_items fai,
397: ff_contexts fc, -- JD
398: ff_database_items fdi,
399: ff_archive_item_contexts faic, -- JD
400: pay_assignment_actions paa

Line 418: from ff_archive_items fai,

414: /* Ohio Cursor */
415: CURSOR OH_LOCAL_MMRF_EMPLOYEE IS
416: SELECT 'JURISDICTION_CODE=C',ltrim(rtrim(faic.context)),
417: 'TRANSFER_YE_JURISDICTION_CODE=P',ltrim(rtrim(faic.context))
418: from ff_archive_items fai,
419: ff_contexts fc, -- JD
420: ff_database_items fdi,
421: ff_archive_item_contexts faic, -- JD
422: pay_assignment_actions paa