[Home] [Help]
535: c_indent varchar2(40);
536: purge_rr boolean;
537: cursor crrv is
538: select prr.run_result_id
539: from pay_run_results prr
540: where prr.assignment_action_id = p_info.assact_id;
541: begin
542: -- Delete any run results and values created by
543: -- this action. There is no cascade trigger on
567: --
568: if g_debug then
569: hr_utility.set_location(c_indent,30);
570: end if;
571: delete from pay_run_results RR
572: where RR.assignment_action_id = p_info.assact_id;
573: --
574: else
575: --
576: if g_debug then
577: hr_utility.set_location(c_indent,40);
578: end if;
579: -- It must be a backpay.
580: update pay_run_results RR
581: set RR.status = 'B'
582: where RR.assignment_action_id = p_info.assact_id;
583: end if;
584: end remove_run_results;
628: from pay_person_latest_balances plb,
629: pay_defined_balances pdb,
630: pay_balance_feeds_f pbf,
631: pay_run_result_values rrv,
632: pay_run_results prr
633: where prr.assignment_action_id = p_info.assact_id
634: and rrv.run_result_id = prr.run_result_id
635: and rrv.result_value is not null
636: and pbf.input_value_id = rrv.input_value_id
651: from pay_assignment_latest_balances alb,
652: pay_defined_balances pdb,
653: pay_balance_feeds_f pbf,
654: pay_run_result_values rrv,
655: pay_run_results prr
656: where prr.assignment_action_id = p_info.assact_id
657: and rrv.run_result_id = prr.run_result_id
658: and rrv.result_value is not null
659: and pbf.input_value_id = rrv.input_value_id
675: from pay_latest_balances lb,
676: pay_defined_balances pdb,
677: pay_balance_feeds_f pbf,
678: pay_run_result_values rrv,
679: pay_run_results prr
680: where prr.assignment_action_id = p_info.assact_id
681: and rrv.run_result_id = prr.run_result_id
682: and rrv.result_value is not null
683: and pbf.input_value_id = rrv.input_value_id