APPS.PAY_KW_SOE dependencies on PAY_PAYROLL_ACTIONS

Line 111: from pay_payroll_actions pa

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

Line 124: from pay_payroll_actions pa

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

Line 178: , pay_payroll_actions pa

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

Line 206: pay_payroll_actions pa,

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

Line 456: pay_payroll_actions pa

452: --
453: l_action_type varchar2(2);
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

Line 478: from pay_payroll_actions pa1

474: ,fnd_date.date_to_displaydate(aa2.end_date) COL06
475: ,fnd_date.date_to_displaydate(tp1.start_date) COL02
476: ,tp1.period_type COL07
477: , ppf.payroll_name COL10
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

Line 479: ,pay_payroll_actions pa2

475: ,fnd_date.date_to_displaydate(tp1.start_date) COL02
476: ,tp1.period_type COL07
477: , ppf.payroll_name COL10
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

Line 505: from pay_payroll_actions pa

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

Line 526: from pay_payroll_actions pa

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