APPS.PAY_MIX_ROLLBACK_PKG dependencies on PAY_RUN_RESULTS

Line 821: from pay_run_results prr,

817: hr_utility.set_location('pay_mix_rollback_pkg.run_results_exist',10);
818:
819: if p_chk_rollback_upd = 'Y' then
820: select 'Y' into l_results_found
821: from pay_run_results prr,
822: pay_assignment_actions paa,
823: pay_payroll_actions ppa,
824: pay_element_entries_f pee
825: where prr.source_type = 'E'

Line 837: from pay_run_results

833: and ppa.date_earned between pee.effective_start_date
834: and pee.effective_end_date ;
835: else
836: select 'Y' into l_results_found
837: from pay_run_results
838: where source_type = 'E'
839: and source_id = p_element_entry_id
840: and status = 'P';
841: end if;