APPS.PAY_AE_SOE dependencies on PAY_PAYROLL_ACTIONS

Line 116: from pay_payroll_actions pa

112: , aa.assignment_id
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

Line 129: from pay_payroll_actions pa

125: --
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

Line 183: , pay_payroll_actions pa

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
187: and aa.payroll_action_id = pa.payroll_action_id

Line 211: pay_payroll_actions pa,

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
215: and l_action_sequence >= aa.action_sequence

Line 466: pay_payroll_actions pa

462: --
463: l_action_type varchar2(2);
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

Line 489: from pay_payroll_actions pa1

485: ,fnd_date.date_to_displaydate(aa2.end_date) COL06
486: ,fnd_date.date_to_displaydate(tp1.start_date) COL02
487: ,tp1.period_type COL07
488: , ppf.payroll_name COL10
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

Line 490: ,pay_payroll_actions pa2

486: ,fnd_date.date_to_displaydate(tp1.start_date) COL02
487: ,tp1.period_type COL07
488: , ppf.payroll_name COL10
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

Line 518: from pay_payroll_actions pa

514: ,fnd_date.date_to_displaydate(aa.end_date) COL06
515: ,fnd_date.date_to_displaydate(tp.start_date) COL02
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

Line 540: from pay_payroll_actions pa

536: ,fnd_date.date_to_displaydate(aa.end_date) COL06
537: ,fnd_date.date_to_displaydate(tp.start_date) COL02
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