APPS.PAY_GB_ONLINE_SOE dependencies on PAY_PAYROLL_ACTIONS

Line 18: pay_payroll_actions pact

14: --
15: cursor csr_get_action_type is
16: select pact.action_type
17: from pay_assignment_actions assact,
18: pay_payroll_actions pact
19: where assact.assignment_action_id = p_assignment_action_id
20: and pact.payroll_action_id = assact.payroll_action_id;
21: --
22: cursor csr_get_latest_interlocked is

Line 221: from pay_payroll_actions pa

217: , aa.assignment_id
218: , pa.business_group_id
219: , bg.legislation_code
220: , lrl.rule_mode
221: from pay_payroll_actions pa
222: , pay_assignment_actions aa
223: , per_business_groups bg
224: , pay_legislation_rules lrl
225: where aa.assignment_action_id = p_assignment_action_id

Line 269: , pay_payroll_actions pa

265: , rb.SOURCE_NUMBER
266: , rb.SOURCE_TEXT2
267: from pay_run_balances rb
268: , pay_assignment_actions aa
269: , pay_payroll_actions pa
270: where rb.ASSIGNMENT_ID = l_assignment_id
271: and l_action_sequence >= aa.action_sequence
272: and rb.assignment_action_id = aa.assignment_action_id
273: and aa.payroll_action_id = pa.payroll_action_id

Line 297: pay_payroll_actions pa,

293: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
294: ,rr.run_result_id)
295: ,null) source_text2
296: from pay_assignment_actions aa,
297: pay_payroll_actions pa,
298: pay_run_results rr
299: where aa.ASSIGNMENT_ID = l_assignment_id
300: and aa.assignment_action_id = rr.assignment_action_id
301: and l_action_sequence >= aa.action_sequence

Line 529: from pay_payroll_actions ppa,

525: cursor getInfo is
526: select ppa.date_earned,
527: ppa.payroll_action_id,
528: paa.assignment_id
529: from pay_payroll_actions ppa,
530: pay_assignment_actions paa
531: where paa.assignment_action_id = p_assignment_action_id
532: and paa.payroll_action_id = ppa.payroll_action_id;
533:

Line 537: pay_payroll_actions pact,

533:
534: cursor getTaxPhone(p_payroll_act number) is
535: select max(org_information8)
536: from pay_payrolls_f p,
537: pay_payroll_actions pact,
538: hr_soft_coding_keyflex flex,
539: hr_organization_information org
540: where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
541: and org.org_information_context = 'Tax Details References'

Line 615: from pay_payroll_actions pa,

611: and p_effective_date between effective_start_date and effective_end_date;
612:
613: cursor csr_get_action_id(asg_id number) is
614: select to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
615: from pay_payroll_actions pa,
616: pay_assignment_actions aa,
617: per_time_periods ptp
618: where aa.action_status in ('C','S') --Modified for the bug 10066755
619: --where aa.action_status = 'C'