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 14: g_setup_action_id pay_payroll_actions.payroll_action_id%type;

10: g_basis_year varchar2(4);
11: g_legal_entity_id varchar2(20);
12: g_person_id per_all_people_f.person_id%type;
13: g_assignment_set_id hr_assignment_sets.assignment_set_id%type;
14: g_setup_action_id pay_payroll_actions.payroll_action_id%type;
15: g_report_type varchar2(30);
16: g_previous_person_id per_all_people_f.person_id%type;
17: g_moa_369_date ff_archive_items.value%type;
18: -- Added for bug 5435088 org cursor only need to run once

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

52: -- Action.
53: -- Core Payroll recommends the select has minimal restrictions.
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: is
59: begin
60: if g_debug then

Line 66: 'pay_payroll_actions ppa ' ||

62: end if;
63: --
64: p_sql := 'select distinct person_id ' ||
65: 'from per_people_f ppf, ' ||
66: 'pay_payroll_actions ppa ' ||
67: 'where ppa.payroll_action_id = :payroll_action_id ' ||
68: 'and ppa.business_group_id = ppf.business_group_id ' ||
69: 'order by ppf.person_id';
70: --

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

76: -- Bug 3435334 - Pre-processor process now introduced for this archive.
77: -- Assignment actions are created for all assignments processed by pre-processor
78: ----------------------------------------------------------------------------
79: procedure assignment_action_code
80: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
81: p_start_person_id in per_all_people_f.person_id%type,
82: p_end_person_id in per_all_people_f.person_id%type,
83: p_chunk in number )
84: is

Line 86: v_setup_action_id pay_payroll_actions.payroll_action_id%type;

82: p_end_person_id in per_all_people_f.person_id%type,
83: p_chunk in number )
84: is
85: v_next_action_id pay_assignment_actions.assignment_action_id%type;
86: v_setup_action_id pay_payroll_actions.payroll_action_id%type;
87: v_assignment_id per_all_assignments_f.assignment_id%type;
88: --
89: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
90: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)

Line 89: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

85: v_next_action_id pay_assignment_actions.assignment_action_id%type;
86: v_setup_action_id pay_payroll_actions.payroll_action_id%type;
87: v_assignment_id per_all_assignments_f.assignment_id%type;
88: --
89: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
90: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)
91: from pay_payroll_actions
92: where payroll_action_id = c_payroll_Action_id;
93: --

Line 91: from pay_payroll_actions

87: v_assignment_id per_all_assignments_f.assignment_id%type;
88: --
89: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
90: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)
91: from pay_payroll_actions
92: where payroll_action_id = c_payroll_Action_id;
93: --
94: cursor next_action_id is
95: select pay_assignment_actions_s.nextval

Line 98: cursor process_assignments ( c_setup_action_id in pay_payroll_actions.payroll_action_id%type ) is

94: cursor next_action_id is
95: select pay_assignment_actions_s.nextval
96: from dual;
97: --
98: cursor process_assignments ( c_setup_action_id in pay_payroll_actions.payroll_action_id%type ) is
99: select distinct pai.assignment_id
100: from pay_action_information pai
101: where pai.action_context_id = c_setup_action_id
102: and pai.action_context_type = 'AAP'

Line 149: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )

145: -- Bug 3435334 - Pre-processor process now introduced for this archive.
146: -- Populating PL/SQL table logic with rehire query is removed
147: ------------------------------------------------------------------------
148: procedure initialization_code
149: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
150: is
151: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is
152: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
153: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),

Line 151: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is

147: ------------------------------------------------------------------------
148: procedure initialization_code
149: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
150: is
151: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is
152: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
153: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
154: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
155: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),

Line 159: from pay_payroll_actions

155: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
156: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
157: pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters),
158: report_type
159: from pay_payroll_actions
160: where payroll_action_id = c_payroll_action_id;
161: ------------------------------------------------------------------------
162: -- Bug 3933332 - Get A8A_Applicable flag
163: ------------------------------------------------------------------------

Line 168: pay_payroll_actions

164: cursor get_org_a8a_applicable
165: is
166: select org_information19
167: from hr_organization_information,
168: pay_payroll_actions
169: where org_information_context ='SG_LEGAL_ENTITY'
170: and organization_id = pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters)
171: and payroll_action_id = p_payroll_action_id;
172: begin

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

203: --------------------------------------------------------------------------------
204: -- Bug: 3118540 - This function is called from SRS 'IR8S Ad Hoc Printed Archive'
205: --------------------------------------------------------------------------------
206: procedure assignment_action_code_adhoc
207: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
208: p_start_person_id in per_all_people_f.person_id%type,
209: p_end_person_id in per_all_people_f.person_id%type,
210: p_chunk in number )
211: is

Line 224: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

220: v_asg_id per_all_assignments_f.assignment_id%type;
221: ----------------------------------------------------------------------------
222: -- Cursor to get the values of archive parameters
223: ----------------------------------------------------------------------------
224: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
225: select pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
226: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
227: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
228: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),

Line 232: from pay_payroll_actions

