[Home] [Help]
540: c_indent varchar2(40);
541: purge_rr boolean;
542: cursor crrv is
543: select prr.run_result_id
544: from pay_run_results prr
545: where prr.assignment_action_id = p_info.assact_id;
546: begin
547: -- Delete any run results and values created by
548: -- this action. There is no cascade trigger on
572: --
573: if g_debug then
574: hr_utility.set_location(c_indent,30);
575: end if;
576: delete from pay_run_results RR
577: where RR.assignment_action_id = p_info.assact_id;
578: --
579: else
580: --
581: if g_debug then
582: hr_utility.set_location(c_indent,40);
583: end if;
584: -- It must be a backpay.
585: update pay_run_results RR
586: set RR.status = 'B'
587: where RR.assignment_action_id = p_info.assact_id;
588: end if;
589: end remove_run_results;
633: from pay_person_latest_balances plb,
634: pay_defined_balances pdb,
635: pay_balance_feeds_f pbf,
636: pay_run_result_values rrv,
637: pay_run_results prr
638: where prr.assignment_action_id = p_info.assact_id
639: and rrv.run_result_id = prr.run_result_id
640: and rrv.result_value is not null
641: and pbf.input_value_id = rrv.input_value_id
656: from pay_assignment_latest_balances alb,
657: pay_defined_balances pdb,
658: pay_balance_feeds_f pbf,
659: pay_run_result_values rrv,
660: pay_run_results prr
661: where prr.assignment_action_id = p_info.assact_id
662: and rrv.run_result_id = prr.run_result_id
663: and rrv.result_value is not null
664: and pbf.input_value_id = rrv.input_value_id
680: from pay_latest_balances lb,
681: pay_defined_balances pdb,
682: pay_balance_feeds_f pbf,
683: pay_run_result_values rrv,
684: pay_run_results prr
685: where prr.assignment_action_id = p_info.assact_id
686: and rrv.run_result_id = prr.run_result_id
687: and rrv.result_value is not null
688: and pbf.input_value_id = rrv.input_value_id