APPS.PY_ROLLBACK_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 564: delete from pay_run_result_values rrv

560: end if;
561: --
562: if (purge_rr = TRUE) then
563: for crrvrec in crrv loop
564: delete from pay_run_result_values rrv
565: where rrv.run_result_id = crrvrec.run_result_id;
566: end loop;
567: --
568: if g_debug then

Line 631: pay_run_result_values rrv,

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

Line 654: pay_run_result_values rrv,

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

Line 678: pay_run_result_values rrv,

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