228: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
229: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
230: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
231: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters)
232: from pay_payroll_actions
233: where payroll_action_id = c_payroll_action_id;
234: ----------------------------------------------------------------------------
235: -- Cursor Next Assignment Action
236: ----------------------------------------------------------------------------

Line 246: ( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

242: -- Bug: 3404526 - Added max(assignment_id) to pick the latest assignment in case of Normal rehire.
243: -- Bug#3614563 Removed the Business Group id check from inner query to imporove the performence.
244: ----------------------------------------------------------------------------
245: cursor process_assignments
246: ( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
247: c_start_person_id in per_all_people_f.person_id%type,
248: c_end_person_id in per_all_people_f.person_id%type,
249: c_person_id in per_all_people_f.person_id%type,
250: c_assignment_set_id in hr_assignment_sets.assignment_set_id%type,

Line 257: pay_payroll_actions ppa1

253: c_basis_start in date,
254: c_basis_end in date) is
255: select max(paf.assignment_id)
256: from per_assignments_f paf,
257: pay_payroll_actions ppa1
258: where ppa1.payroll_action_id = c_payroll_action_id
259: and paf.person_id between c_start_person_id and c_end_person_id
260: and ppa1.business_group_id = paf.business_group_id
261: and paf.person_id = nvl(c_person_id,paf.person_id)

Line 267: from pay_payroll_actions ppa,

263: and decode(c_assignment_set_id,null,'Y',
264: decode(hr_assignment_set.ASSIGNMENT_IN_SET(c_assignment_set_id,paf.assignment_id),'Y','Y','N')) = 'Y'
265: and exists
266: ( select null
267: from pay_payroll_actions ppa,
268: pay_assignment_actions paa
269: where ppa.payroll_action_id = paa.payroll_action_id
270: and paa.assignment_id = paf.assignment_id
271: and paa.tax_unit_id = c_legal_entity_id

Line 332: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )

328: -- Bug 3435334 - Fetching report_type into g_report_type which helps to identify
329: -- which process is running IR8S adhoc archive/main archive process
330: --------------------------------------------------------------------------------
331: procedure initialization_code_adhoc
332: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
333: is
334: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is
335: select pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
336: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),

Line 334: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is

330: --------------------------------------------------------------------------------
331: procedure initialization_code_adhoc
332: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
333: is
334: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is
335: select pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
336: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
337: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
338: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),

Line 343: from pay_payroll_actions

339: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
340: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
341: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),
342: report_type
343: from pay_payroll_actions
344: where payroll_action_id = c_payroll_action_id;
345: --
346: begin
347: if g_debug then

Line 429: v_archive_date pay_payroll_actions.effective_date%type;

425: is
426: v_person_id per_all_people_f.person_id%type;
427: v_assignment_id per_all_assignments_f.assignment_id%type;
428: v_national_identifier varchar2(50);
429: v_archive_date pay_payroll_actions.effective_date%type;
430: l_person_id per_all_people_f.person_id%type;
431: l_archived_person_id binary_integer;
432:
433: ------------------------------------------------------------------------

Line 1140: pay_payroll_actions ppamax

1136: max(pacmax.action_sequence) act_seq,
1137: to_char(ppamax.effective_date,'MM')
1138: from per_assignments_f paamax,
1139: pay_assignment_actions pacmax,
1140: pay_payroll_actions ppamax
1141: where ppamax.business_group_id = c_business_group_id
1142: and pacmax.tax_unit_id = c_legal_entity_id
1143: and paamax.person_id = c_person_id
1144: and paamax.assignment_id = pacmax.assignment_id

Line 1167: pay_payroll_actions ppa

1163: decode(ppa.action_type,'V',fnd_date.date_to_canonical(ppa.effective_date),fnd_date.date_to_canonical(ppa.date_earned)) date_earned,
1164: pac.tax_unit_id tax_uid
1165: from per_assignments_f paa,
1166: pay_assignment_actions pac,
1167: pay_payroll_actions ppa
1168: where ppa.business_group_id = c_business_group_id
1169: and pac.tax_unit_id = c_legal_entity_id
1170: and paa.person_id = c_person_id
1171: and paa.assignment_id = pac.assignment_id

Line 1816: pay_payroll_actions pact1,

1812: c_business_group_id hr_organization_units.business_group_id%type )
1813: is
1814: select assact1.assignment_action_id
1815: from pay_assignment_actions assact1,
1816: pay_payroll_actions pact1,
1817: per_assignments_f paaf1
1818: where assact1.tax_unit_id = c_tax_unit_id
1819: and paaf1.assignment_id = c_prev_ass_id
1820: and paaf1.assignment_id = assact1.assignment_id

Line 1827: pay_payroll_actions pact,

