[Home] [Help]
2752: and rpaa.assignment_id = p_assignment_id
2753: and rpaa.action_sequence =
2754: (select max(aa.action_sequence)
2755: from pay_assignment_actions aa,
2756: pay_action_interlocks loc
2757: where loc.locked_action_id = aa.assignment_action_id
2758: and loc.locking_action_id = paa.assignment_action_id);
2759:
2760: -- Copied from HR_GBBAL.get_latest_action_id, include action type P and U
2791:
2792: cursor csr_formula_5(p_assig_act_id NUMBER) is
2793: select assact.assignment_action_id
2794: from pay_assignment_actions assact,
2795: pay_action_interlocks loc
2796: where loc.locking_action_id = p_assignment_action_id
2797: and assact.assignment_action_id = loc.locked_action_id
2798: order by assact.action_sequence desc;
2799:
2861: cursor csr_formula_2 is
2862: -- for prepayment action find the latest interlocked run
2863: select assact.assignment_action_id
2864: from pay_assignment_actions assact,
2865: pay_action_interlocks loc
2866: where loc.locking_action_id = p_assignment_action_id
2867: and assact.assignment_action_id = loc.locked_action_id
2868: order by assact.action_sequence desc
2869: ;
2871: -- for run action check if its been prepaid
2872: select assact.assignment_action_id
2873: from pay_assignment_actions assact,
2874: pay_payroll_actions pact,
2875: pay_action_interlocks loc
2876: where loc.locked_action_id = p_assignment_action_id
2877: and assact.assignment_action_id = loc.locking_action_id
2878: and pact.payroll_action_id = assact.payroll_action_id
2879: and pact.action_type in ('P','U') /* prepayments only */
2956: -- or ( ppa.action_type in ('P', 'U')
2957: -- and rpaa.action_sequence =
2958: -- (select max(aa.action_sequence)
2959: -- from pay_assignment_actions aa,
2960: -- pay_action_interlocks loc
2961: -- where loc.locked_action_id = aa.assignment_action_id
2962: -- and loc.locking_action_id = p_assignment_action_id)))
2963: --;
2964: --