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 217: , pay_assignment_actions aa

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

Line 263: , pay_assignment_actions aa

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

Line 291: from pay_assignment_actions aa,

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

Line 525: pay_assignment_actions paa

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

Line 611: pay_assignment_actions aa,

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
615: and aa.assignment_id = asg_id