[Home] [Help]
64: and rpaa.assignment_id = p_assignment_id
65: and rpaa.action_sequence =
66: (select max(aa.action_sequence)
67: from pay_assignment_actions aa,
68: pay_action_interlocks loc
69: where loc.locked_action_id = aa.assignment_action_id
70: and aa.source_action_id is null
71: and loc.locking_action_id = paa.assignment_action_id); */
72:
89: and rpaa.assignment_id = p_assignment_id
90: and rpaa.action_sequence =
91: (select max(aa.action_sequence)
92: from pay_assignment_actions aa,
93: pay_action_interlocks loc
94: where loc.locked_action_id = aa.assignment_action_id
95: and aa.source_action_id is null
96: and loc.locking_action_id = paa.assignment_action_id);
97: */
98: cursor cur_lat_action( curvar2 number)is
99: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
100: paa.assignment_action_id),16))
101: from pay_assignment_actions paa,
102: pay_action_interlocks loc
103: where loc.locked_action_id = paa.assignment_action_id
104: and paa.source_action_id IS NULL
105: and loc.locking_action_id = curvar2;
106:
274: cursor csr_formula_2 is
275: -- for prepayment action find the latest interlocked run
276: select assact.assignment_action_id
277: from pay_assignment_actions assact,
278: pay_action_interlocks loc
279: where loc.locking_action_id = p_assignment_action_id
280: and assact.assignment_action_id = loc.locked_action_id
281: and assact.source_action_id is null
282: --order by loc.locked_action_id desc ;
285: -- for run action check if its been prepaid
286: select assact.assignment_action_id
287: from pay_assignment_actions assact,
288: pay_payroll_actions pact,
289: pay_action_interlocks loc
290: where loc.locked_action_id = p_assignment_action_id
291: and assact.assignment_action_id = loc.locking_action_id
292: and pact.payroll_action_id = assact.payroll_action_id
293: and pact.action_type in ('P','U') /* prepayments only */