[Home] [Help]
113: , pa.business_group_id
114: , bg.legislation_code
115: , lrl.rule_mode
116: from pay_payroll_actions pa
117: , pay_assignment_actions aa
118: , per_business_groups bg
119: , pay_legislation_rules lrl
120: where aa.assignment_action_id = p_assignment_action_id
121: and aa.payroll_action_id = pa.payroll_action_id
126: --
127: cursor getParameters(c_assignment_action_id in number) is
128: select '''' || bg.currency_code || '''' currency_code
129: from pay_payroll_actions pa
130: , pay_assignment_actions aa
131: , per_business_groups bg
132: where aa.assignment_action_id = p_assignment_action_id
133: and aa.payroll_action_id = pa.payroll_action_id
134: and pa.business_group_id = bg.business_group_id
178: , rb.SOURCE_TEXT
179: , rb.SOURCE_NUMBER
180: , rb.SOURCE_TEXT2
181: from pay_run_balances rb
182: , pay_assignment_actions aa
183: , pay_payroll_actions pa
184: where rb.ASSIGNMENT_ID = l_assignment_id
185: and l_action_sequence >= aa.action_sequence
186: and rb.assignment_action_id = aa.assignment_action_id
206: , decode(l_st2_needed_chr,
207: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
208: ,rr.run_result_id)
209: ,null) source_text2
210: from pay_assignment_actions aa,
211: pay_payroll_actions pa,
212: pay_run_results rr
213: where aa.ASSIGNMENT_ID = l_assignment_id
214: and aa.assignment_action_id = rr.assignment_action_id
464: cursor periodDates is
465: select action_type from
466: pay_payroll_actions pa
467: , per_time_periods tp
468: , pay_assignment_actions aa
469: where pa.payroll_action_id = aa.payroll_action_id
470: --and pa.effective_date = tp.regular_payment_date
471: and pa.date_earned between tp.start_date and tp.end_date /* 9178309 */
472: and pa.payroll_id = tp.payroll_id
489: from pay_payroll_actions pa1
490: ,pay_payroll_actions pa2
491: ,per_time_periods tp1
492: ,per_time_periods tp2
493: ,pay_assignment_actions aa1
494: ,pay_assignment_actions aa2
495: ,pay_all_payrolls_f ppf
496: where pa1.payroll_action_id = aa1.payroll_action_id
497: --and pa1.effective_date = tp1.regular_payment_date
490: ,pay_payroll_actions pa2
491: ,per_time_periods tp1
492: ,per_time_periods tp2
493: ,pay_assignment_actions aa1
494: ,pay_assignment_actions aa2
495: ,pay_all_payrolls_f ppf
496: where pa1.payroll_action_id = aa1.payroll_action_id
497: --and pa1.effective_date = tp1.regular_payment_date
498: and pa1.payroll_id = tp1.payroll_id
516: ,tp.period_type COL07
517: ,ppf.payroll_name COL10
518: from pay_payroll_actions pa
519: ,per_time_periods tp
520: ,pay_assignment_actions aa
521: , pay_all_payrolls_f ppf
522: where pa.payroll_action_id = aa.payroll_action_id
523: --and pa.effective_date = tp.regular_payment_date
524: and pa.payroll_id = tp.payroll_id
538: ,tp.period_type COL07
539: ,ppf.payroll_name COL10
540: from pay_payroll_actions pa
541: ,per_time_periods tp
542: ,pay_assignment_actions aa
543: ,pay_all_payrolls_f ppf
544: where pa.payroll_action_id = aa.payroll_action_id
545: and pa.payroll_id = ppf.payroll_id
546: and pa.effective_date between ppf.effective_start_date and ppf.effective_end_date
604: , nvl(ettl.reporting_name,ettl.element_name) || pay_ae_soe.ae_loan_type(rr.assignment_action_id ,rr.run_result_id,:effective_date ) COL02
605: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
606: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
607: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
608: from pay_assignment_actions aa
609: , pay_run_results rr
610: , pay_run_result_values rrv
611: , pay_input_values_f iv
612: , pay_input_values_f_tl ivtl