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

Line 118: pay_assignment_actions act,

114: act1.assignment_action_id prepaid_action_id
115: FROM pay_payroll_actions ppa,
116: pay_payroll_actions appa,
117: pay_payroll_actions appa2,
118: pay_assignment_actions act,
119: pay_assignment_actions act1,
120: pay_action_interlocks pai,
121: per_all_assignments_f as1
122: WHERE ppa.payroll_action_id = p_pact_id

Line 119: pay_assignment_actions act1,

115: FROM pay_payroll_actions ppa,
116: pay_payroll_actions appa,
117: pay_payroll_actions appa2,
118: pay_assignment_actions act,
119: pay_assignment_actions act1,
120: pay_action_interlocks pai,
121: per_all_assignments_f as1
122: WHERE ppa.payroll_action_id = p_pact_id
123: AND appa2.consolidation_set_id = p_consolidation_id

Line 143: pay_assignment_actions act2,

139: AND appa2.action_type IN ('P','U') -- Prepayments or Quickpay Prepayments
140: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
141: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
142: FROM pay_action_interlocks pai1,
143: pay_assignment_actions act2,
144: pay_payroll_actions appa3
145: WHERE pai1.locked_action_id = act.assignment_action_id
146: AND act2.assignment_action_id = pai1.locking_action_id
147: AND act2.payroll_action_id = appa3.payroll_action_id

Line 213: SELECT pay_assignment_actions_s.NEXTVAL

209: IF l_prepay_action_id <> csr_rec.prepaid_action_id
210:
211: THEN
212:
213: SELECT pay_assignment_actions_s.NEXTVAL
214: INTO l_actid
215: FROM dual;
216:
217: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION

Line 247: l_act_seq pay_assignment_actions.action_sequence%type;

243: p_effective_date in date)
244: return number
245: is
246: l_run_type_id pay_payroll_actions.run_type_id%type;
247: l_act_seq pay_assignment_actions.action_sequence%type;
248: begin
249: --
250: select run_type_id
251: into l_run_type_id

Line 261: from pay_assignment_actions

257: */
258: if (l_run_type_id is null) then
259: select action_sequence
260: into l_act_seq
261: from pay_assignment_actions
262: where assignment_action_id = p_assignment_action_id;
263: else
264: SELECT MAX(paa1.action_sequence)
265: into l_act_seq

Line 266: FROM pay_assignment_actions paa1,

262: where assignment_action_id = p_assignment_action_id;
263: else
264: SELECT MAX(paa1.action_sequence)
265: into l_act_seq
266: FROM pay_assignment_actions paa1,
267: pay_assignment_actions paa2,
268: pay_run_types_f prt1
269: WHERE prt1.run_type_id = paa1.run_type_id
270: AND prt1.run_method IN ('N','P')

Line 267: pay_assignment_actions paa2,

263: else
264: SELECT MAX(paa1.action_sequence)
265: into l_act_seq
266: FROM pay_assignment_actions paa1,
267: pay_assignment_actions paa2,
268: pay_run_types_f prt1
269: WHERE prt1.run_type_id = paa1.run_type_id
270: AND prt1.run_method IN ('N','P')
271: AND paa1.payroll_action_id = p_payroll_action_id

Line 308: pay_assignment_actions assact,

304: FROM pay_action_interlocks pre,
305: pay_action_interlocks pay,
306: pay_payroll_actions paa,
307: pay_payroll_actions ppaa,
308: pay_assignment_actions assact,
309: pay_assignment_actions passact
310: WHERE pre.locked_action_id = pay.locking_action_id
311: AND pre.locking_action_id = p_locking_action_id
312: AND pre.locked_action_id = passact.assignment_action_id

Line 309: pay_assignment_actions passact

305: pay_action_interlocks pay,
306: pay_payroll_actions paa,
307: pay_payroll_actions ppaa,
308: pay_assignment_actions assact,
309: pay_assignment_actions passact
310: WHERE pre.locked_action_id = pay.locking_action_id
311: AND pre.locking_action_id = p_locking_action_id
312: AND pre.locked_action_id = passact.assignment_action_id
313: AND passact.payroll_action_id = ppaa.payroll_action_id