1823: and pact1.action_status = 'C'
1824: and assact1.action_sequence =
1825: ( select max(assact.action_sequence)
1826: from pay_assignment_actions assact,
1827: pay_payroll_actions pact,
1828: per_assignments_f paaf
1829: where paaf.assignment_id = paaf1.assignment_id
1830: and paaf.assignment_id = assact.assignment_id
1831: and pact.payroll_action_id = assact.payroll_action_id

Line 1866: pay_payroll_actions pact,

1862: pay_balance_types pbt,
1863: pay_run_results rr,
1864: pay_assignment_actions assact,
1865: pay_assignment_actions bal_assact,
1866: pay_payroll_actions pact,
1867: pay_payroll_actions bact,
1868: per_assignments_f ass
1869: where bal_assact.assignment_action_id = p_asg_action_id
1870: and bal_assact.payroll_action_id = bact.payroll_action_id

Line 1867: pay_payroll_actions bact,

1863: pay_run_results rr,
1864: pay_assignment_actions assact,
1865: pay_assignment_actions bal_assact,
1866: pay_payroll_actions pact,
1867: pay_payroll_actions bact,
1868: per_assignments_f ass
1869: where bal_assact.assignment_action_id = p_asg_action_id
1870: and bal_assact.payroll_action_id = bact.payroll_action_id
1871: and feed.balance_type_id = pbt.balance_type_id + decode(target.input_value_id,null,0,0)

Line 1899: pay_payroll_actions PACT,

1895: fnd_date.date_to_canonical(max(prb.effective_date)) date_to,
1896: sum(decode(ppa.action_type,'V',-1,1)) no_of_times
1897: from pay_run_balances prb,
1898: pay_assignment_actions ASSACT,
1899: pay_payroll_actions PACT,
1900: per_assignments_f ass,
1901: pay_payroll_actions ppa,
1902: pay_assignment_actions paa
1903: where prb.defined_balance_id = c_def_balance_id

Line 1901: pay_payroll_actions ppa,

1897: from pay_run_balances prb,
1898: pay_assignment_actions ASSACT,
1899: pay_payroll_actions PACT,
1900: per_assignments_f ass,
1901: pay_payroll_actions ppa,
1902: pay_assignment_actions paa
1903: where prb.defined_balance_id = c_def_balance_id
1904: and assact.assignment_action_id = p_asg_action_id
1905: and assact.payroll_action_id = pact.payroll_action_id

Line 2739: pay_payroll_actions ppamax

2735: is
2736: select fnd_date.date_to_canonical(max(ppamax.effective_date))
2737: from per_assignments_f paamax,
2738: pay_assignment_actions pacmax,
2739: pay_payroll_actions ppamax
2740: where ppamax.business_group_id = c_business_group_id
2741: and pacmax.tax_unit_id = c_legal_entity_id
2742: and paamax.person_id = c_person_id
2743: and paamax.assignment_id = pacmax.assignment_id

Line 4365: procedure deinit_code ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )

4361: -- Bug 3118540 -
4362: -- Bug 3435334 - This function removes setup action when ran for IRAS Line Archive /
4363: -- initiates SRS 'IR8S Ad Hoc Printed Archive' when ran for IR8S adhoc archive
4364: --------------------------------------------------------------------------------
4365: procedure deinit_code ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
4366: is
4367: l_report_type varchar2(20);
4368: l_rep_req_id number;
4369: v_setup_action pay_payroll_actions.payroll_action_id%type;

Line 4369: v_setup_action pay_payroll_actions.payroll_action_id%type;

4365: procedure deinit_code ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
4366: is
4367: l_report_type varchar2(20);
4368: l_rep_req_id number;
4369: v_setup_action pay_payroll_actions.payroll_action_id%type;
4370: begin
4371: l_rep_req_id := 0;
4372: v_setup_action := 0;
4373: if g_debug then

Line 4379: from pay_payroll_actions ppa

4375: end if;
4376: --
4377: select report_type
4378: into l_report_type
4379: from pay_payroll_actions ppa
4380: where ppa.payroll_action_id = p_payroll_action_id ;
4381: --
4382: if l_report_type = 'SG_IR8S_ADHOC_REPORT' then
4383: l_rep_req_id := FND_REQUEST.SUBMIT_REQUEST (

Line 4397: from pay_payroll_actions

4393: argument8 => 'P_BASIS_END=' || g_basis_end );
4394: elsif l_report_type = 'SG_IRAS_ARCHIVE' then
4395: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)
4396: into v_setup_action
4397: from pay_payroll_actions
4398: where payroll_action_id = p_payroll_action_id ;
4399: -------------------------------------------------------
4400: -- Bug: 3910804 Delete data from pay_action_information
4401: -------------------------------------------------------

Line 4425: p_setup_action_id in pay_payroll_actions.payroll_action_id%type,

4421: -- For second case it also populates global table with all its previous employement records
4422: ----------------------------------------------------------------------
4423: function employee_if_latest ( p_national_identifier in varchar2,
4424: p_person_id in per_all_people_f.person_id%type,
4425: p_setup_action_id in pay_payroll_actions.payroll_action_id%type,
4426: p_report_type in varchar2 ) return boolean
4427: is
4428: type t_person_start_date_tab is table of per_all_people_f.start_date%type;
4429: g_person_start_date_tab t_person_start_date_tab;