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_AMEND_ARCHIVE dependencies on FF_ARCHIVE_ITEMS

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

114: --
115: procedure archive_item
116: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
117: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
118: p_archive_value in ff_archive_items.value%type );
119: --
120: procedure archive_item_2
121: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
122: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

Line 123: p_archive_value in ff_archive_items.value%type,

119: --
120: procedure archive_item_2
121: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
122: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
123: p_archive_value in ff_archive_items.value%type,
124: p_context_value2 in ff_archive_item_contexts.context%type );
125: --
126: procedure archive_item_3
127: ( p_user_entity_name in ff_user_entities.user_entity_name%type,

Line 129: p_archive_value in ff_archive_items.value%type,

125: --
126: procedure archive_item_3
127: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
128: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
129: p_archive_value in ff_archive_items.value%type,
130: p_context_value2 in ff_archive_item_contexts.context%type,
131: p_context_value3 in ff_archive_item_contexts.context%type );
132: -------------------------------------------------------------------------------
133: -- Bug 3435334 - New function introduced for implementing duplicate person logic

Line 191: ff_archive_items ffi,

187: 'CREATION_DATE=P',
188: to_char(sysdate,'YYYYMMDD') creation_date
189: from pay_payroll_actions ppa,
190: pay_assignment_actions pac,
191: ff_archive_items ffi,
192: ff_database_items fdi
193: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
194: and ppa.payroll_action_id = pac.payroll_action_id
195: and pac.action_status = 'C'

Line 220: ff_archive_items fai,

216: paa.assignment_number assignment_number
217: from per_all_assignments_f paa,
218: pay_payroll_actions ppa,
219: pay_assignment_actions pac,
220: ff_archive_items fai,
221: ff_archive_item_contexts ac2
222: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
223: and pac.action_status = 'C'
224: and ppa.payroll_action_id = pac.payroll_action_id

Line 243: ff_archive_items fai,

239: pay_core_utils.get_parameter('BASIS_YEAR', ppa.legislative_parameters) basis_year
240: from per_all_assignments_f paa,
241: pay_payroll_actions ppa,
242: pay_assignment_actions pac,
243: ff_archive_items fai,
244: ff_archive_item_contexts ac2
245: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
246: and pac.action_status = 'C'
247: and ppa.payroll_action_id = pac.payroll_action_id