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_KR_BATCH_YEA_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 20: from pay_assignment_actions paa

16: and pds.period_of_service_id = asg.period_of_service_id
17: and ppa.effective_date between pds.date_start and nvl(pds.final_process_date, ppa.effective_date)
18: and exists
19: ( select paa.assignment_id
20: from pay_assignment_actions paa
21: where paa.payroll_action_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, ''BAL_ADJ_ACTION_ID'', null))
22: and paa.assignment_id = asg.assignment_id
23: and paa.action_status in (''C'', ''S'')
24: )

Line 134: from pay_assignment_actions paa2,

130: select /*+
131: ordered
132: use_nl(ppa2)
133: */ null
134: from pay_assignment_actions paa2,
135: pay_payroll_actions ppa2,
136: pay_action_classifications pac
137: where paa2.assignment_id = asg.assignment_id
138: and paa2.action_status not in ('C', 'S') -- Bug 4442484: 'S'kipped assact is not an errored one

Line 150: pay_assignment_actions paa4

146: --
147: and not exists(
148: select null
149: from pay_payroll_actions ppa4,
150: pay_assignment_actions paa4
151: where paa4.assignment_id = asg.assignment_id
152: and paa4.source_action_id is null
153: and ppa4.payroll_action_id = paa4.payroll_action_id
154: and ppa4.action_type IN ('X','B')

Line 164: from pay_assignment_actions paa6

160: -- Include if BA has been processed
161: --
162: and exists (
163: select null
164: from pay_assignment_actions paa6
165: where paa6.payroll_action_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'BAL_ADJ_ACTION_ID', null))
166: and paa6.assignment_id = asg.assignment_id
167: and paa6.action_status in ('C', 'S')) -- Bug 4442484: Include 'S'kipped assacts
168: --

Line 176: from pay_assignment_actions asg

172: p_assignment_id number )
173: IS
174: Select asg.assignment_action_id
175: ,asg.tax_unit_id
176: from pay_assignment_actions asg
177: where asg.payroll_action_id = p_bal_adj_action_id
178: and asg.assignment_id = p_assignment_id
179: and asg.action_status in ('C', 'S') ; -- Bug 4442484: Include 'S'kipped assacts
180: ------------------------------------------------------------------------------------

Line 187: select pay_assignment_actions_s.nextval

183: initialization_code(p_payroll_action_id);
184: --
185: for l_asg in csr_asg(g_pact.payroll_id)
186: loop
187: select pay_assignment_actions_s.nextval
188: into l_locking_action_id
189: from dual;
190: --
191: open csr_bal_asg(g_pact.bal_adj_action_id, l_asg.assignment_id);

Line 247: from pay_assignment_actions paa2,

243: select /*+
244: ordered
245: use_nl(ppa2)
246: */ null
247: from pay_assignment_actions paa2,
248: pay_payroll_actions ppa2,
249: pay_action_classifications pac
250: where paa2.assignment_id = asg.assignment_id
251: and paa2.action_status not in ('C', 'S') -- Bug 4442484: 'S'kipped assact is not an errored one

Line 263: pay_assignment_actions paa4

259: --
260: and exists(
261: select null
262: from pay_payroll_actions ppa4,
263: pay_assignment_actions paa4
264: where paa4.assignment_id = asg.assignment_id
265: and paa4.source_action_id is null
266: and ppa4.payroll_action_id = paa4.payroll_action_id
267: and ppa4.action_type IN ('X','B')

Line 278: pay_assignment_actions paa3

274: --
275: and not exists(
276: select null
277: from pay_payroll_actions ppa3,
278: pay_assignment_actions paa3
279: where paa3.assignment_id = asg.assignment_id
280: and paa3.source_action_id is null
281: and ppa3.payroll_action_id = paa3.payroll_action_id
282: and ppa3.effective_date > ppa.effective_date

Line 292: from pay_assignment_actions paa6

288: -- Include if BA has been processed
289: --
290: and exists (
291: select null
292: from pay_assignment_actions paa6
293: where paa6.payroll_action_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'BAL_ADJ_ACTION_ID', null))
294: and paa6.assignment_id = asg.assignment_id
295: and paa6.action_status in ('C', 'S')) -- Bug 4442484: Include 'S'kipped assacts
296: --

Line 304: from pay_assignment_actions asg

300: p_assignment_id number )
301: IS
302: Select asg.assignment_action_id
303: ,asg.tax_unit_id
304: from pay_assignment_actions asg
305: where asg.payroll_action_id = p_bal_adj_action_id
306: and asg.assignment_id = p_assignment_id
307: and asg.action_status in ('C', 'S'); -- Bug 4442484: Include 'S'kipped assacts
308:

Line 313: select pay_assignment_actions_s.nextval

309: begin
310: initialization_code(p_payroll_action_id);
311: --
312: for l_asg in csr_asg(g_pact.payroll_id) loop
313: select pay_assignment_actions_s.nextval
314: into l_locking_action_id
315: from dual;
316: --
317: open csr_bal_asg(g_pact.bal_adj_action_id, l_asg.assignment_id);

Line 353: from pay_assignment_actions asg

349: p_assignment_action_id number )
350: IS
351: Select asg_b.assignment_action_id
352: ,asg_b.assignment_id
353: from pay_assignment_actions asg
354: ,pay_assignment_actions asg_b
355: where asg_b.payroll_action_id = p_bal_adj_action_id
356: and asg_b.assignment_id = asg.assignment_id
357: and asg.assignment_action_id = p_assignment_action_id

Line 354: ,pay_assignment_actions asg_b

350: IS
351: Select asg_b.assignment_action_id
352: ,asg_b.assignment_id
353: from pay_assignment_actions asg
354: ,pay_assignment_actions asg_b
355: where asg_b.payroll_action_id = p_bal_adj_action_id
356: and asg_b.assignment_id = asg.assignment_id
357: and asg.assignment_action_id = p_assignment_action_id
358: and asg_b.action_status in ('C', 'S') ; -- Bug 4442484: Include 'S'kipped assacts