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 PAY_PAYROLL_ACTIONS

Line 56: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

52: -- the archive process knows what code to execute for each step of
53: -- the archive.
54: --------------------------------------------------------------------
55: procedure range_code
56: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
57: p_sql out nocopy varchar2 );
58: --
59: procedure assignment_action_code
60: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

Line 60: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

56: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
57: p_sql out nocopy varchar2 );
58: --
59: procedure assignment_action_code
60: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
61: p_start_person_id in per_all_people_f.person_id%type,
62: p_end_person_id in per_all_people_f.person_id%type,
63: p_chunk in number );
64: --

Line 66: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type );

62: p_end_person_id in per_all_people_f.person_id%type,
63: p_chunk in number );
64: --
65: procedure initialization_code
66: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type );
67: --
68: procedure archive_code
69: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
70: p_effective_date in date );

Line 75: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

71: ----------------------------------------------------------------------------
72: -- Bug: 3118540 Procedures called from SRS 'IR8S Ad Hoc Printed Archive'
73: ----------------------------------------------------------------------------
74: procedure assignment_action_code_adhoc
75: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
76: p_start_person_id in per_all_people_f.person_id%type,
77: p_end_person_id in per_all_people_f.person_id%type,
78: p_chunk in number );
79: --

Line 81: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type );

77: p_end_person_id in per_all_people_f.person_id%type,
78: p_chunk in number );
79: --
80: procedure initialization_code_adhoc
81: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type );
82: --
83: Function get_archive_value
84: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
85: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type ) return varchar2;

Line 88: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type );

84: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
85: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type ) return varchar2;
86: --
87: procedure deinit_code
88: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type );
89: ----------------------------------------------------------------------------
90: -- These are PRIVATE procedures that required for the Archive
91: -- process.
92: --------------------------------------------------------------------

Line 271: p_setup_action_id in pay_payroll_actions.payroll_action_id%type,

267: -------------------------------------------------------------------------------
268: function employee_if_latest
269: ( p_national_identifier in varchar2,
270: p_person_id in per_all_people_f.person_id%type,
271: p_setup_action_id in pay_payroll_actions.payroll_action_id%type,
272: p_report_type in varchar2 ) return boolean ;
273: --
274: ----------------------------------------------------------------------------
275: -- Bug 4688761 - New function to check if the person_id has been archived once

Line 345: from pay_payroll_actions ppa,

341: 'BASIS_YEAR=P',
342: pay_core_utils.get_parameter('BASIS_YEAR', ppa.legislative_parameters) basis_year,
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')

Line 374: pay_payroll_actions ppa,

370: to_char(paa.person_id) person_id,
371: 'ASSIGNMENT_NUMBER=P',
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')

Line 397: pay_payroll_actions ppa,

393: to_number(ac2.context) tax_unit_id,
394: 'BASIS_YEAR=P',
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')