[Home] [Help]
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
231: and pa.payroll_id = tp.payroll_id
232: and aa.assignment_action_id = p_assignment_action_id;
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
257: where pa1.payroll_action_id = aa1.payroll_action_id
258: and pa1.effective_date = tp1.regular_payment_date
259: and pa1.payroll_id = tp1.payroll_id
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
257: where pa1.payroll_action_id = aa1.payroll_action_id
258: and pa1.effective_date = tp1.regular_payment_date
259: and pa1.payroll_id = tp1.payroll_id
260: and aa1.assignment_action_id = :PREPAY_MAX_ACTION
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
280: and pa.payroll_id = tp.payroll_id
281: and aa.assignment_action_id = :assignment_action_id';
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
298: and aa.assignment_action_id = :assignment_action_id';
299: end if;
413: ,''Retro Employer Pension'','' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )'') COL02
414: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
415: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
416: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
417: from pay_assignment_actions aa
418: , pay_run_results rr
419: , pay_run_result_values rrv
420: , pay_input_values_f iv
421: , pay_input_values_f_tl ivtl
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
569: and aa.payroll_action_id = pa.payroll_action_id
597: , rb.SOURCE_TEXT
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
630: , decode(l_org_needed_chr,
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
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
659: AND pa.business_group_id = bg.business_group_id