APPS.PAY_ES_ONLINE_SOE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 135: , pay_assignment_actions aa

131: , pa.business_group_id
132: , bg.legislation_code
133: , lrl.rule_mode
134: FROM pay_payroll_actions pa
135: , pay_assignment_actions aa
136: , per_business_groups bg
137: , pay_legislation_rules lrl
138: WHERE aa.assignment_action_id = p_assignment_action_id
139: AND aa.payroll_action_id = pa.payroll_action_id

Line 147: , pay_assignment_actions aa

143: --
144: CURSOR getParameters(c_assignment_action_id IN NUMBER) IS
145: SELECT '''' || bg.currency_code || '''' currency_code
146: FROM pay_payroll_actions pa
147: , pay_assignment_actions aa
148: , per_business_groups bg
149: WHERE aa.assignment_action_id = p_assignment_action_id
150: AND aa.payroll_action_id = pa.payroll_action_id
151: AND pa.business_group_id = bg.business_group_id

Line 199: , pay_assignment_actions aa

195: , rb.SOURCE_TEXT
196: , rb.SOURCE_NUMBER
197: , rb.SOURCE_TEXT2
198: from pay_run_balances rb
199: , pay_assignment_actions aa
200: , pay_payroll_actions pa
201: where rb.ASSIGNMENT_ID = l_assignment_id
202: and l_action_sequence >= aa.action_sequence
203: and rb.assignment_action_id = aa.assignment_action_id

Line 227: from pay_assignment_actions aa,

223: , decode(l_st2_needed_chr,
224: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
225: ,rr.run_result_id)
226: ,null) source_text2
227: from pay_assignment_actions aa,
228: pay_payroll_actions pa,
229: pay_run_results rr
230: where aa.ASSIGNMENT_ID = l_assignment_id
231: and aa.assignment_action_id = rr.assignment_action_id

Line 418: , pay_assignment_actions aa

414: cursor periodDates IS
415: SELECT action_type
416: FROM pay_payroll_actions pa
417: , per_time_periods tp
418: , pay_assignment_actions aa
419: WHERE pa.payroll_action_id = aa.payroll_action_id
420: AND pa.effective_date = tp.regular_payment_date
421: AND pa.payroll_id = tp.payroll_id
422: AND aa.assignment_action_id = p_assignment_action_id;

Line 447: ,pay_assignment_actions aa1

443: from pay_payroll_actions pa1
444: ,pay_payroll_actions pa2
445: ,per_time_periods tp1
446: ,per_time_periods tp2
447: ,pay_assignment_actions aa1
448: ,pay_assignment_actions aa2
449: ,pay_all_payrolls_f ppf
450: ,pay_run_types_f prtf
451: ,pay_run_types_f_tl prtt

Line 448: ,pay_assignment_actions aa2

444: ,pay_payroll_actions pa2
445: ,per_time_periods tp1
446: ,per_time_periods tp2
447: ,pay_assignment_actions aa1
448: ,pay_assignment_actions aa2
449: ,pay_all_payrolls_f ppf
450: ,pay_run_types_f prtf
451: ,pay_run_types_f_tl prtt
452: where pa1.payroll_action_id = aa1.payroll_action_id

Line 478: ,pay_assignment_actions aa

474: ,ppf.payroll_name COL10
475: ,prtt.RUN_TYPE_NAME COL08
476: from pay_payroll_actions pa
477: ,per_time_periods tp
478: ,pay_assignment_actions aa
479: , pay_all_payrolls_f ppf
480: ,pay_run_types_f prtf
481: ,pay_run_types_f_tl prtt
482: where pa.payroll_action_id = aa.payroll_action_id

Line 505: ,pay_assignment_actions aa

501: ,ppf.payroll_name COL10
502: ,prtt.RUN_TYPE_NAME COL08
503: FROM pay_payroll_actions pa
504: ,per_time_periods tp
505: ,pay_assignment_actions aa
506: ,pay_all_payrolls_f ppf
507: ,pay_run_types_f prtf
508: ,pay_run_types_f_tl prtt
509: WHERE pa.payroll_action_id = aa.payroll_action_id

Line 544: from pay_assignment_actions aa

540: , '' '') COL02
541: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
542: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
543: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
544: from pay_assignment_actions aa
545: , pay_run_results rr
546: , pay_run_result_values rrv
547: , pay_input_values_f iv
548: , pay_input_values_f_tl ivtl