Line 326: FROM pay_assignment_actions paa,

322: p_assignment_id NUMBER,
323: p_effective_date DATE ) IS
324: SELECT paa.assignment_action_id child_assignment_action_id,
325: 'S' run_type
326: FROM pay_assignment_actions paa,
327: pay_run_types_f prt
328: WHERE paa.source_action_id = p_master_assignment_action
329: AND paa.payroll_action_id = p_payroll_action_id
330: AND paa.assignment_id = p_assignment_id

Line 338: FROM pay_assignment_actions paa

334: prt.effective_start_date AND prt.effective_end_date
335: UNION
336: SELECT paa.assignment_action_id child_assignment_action_id,
337: 'NP' run_type
338: FROM pay_assignment_actions paa
339: WHERE paa.payroll_action_id = p_payroll_action_id
340: AND paa.assignment_id = p_assignment_id
341: AND paa.action_sequence =
342: pay_core_payslip_utils.get_max_nor_act_seq(p_payroll_action_id,

Line 352: FROM pay_assignment_actions paa,

348: p_assignment_id NUMBER,
349: p_effective_date DATE) IS
350: SELECT paa.assignment_action_id np_assignment_action_id,
351: prt.run_method
352: FROM pay_assignment_actions paa,
353: pay_run_types_f prt
354: WHERE paa.source_action_id = p_assignment_action_id
355: AND paa.payroll_action_id = p_payroll_action_id
356: AND paa.assignment_id = p_assignment_id

Line 364: FROM pay_assignment_actions paa,

360: prt.effective_start_date AND prt.effective_end_date
361: UNION
362: SELECT paa.assignment_action_id np_assignment_action_id,
363: 'N'
364: FROM pay_assignment_actions paa,
365: pay_payroll_actions ppa
366: WHERE paa.assignment_action_id = p_assignment_action_id
367: AND ppa.payroll_action_id = p_payroll_action_id
368: AND ppa.payroll_action_id = paa.payroll_action_id

Line 386: l_standard_asg_act_id pay_assignment_actions.assignment_action_id%type;

382: l_sequence NUMBER;
383:
384: l_proc VARCHAR2(50) := g_package || 'archive_code';
385:
386: l_standard_asg_act_id pay_assignment_actions.assignment_action_id%type;
387: l_pactid pay_assignment_actions.payroll_action_id%type;
388:
389: BEGIN
390:

Line 387: l_pactid pay_assignment_actions.payroll_action_id%type;

383:
384: l_proc VARCHAR2(50) := g_package || 'archive_code';
385:
386: l_standard_asg_act_id pay_assignment_actions.assignment_action_id%type;
387: l_pactid pay_assignment_actions.payroll_action_id%type;
388:
389: BEGIN
390:
391: hr_utility.set_location('Entering '|| l_proc,10);

Line 402: FROM pay_assignment_actions paa

398: SELECT paa.chunk_number,
399: paa.payroll_action_id
400: INTO l_chunk_number,
401: l_pactid
402: FROM pay_assignment_actions paa
403: WHERE paa.assignment_action_id = p_assactid;
404:
405: l_standard_asg_act_id := null;
406:

Line 439: SELECT pay_assignment_actions_s.NEXTVAL

435: IF csr_child_rec.run_type = 'S'
436:
437: THEN
438:
439: SELECT pay_assignment_actions_s.NEXTVAL
440: INTO l_actid
441: FROM dual;
442:
443: hr_utility.set_location('csr_child_rec.run_type = ' ||

Line 476: SELECT pay_assignment_actions_s.NEXTVAL

472: THEN
473:
474: if (l_standard_asg_act_id is null) then
475: --
476: SELECT pay_assignment_actions_s.NEXTVAL
477: INTO l_actid
478: FROM dual;
479:
480: hr_utility.set_location('csr_child_rec.run_type = ' ||