eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SG_IRAS_ARCHIVE dependencies on FF_ARCHIVE_ITEMS

Line 250: p_archive_value in ff_archive_items.value%type );

246: --
247: procedure archive_item
248: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
249: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
250: p_archive_value in ff_archive_items.value%type );
251: --
252: procedure archive_item_2
253: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
254: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

Line 255: p_archive_value in ff_archive_items.value%type,

251: --
252: procedure archive_item_2
253: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
254: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
255: p_archive_value in ff_archive_items.value%type,
256: p_context_value2 in ff_archive_item_contexts.context%type );
257: --
258: procedure archive_item_3
259: ( p_user_entity_name in ff_user_entities.user_entity_name%type,

Line 261: p_archive_value in ff_archive_items.value%type,

257: --
258: procedure archive_item_3
259: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
260: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
261: p_archive_value in ff_archive_items.value%type,
262: p_context_value2 in ff_archive_item_contexts.context%type,
263: p_context_value3 in ff_archive_item_contexts.context%type );
264: -------------------------------------------------------------------------------
265: -- Bug 3435334 - New function introduced for implementing duplicate person logic

Line 347: ff_archive_items ffi,

343: 'CREATION_DATE=P',
344: to_char(sysdate,'YYYYMMDD') creation_date
345: from pay_payroll_actions ppa,
346: pay_assignment_actions pac,
347: ff_archive_items ffi,
348: ff_database_items fdi
349: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
350: and ppa.payroll_action_id = pac.payroll_action_id
351: and pac.action_status = 'C'

Line 376: ff_archive_items fai,

372: paa.assignment_number assignment_number
373: from per_all_assignments_f paa,
374: pay_payroll_actions ppa,
375: pay_assignment_actions pac,
376: ff_archive_items fai,
377: ff_archive_item_contexts ac2
378: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
379: and pac.action_status = 'C'
380: and ppa.payroll_action_id = pac.payroll_action_id

Line 399: ff_archive_items fai,

395: pay_core_utils.get_parameter('BASIS_YEAR', ppa.legislative_parameters) basis_year
396: from per_all_assignments_f paa,
397: pay_payroll_actions ppa,
398: pay_assignment_actions pac,
399: ff_archive_items fai,
400: ff_archive_item_contexts ac2
401: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
402: and pac.action_status = 'C'
403: and ppa.payroll_action_id = pac.payroll_action_id