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_ITEM_CONTEXTS

Line 97: p_tax_unit_id in ff_archive_item_contexts.context%type,

93: procedure archive_balances
94: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
95: p_person_id in per_all_people_f.person_id%type,
96: p_business_group_id in hr_organization_units.business_group_id%type,
97: p_tax_unit_id in ff_archive_item_contexts.context%type,
98: p_basis_year in varchar2 );
99: --
100: procedure archive_balance_dates
101: ( p_person_id in per_all_people_f.person_id%TYPE,

Line 228: p_tax_unit_id in ff_archive_item_contexts.context%type,

224: ---------------------------------------------------------------------------
225: procedure archive_shares_details
226: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
227: p_person_id in per_all_people_f.person_id%type,
228: p_tax_unit_id in ff_archive_item_contexts.context%type,
229: p_basis_start in date,
230: p_basis_end in date );
231: --
232: procedure archive_ir8s_c_details

Line 235: p_tax_unit_id in ff_archive_item_contexts.context%type,

231: --
232: procedure archive_ir8s_c_details
233: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
234: p_person_id in per_all_people_f.person_id%type,
235: p_tax_unit_id in ff_archive_item_contexts.context%type,
236: p_business_group_id in per_assignments_f.business_group_id%type,
237: p_basis_start in date,
238: p_basis_end in date );
239: --

Line 244: p_tax_unit_id in ff_archive_item_contexts.context%type,

240: procedure archive_ir8s_c_detail_moas
241: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
242: p_1_person_id in per_all_people_f.person_id%type,
243: p_person_id in per_all_people_f.person_id%type,
244: p_tax_unit_id in ff_archive_item_contexts.context%type,
245: p_business_group_id in per_assignments_f.business_group_id%type,
246: p_basis_start in date,
247: p_basis_end in date );
248: --

Line 258: p_context_value2 in ff_archive_item_contexts.context%type );

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,
262: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

Line 264: p_context_value2 in ff_archive_item_contexts.context%type,

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
268: -- with pre-processor

Line 265: p_context_value3 in ff_archive_item_contexts.context%type );

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
268: -- with pre-processor
269: -------------------------------------------------------------------------------

Line 287: , p_tax_unit_id in ff_archive_item_contexts.context%type

283: -- assignment for multi-LEs.
284: ----------------------------------------------------------------------------
285: function pri_if_latest
286: ( p_person_id in per_all_people_f.person_id%type
287: , p_tax_unit_id in ff_archive_item_contexts.context%type
288: , p_basis_start in date
289: , p_basis_end in date) return boolean;
290: --
291: ----------------------------------------------------------------------------

Line 297: , p_tax_unit_id in ff_archive_item_contexts.context%type

293: -- latest primary assignment
294: ----------------------------------------------------------------------------
295: function pri_LE_if_latest
296: ( p_person_id in per_all_people_f.person_id%type
297: , p_tax_unit_id in ff_archive_item_contexts.context%type
298: , p_basis_start in date
299: , p_basis_end in date) return number;
300: --
301: ----------------------------------------------------------------------------

Line 307: , p_tax_unit_id in ff_archive_item_contexts.context%type

303: -- latest assignment without primay flag defined.
304: ----------------------------------------------------------------------------
305: function id_LE_if_latest
306: ( p_person_id in per_all_people_f.person_id%type
307: , p_tax_unit_id in ff_archive_item_contexts.context%type
308: , p_basis_start in date
309: , p_basis_end in date) return number;
310: --
311: ---------------------------------------------------------------------------

Line 379: ff_archive_item_contexts ac2

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
383: and paa.assignment_id = pac.assignment_id

Line 402: ff_archive_item_contexts ac2

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
406: and paa.assignment_id = pac.assignment_id