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 252: p_archive_value in ff_archive_items.value%type );

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

Line 257: p_archive_value in ff_archive_items.value%type,

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

Line 263: p_archive_value in ff_archive_items.value%type,

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

Line 349: ff_archive_items ffi,

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

Line 378: ff_archive_items fai,

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

Line 401: ff_archive_items fai,

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