[Home] [Help]
418: nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbf.scale),0)
419: from pay_balance_feeds_f pbf,
420: pay_run_result_values prrv,
421: pay_run_results prr,
422: (select /*+ INDEX(ppa PAY_PAYROLL_ACTIONS_N5) */
423: paa.assignment_action_id assignment_action_id,
424: ppa.effective_date effective_date
425: from
426: -- per_time_periods ptp,
425: from
426: -- per_time_periods ptp,
427: per_assignment_status_types past,
428: per_assignments_f pa,
429: pay_payroll_actions ppa,
430: pay_run_types_f prt,
431: pay_assignment_actions paa
432: where paa.assignment_id = p_assignment_id
433: and paa.action_status = 'C'
552: ptp.end_date target_end_date
553: from per_time_periods ptp,
554: per_assignment_status_types past,
555: per_assignments_f pa,
556: pay_payroll_actions ppa,
557: pay_run_types_f prt,
558: pay_assignment_actions paa,
559: -- per_time_periods bptp,
560: pay_payroll_actions bppa,
556: pay_payroll_actions ppa,
557: pay_run_types_f prt,
558: pay_assignment_actions paa,
559: -- per_time_periods bptp,
560: pay_payroll_actions bppa,
561: pay_assignment_actions bpaa
562: where bpaa.assignment_action_id = p_assignment_action_id
563: and bppa.payroll_action_id = bpaa.payroll_action_id
564: -- and bptp.time_period_id = bppa.time_period_id
591: 'ALR',add_months(bppa.effective_date -1,-12))
592: and ppa.action_type <> 'V'
593: and not exists(
594: select null
595: from pay_payroll_actions rppa,
596: pay_assignment_actions rpaa,
597: pay_action_interlocks pai
598: where pai.locked_action_id = paa.assignment_action_id
599: and rpaa.assignment_action_id = pai.locking_action_id