APPS.PAY_AE_SOE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 117: , pay_assignment_actions aa

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

Line 130: , pay_assignment_actions aa

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

Line 182: , pay_assignment_actions aa

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

Line 210: from pay_assignment_actions aa,

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

Line 468: , pay_assignment_actions aa

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.payroll_id = tp.payroll_id
472: and aa.assignment_action_id = p_assignment_action_id;

Line 492: ,pay_assignment_actions aa1

488: from pay_payroll_actions pa1
489: ,pay_payroll_actions pa2
490: ,per_time_periods tp1
491: ,per_time_periods tp2
492: ,pay_assignment_actions aa1
493: ,pay_assignment_actions aa2
494: ,pay_all_payrolls_f ppf
495: where pa1.payroll_action_id = aa1.payroll_action_id
496: and pa1.effective_date = tp1.regular_payment_date

Line 493: ,pay_assignment_actions aa2

489: ,pay_payroll_actions pa2
490: ,per_time_periods tp1
491: ,per_time_periods tp2
492: ,pay_assignment_actions aa1
493: ,pay_assignment_actions aa2
494: ,pay_all_payrolls_f ppf
495: where pa1.payroll_action_id = aa1.payroll_action_id
496: and pa1.effective_date = tp1.regular_payment_date
497: and pa1.payroll_id = tp1.payroll_id

Line 517: ,pay_assignment_actions aa

513: ,tp.period_type COL07
514: ,ppf.payroll_name COL10
515: from pay_payroll_actions pa
516: ,per_time_periods tp
517: ,pay_assignment_actions aa
518: , pay_all_payrolls_f ppf
519: where pa.payroll_action_id = aa.payroll_action_id
520: and pa.effective_date = tp.regular_payment_date
521: and pa.payroll_id = tp.payroll_id

Line 538: ,pay_assignment_actions aa

534: ,tp.period_type COL07
535: ,ppf.payroll_name COL10
536: from pay_payroll_actions pa
537: ,per_time_periods tp
538: ,pay_assignment_actions aa
539: ,pay_all_payrolls_f ppf
540: where pa.payroll_action_id = aa.payroll_action_id
541: and pa.payroll_id = ppf.payroll_id
542: and pa.effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 602: from pay_assignment_actions aa

598: , nvl(ettl.reporting_name,ettl.element_name) || pay_ae_soe.ae_loan_type(rr.assignment_action_id ,rr.run_result_id,:effective_date ) COL02
599: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
600: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
601: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
602: from pay_assignment_actions aa
603: , pay_run_results rr
604: , pay_run_result_values rrv
605: , pay_input_values_f iv
606: , pay_input_values_f_tl ivtl