[Home] [Help]
2351: and rpaa.assignment_id = p_assignment_id
2352: and rpaa.action_sequence =
2353: (select max(aa.action_sequence)
2354: from pay_assignment_actions aa,
2355: pay_action_interlocks loc
2356: where loc.locked_action_id = aa.assignment_action_id
2357: and loc.locking_action_id = paa.assignment_action_id);
2358:
2359: -- Copied from HR_GBBAL.get_latest_action_id, include action type P and U
2390:
2391: cursor csr_formula_5(p_assig_act_id NUMBER) is
2392: select assact.assignment_action_id
2393: from pay_assignment_actions assact,
2394: pay_action_interlocks loc
2395: where loc.locking_action_id = p_assignment_action_id
2396: and assact.assignment_action_id = loc.locked_action_id
2397: order by assact.action_sequence desc;
2398:
2460: cursor csr_formula_2 is
2461: -- for prepayment action find the latest interlocked run
2462: select assact.assignment_action_id
2463: from pay_assignment_actions assact,
2464: pay_action_interlocks loc
2465: where loc.locking_action_id = p_assignment_action_id
2466: and assact.assignment_action_id = loc.locked_action_id
2467: order by assact.action_sequence desc
2468: ;
2470: -- for run action check if its been prepaid
2471: select assact.assignment_action_id
2472: from pay_assignment_actions assact,
2473: pay_payroll_actions pact,
2474: pay_action_interlocks loc
2475: where loc.locked_action_id = p_assignment_action_id
2476: and assact.assignment_action_id = loc.locking_action_id
2477: and pact.payroll_action_id = assact.payroll_action_id
2478: and pact.action_type in ('P','U') /* prepayments only */
2555: -- or ( ppa.action_type in ('P', 'U')
2556: -- and rpaa.action_sequence =
2557: -- (select max(aa.action_sequence)
2558: -- from pay_assignment_actions aa,
2559: -- pay_action_interlocks loc
2560: -- where loc.locked_action_id = aa.assignment_action_id
2561: -- and loc.locking_action_id = p_assignment_action_id)))
2562: --;
2563: --