APPS.PAY_GB_ONLINE_SOE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 13: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

9: --- Text : check for pre payment
10: ------------------------------------------------------------------------
11: FUNCTION checkPrepayment(p_assignment_action_id number) return number is
12: l_action_type varchar2(1);
13: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
14: --
15: cursor csr_get_action_type is
16: select pact.action_type
17: from pay_assignment_actions assact,

Line 17: from pay_assignment_actions assact,

13: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
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: --

Line 24: from pay_assignment_actions assact,

20: and pact.payroll_action_id = assact.payroll_action_id;
21: --
22: cursor csr_get_latest_interlocked is
23: select assact.assignment_action_id
24: from pay_assignment_actions assact,
25: pay_action_interlocks loc
26: where loc.locking_action_id = p_assignment_action_id
27: and assact.assignment_action_id = loc.locked_action_id
28: order by assact.action_sequence desc;

Line 222: , pay_assignment_actions aa

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

Line 268: , pay_assignment_actions aa

264: , rb.SOURCE_TEXT
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

Line 296: from pay_assignment_actions aa,

292: , decode(l_st2_needed_chr,
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

Line 530: pay_assignment_actions paa

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:
534: cursor getTaxPhone(p_payroll_act number) is

Line 616: pay_assignment_actions aa,

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