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 59: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

55: -- Action.
56: -- Core Payroll recommends the select has minimal restrictions.
57: -----------------------------------------------------------------------------
58: procedure range_code
59: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
60: p_sql out nocopy varchar2 )
61: is
62: begin
63: if g_debug then

Line 69: 'pay_payroll_actions ppa ' ||

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

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

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

Line 89: v_setup_action_id pay_payroll_actions.payroll_action_id%type;

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

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

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

Line 94: from pay_payroll_actions

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

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

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

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

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

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

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

Line 162: from pay_payroll_actions

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

Line 171: pay_payroll_actions

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

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

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

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

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

Line 235: from pay_payroll_actions

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

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

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

Line 260: pay_payroll_actions ppa1

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

Line 270: from pay_payroll_actions ppa,

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

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

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

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

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

Line 346: from pay_payroll_actions

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

Line 432: v_archive_date pay_payroll_actions.effective_date%type;

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

Line 1151: pay_payroll_actions ppamax

1147: max(pacmax.action_sequence) act_seq,
1148: to_char(ppamax.effective_date,'MM')
1149: from per_assignments_f paamax,
1150: pay_assignment_actions pacmax,
1151: pay_payroll_actions ppamax
1152: where ppamax.business_group_id = c_business_group_id
1153: and pacmax.tax_unit_id = c_legal_entity_id
1154: and paamax.person_id = c_person_id
1155: and paamax.assignment_id = pacmax.assignment_id

Line 1178: pay_payroll_actions ppa

1174: decode(ppa.action_type,'V',fnd_date.date_to_canonical(ppa.effective_date),fnd_date.date_to_canonical(ppa.date_earned)) date_earned,
1175: pac.tax_unit_id tax_uid
1176: from per_assignments_f paa,
1177: pay_assignment_actions pac,
1178: pay_payroll_actions ppa
1179: where ppa.business_group_id = c_business_group_id
1180: and pac.tax_unit_id = c_legal_entity_id
1181: and paa.person_id = c_person_id
1182: and paa.assignment_id = pac.assignment_id

Line 1827: pay_payroll_actions pact1,

1823: c_business_group_id hr_organization_units.business_group_id%type )
1824: is
1825: select assact1.assignment_action_id
1826: from pay_assignment_actions assact1,
1827: pay_payroll_actions pact1,
1828: per_assignments_f paaf1
1829: where assact1.tax_unit_id = c_tax_unit_id
1830: and paaf1.assignment_id = c_prev_ass_id
1831: and paaf1.assignment_id = assact1.assignment_id

Line 1838: pay_payroll_actions pact,

