APPS.PY_ROLLBACK_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 569: delete from pay_run_result_values rrv

565: end if;
566: --
567: if (purge_rr = TRUE) then
568: for crrvrec in crrv loop
569: delete from pay_run_result_values rrv
570: where rrv.run_result_id = crrvrec.run_result_id;
571: end loop;
572: --
573: if g_debug then

Line 636: pay_run_result_values rrv,

632: plb.assignment_action_id
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

Line 659: pay_run_result_values rrv,

655: alb.assignment_action_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

Line 683: pay_run_result_values rrv,

679: lb.assignment_action_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