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_DK_SOE dependencies on PAY_PAYROLL_ACTIONS

Line 226: pay_payroll_actions pa

222: l_sql long;
223: l_action_type varchar2(2);
224: cursor periodDates is
225: select action_type from
226: pay_payroll_actions pa
227: , per_time_periods tp
228: , pay_assignment_actions aa
229: where pa.payroll_action_id = aa.payroll_action_id
230: and pa.effective_date = tp.regular_payment_date

Line 251: from pay_payroll_actions pa1

247: ,fnd_date.date_to_displaydate(aa2.end_date) COL06
248: ,fnd_date.date_to_displaydate(tp1.start_date) COL02
249: ,tp1.period_type COL07
250: ,fnd_date.date_to_displaydate(tp1.DEFAULT_DD_DATE) COL08
251: from pay_payroll_actions pa1
252: ,pay_payroll_actions pa2
253: ,per_time_periods tp1
254: ,per_time_periods tp2
255: ,pay_assignment_actions aa1

Line 252: ,pay_payroll_actions pa2

248: ,fnd_date.date_to_displaydate(tp1.start_date) COL02
249: ,tp1.period_type COL07
250: ,fnd_date.date_to_displaydate(tp1.DEFAULT_DD_DATE) COL08
251: from pay_payroll_actions pa1
252: ,pay_payroll_actions pa2
253: ,per_time_periods tp1
254: ,per_time_periods tp2
255: ,pay_assignment_actions aa1
256: ,pay_assignment_actions aa2

Line 275: from pay_payroll_actions pa

271: ,fnd_date.date_to_displaydate(aa.end_date) COL06
272: ,fnd_date.date_to_displaydate(tp.start_date) COL02
273: ,tp.period_type COL07
274: ,fnd_date.date_to_displaydate(tp.DEFAULT_DD_DATE) COL08
275: from pay_payroll_actions pa
276: ,per_time_periods tp
277: ,pay_assignment_actions aa
278: where pa.payroll_action_id = aa.payroll_action_id
279: and pa.effective_date = tp.regular_payment_date

Line 293: from pay_payroll_actions pa

289: ,fnd_date.date_to_displaydate(aa.end_date) COL06
290: ,fnd_date.date_to_displaydate(tp.start_date) COL02
291: ,tp.period_type COL07
292: ,fnd_date.date_to_displaydate(tp.DEFAULT_DD_DATE) COL08
293: from pay_payroll_actions pa
294: ,per_time_periods tp
295: ,pay_assignment_actions aa
296: where pa.payroll_action_id = aa.payroll_action_id
297: and pa.time_period_id = tp.time_period_id

Line 564: from pay_payroll_actions pa

560: , aa.assignment_id
561: , pa.business_group_id
562: , bg.legislation_code
563: , lrl.rule_mode
564: from pay_payroll_actions pa
565: , pay_assignment_actions aa
566: , per_business_groups bg
567: , pay_legislation_rules lrl
568: where aa.assignment_action_id = p_assignment_action_id

Line 602: , pay_payroll_actions pa

598: , rb.SOURCE_NUMBER
599: , rb.SOURCE_TEXT2
600: from pay_run_balances rb
601: , pay_assignment_actions aa
602: , pay_payroll_actions pa
603: where rb.ASSIGNMENT_ID = l_assignment_id
604: and l_action_sequence >= aa.action_sequence
605: and rb.assignment_action_id = aa.assignment_action_id
606: and aa.payroll_action_id = pa.payroll_action_id

Line 635: pay_payroll_actions pa,

631: 'Y', pay_balance_pkg.find_context('ORGANIZATION_ID'
632: ,rr.run_result_id)
633: ,null) organization_id
634: from pay_assignment_actions aa,
635: pay_payroll_actions pa,
636: pay_run_results rr
637: where aa.ASSIGNMENT_ID = l_assignment_id
638: and aa.assignment_action_id = rr.assignment_action_id
639: and l_action_sequence >= aa.action_sequence

Line 654: FROM pay_payroll_actions pa

650: l_org_name VARCHAR(80);
651:
652: CURSOR csr_get_params( p_assignment_action_id NUMBER) IS
653: SELECT '''' || bg.currency_code || '''' currency_code
654: FROM pay_payroll_actions pa
655: , pay_assignment_actions aa
656: , per_business_groups bg
657: WHERE aa.assignment_action_id = p_assignment_action_id
658: AND aa.payroll_action_id = pa.payroll_action_id