1834: and pact1.action_status = 'C'
1835: and assact1.action_sequence =
1836: ( select max(assact.action_sequence)
1837: from pay_assignment_actions assact,
1838: pay_payroll_actions pact,
1839: per_assignments_f paaf
1840: where paaf.assignment_id = paaf1.assignment_id
1841: and paaf.assignment_id = assact.assignment_id
1842: and pact.payroll_action_id = assact.payroll_action_id

Line 1877: pay_payroll_actions pact,

1873: pay_balance_types pbt,
1874: pay_run_results rr,
1875: pay_assignment_actions assact,
1876: pay_assignment_actions bal_assact,
1877: pay_payroll_actions pact,
1878: pay_payroll_actions bact,
1879: per_assignments_f ass
1880: where bal_assact.assignment_action_id = p_asg_action_id
1881: and bal_assact.payroll_action_id = bact.payroll_action_id

Line 1878: pay_payroll_actions bact,

1874: pay_run_results rr,
1875: pay_assignment_actions assact,
1876: pay_assignment_actions bal_assact,
1877: pay_payroll_actions pact,
1878: pay_payroll_actions bact,
1879: per_assignments_f ass
1880: where bal_assact.assignment_action_id = p_asg_action_id
1881: and bal_assact.payroll_action_id = bact.payroll_action_id
1882: and feed.balance_type_id = pbt.balance_type_id + decode(target.input_value_id,null,0,0)

Line 1910: pay_payroll_actions PACT,

1906: fnd_date.date_to_canonical(max(prb.effective_date)) date_to,
1907: sum(decode(ppa.action_type,'V',-1,1)) no_of_times
1908: from pay_run_balances prb,
1909: pay_assignment_actions ASSACT,
1910: pay_payroll_actions PACT,
1911: per_assignments_f ass,
1912: pay_payroll_actions ppa,
1913: pay_assignment_actions paa
1914: where prb.defined_balance_id = c_def_balance_id

Line 1912: pay_payroll_actions ppa,

1908: from pay_run_balances prb,
1909: pay_assignment_actions ASSACT,
1910: pay_payroll_actions PACT,
1911: per_assignments_f ass,
1912: pay_payroll_actions ppa,
1913: pay_assignment_actions paa
1914: where prb.defined_balance_id = c_def_balance_id
1915: and assact.assignment_action_id = p_asg_action_id
1916: and assact.payroll_action_id = pact.payroll_action_id

Line 2791: pay_payroll_actions ppamax

2787: is
2788: select fnd_date.date_to_canonical(max(ppamax.effective_date))
2789: from per_assignments_f paamax,
2790: pay_assignment_actions pacmax,
2791: pay_payroll_actions ppamax
2792: where ppamax.business_group_id = c_business_group_id
2793: and pacmax.tax_unit_id = c_legal_entity_id
2794: and paamax.person_id = c_person_id
2795: and paamax.assignment_id = pacmax.assignment_id

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

4621: -- Bug 3118540 -
4622: -- Bug 3435334 - This function removes setup action when ran for IRAS Line Archive /
4623: -- initiates SRS 'IR8S Ad Hoc Printed Archive' when ran for IR8S adhoc archive
4624: --------------------------------------------------------------------------------
4625: procedure deinit_code ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
4626: is
4627: l_report_type varchar2(20);
4628: l_rep_req_id number;
4629: v_setup_action pay_payroll_actions.payroll_action_id%type;

Line 4629: v_setup_action pay_payroll_actions.payroll_action_id%type;

4625: procedure deinit_code ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
4626: is
4627: l_report_type varchar2(20);
4628: l_rep_req_id number;
4629: v_setup_action pay_payroll_actions.payroll_action_id%type;
4630: begin
4631: l_rep_req_id := 0;
4632: v_setup_action := 0;
4633: if g_debug then

Line 4639: from pay_payroll_actions ppa

4635: end if;
4636: --
4637: select report_type
4638: into l_report_type
4639: from pay_payroll_actions ppa
4640: where ppa.payroll_action_id = p_payroll_action_id ;
4641: --
4642: if l_report_type = 'SG_IR8S_ADHOC_REPORT' then
4643: l_rep_req_id := FND_REQUEST.SUBMIT_REQUEST (

Line 4657: from pay_payroll_actions

4653: argument8 => 'P_BASIS_END=' || g_basis_end );
4654: elsif l_report_type = 'SG_IRAS_ARCHIVE' then
4655: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)
4656: into v_setup_action
4657: from pay_payroll_actions
4658: where payroll_action_id = p_payroll_action_id ;
4659: -------------------------------------------------------
4660: -- Bug: 3910804 Delete data from pay_action_information
4661: -------------------------------------------------------

Line 4685: p_setup_action_id in pay_payroll_actions.payroll_action_id%type,

4681: -- For second case it also populates global table with all its previous employement records
4682: ----------------------------------------------------------------------
4683: function employee_if_latest ( p_national_identifier in varchar2,
4684: p_person_id in per_all_people_f.person_id%type,
4685: p_setup_action_id in pay_payroll_actions.payroll_action_id%type,
4686: p_report_type in varchar2 ) return boolean
4687: is
4688: type t_person_start_date_tab is table of per_all_people_f.start_date%type;
4689: g_person_start_date_tab t_person_start_date_tab;