[Home] [Help]
35: amills 115.9 02-MAR-2004 - 3473274. changed get_database_items and
36: get_balance_items to handle NDFs.
37: amills 115.10 02-MAR-2004 - Added nocopy hints.
38: npershad 115.11 14-OCT-2005 - 4428406. Removed reference to redundant index
39: PAY_ASSIGNMENT_ACTIONS_N1 used in hints.
40: rmakhija 115.12 07-NOV-2006 - 5144323, replaced PER_TD_YTD dimension with
41: PER_TD_CPE_YTD
42: */
43:
297: WHERE run_result_id = l_max_run_result_id
298: AND input_value_id = p_ipv_id;
299: --
300: CURSOR csr_max_run_result IS
301: SELECT /*+ ORDERED INDEX (assact2 PAY_ASSIGNMENT_ACTIONS_N51,
302: pact PAY_PAYROLL_ACTIONS_PK,
303: r2 PAY_RUN_RESULTS_N50)
304: USE_NL(assact2, pact, r2) */
305: to_number(substr(max(lpad(assact2.action_sequence,15,'0')||r2.source_type||
303: r2 PAY_RUN_RESULTS_N50)
304: USE_NL(assact2, pact, r2) */
305: to_number(substr(max(lpad(assact2.action_sequence,15,'0')||r2.source_type||
306: r2.run_result_id),17))
307: FROM pay_assignment_actions assact2,
308: pay_payroll_actions pact,
309: pay_run_results r2
310: WHERE assact2.assignment_id = p_assignment_id
311: AND r2.element_type_id+0 = l_paye_element_id
317: AND pact.effective_date <= to_date(p_date_earned,'YYYY/MM/DD')
318: AND NOT EXISTS(
319: SELECT '1'
320: FROM pay_action_interlocks pai,
321: pay_assignment_actions assact3,
322: pay_payroll_actions pact3
323: WHERE pai.locked_action_id = assact2.assignment_action_id
324: AND pai.locking_action_id = assact3.assignment_action_id
325: AND pact3.payroll_action_id = assact3.payroll_action_id