APPS.PAY_KW_SOE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 112: , pay_assignment_actions aa

108: , pa.business_group_id
109: , bg.legislation_code
110: , lrl.rule_mode
111: from pay_payroll_actions pa
112: , pay_assignment_actions aa
113: , per_business_groups bg
114: , pay_legislation_rules lrl
115: where aa.assignment_action_id = p_assignment_action_id
116: and aa.payroll_action_id = pa.payroll_action_id

Line 125: , pay_assignment_actions aa

121: --
122: cursor getParameters(c_assignment_action_id in number) is
123: select '''' || bg.currency_code || '''' currency_code
124: from pay_payroll_actions pa
125: , pay_assignment_actions aa
126: , per_business_groups bg
127: where aa.assignment_action_id = p_assignment_action_id
128: and aa.payroll_action_id = pa.payroll_action_id
129: and pa.business_group_id = bg.business_group_id

Line 177: , pay_assignment_actions aa

173: , rb.SOURCE_TEXT
174: , rb.SOURCE_NUMBER
175: , rb.SOURCE_TEXT2
176: from pay_run_balances rb
177: , pay_assignment_actions aa
178: , pay_payroll_actions pa
179: where rb.ASSIGNMENT_ID = l_assignment_id
180: and l_action_sequence >= aa.action_sequence
181: and rb.assignment_action_id = aa.assignment_action_id

Line 205: from pay_assignment_actions aa,

201: , decode(l_st2_needed_chr,
202: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
203: ,rr.run_result_id)
204: ,null) source_text2
205: from pay_assignment_actions aa,
206: pay_payroll_actions pa,
207: pay_run_results rr
208: where aa.ASSIGNMENT_ID = l_assignment_id
209: and aa.assignment_action_id = rr.assignment_action_id

Line 458: , pay_assignment_actions aa

454: cursor periodDates is
455: select action_type from
456: pay_payroll_actions pa
457: , per_time_periods tp
458: , pay_assignment_actions aa
459: where pa.payroll_action_id = aa.payroll_action_id
460: and pa.effective_date = tp.regular_payment_date
461: and pa.payroll_id = tp.payroll_id
462: and aa.assignment_action_id = p_assignment_action_id;

Line 482: ,pay_assignment_actions aa1

478: from pay_payroll_actions pa1
479: ,pay_payroll_actions pa2
480: ,per_time_periods tp1
481: ,per_time_periods tp2
482: ,pay_assignment_actions aa1
483: ,pay_assignment_actions aa2
484: ,pay_all_payrolls_f ppf
485: where pa1.payroll_action_id = aa1.payroll_action_id
486: and pa1.effective_date = tp1.regular_payment_date

Line 483: ,pay_assignment_actions aa2

479: ,pay_payroll_actions pa2
480: ,per_time_periods tp1
481: ,per_time_periods tp2
482: ,pay_assignment_actions aa1
483: ,pay_assignment_actions aa2
484: ,pay_all_payrolls_f ppf
485: where pa1.payroll_action_id = aa1.payroll_action_id
486: and pa1.effective_date = tp1.regular_payment_date
487: and pa1.payroll_id = tp1.payroll_id

Line 507: ,pay_assignment_actions aa

503: ,tp.period_type COL07
504: ,ppf.payroll_name COL10
505: from pay_payroll_actions pa
506: ,per_time_periods tp
507: ,pay_assignment_actions aa
508: , pay_all_payrolls_f ppf
509: where pa.payroll_action_id = aa.payroll_action_id
510: and pa.effective_date = tp.regular_payment_date
511: and pa.payroll_id = tp.payroll_id

Line 528: ,pay_assignment_actions aa

524: ,tp.period_type COL07
525: ,ppf.payroll_name COL10
526: from pay_payroll_actions pa
527: ,per_time_periods tp
528: ,pay_assignment_actions aa
529: ,pay_all_payrolls_f ppf
530: where pa.payroll_action_id = aa.payroll_action_id
531: and pa.payroll_id = ppf.payroll_id
532: and pa.effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 592: from pay_assignment_actions aa

588: , nvl(ettl.reporting_name,ettl.element_name) || pay_kw_soe.kw_loan_type(rr.assignment_action_id ,rr.run_result_id,:effective_date ) COL02
589: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
590: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
591: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
592: from pay_assignment_actions aa
593: , pay_run_results rr
594: , pay_run_result_values rrv
595: , pay_input_values_f iv
596: , pay_input_values_f_tl ivtl