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 216: from pay_payroll_actions pa

212: , aa.assignment_id
213: , pa.business_group_id
214: , bg.legislation_code
215: , lrl.rule_mode
216: from pay_payroll_actions pa
217: , pay_assignment_actions aa
218: , per_business_groups bg
219: , pay_legislation_rules lrl
220: where aa.assignment_action_id = p_assignment_action_id

Line 264: , pay_payroll_actions pa

260: , rb.SOURCE_NUMBER
261: , rb.SOURCE_TEXT2
262: from pay_run_balances rb
263: , pay_assignment_actions aa
264: , pay_payroll_actions pa
265: where rb.ASSIGNMENT_ID = l_assignment_id
266: and l_action_sequence >= aa.action_sequence
267: and rb.assignment_action_id = aa.assignment_action_id
268: and aa.payroll_action_id = pa.payroll_action_id

Line 292: pay_payroll_actions pa,

288: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
289: ,rr.run_result_id)
290: ,null) source_text2
291: from pay_assignment_actions aa,
292: pay_payroll_actions pa,
293: pay_run_results rr
294: where aa.ASSIGNMENT_ID = l_assignment_id
295: and aa.assignment_action_id = rr.assignment_action_id
296: and l_action_sequence >= aa.action_sequence

Line 524: from pay_payroll_actions ppa,

520: cursor getInfo is
521: select ppa.date_earned,
522: ppa.payroll_action_id,
523: paa.assignment_id
524: from pay_payroll_actions ppa,
525: pay_assignment_actions paa
526: where paa.assignment_action_id = p_assignment_action_id
527: and paa.payroll_action_id = ppa.payroll_action_id;
528:

Line 532: pay_payroll_actions pact,

528:
529: cursor getTaxPhone(p_payroll_act number) is
530: select max(org_information8)
531: from pay_payrolls_f p,
532: pay_payroll_actions pact,
533: hr_soft_coding_keyflex flex,
534: hr_organization_information org
535: where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
536: and org.org_information_context = 'Tax Details References'

Line 610: from pay_payroll_actions pa,

606: and p_effective_date between effective_start_date and effective_end_date;
607:
608: cursor csr_get_action_id(asg_id number) is
609: select to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
610: from pay_payroll_actions pa,
611: pay_assignment_actions aa,
612: per_time_periods ptp
613: where aa.action_status = 'C'
614: and pa.payroll_action_id = aa.payroll_action_id