DBA Data[Home] [Help]

APPS.PAY_MIX_ROLLBACK_PKG dependencies on PAY_RUN_RESULTS

Line 884: from pay_run_results prr,

880: hr_utility.set_location('pay_mix_rollback_pkg.run_results_exist',10);
881:
882: if p_chk_rollback_upd = 'Y' then
883: select 'Y' into l_results_found
884: from pay_run_results prr,
885: pay_assignment_actions paa,
886: pay_payroll_actions ppa,
887: pay_element_entries_f pee
888: where prr.source_type = 'E'

Line 900: from pay_run_results

896: and ppa.date_earned between pee.effective_start_date
897: and pee.effective_end_date ;
898: else
899: select 'Y' into l_results_found
900: from pay_run_results
901: where source_type = 'E'
902: and source_id = p_element_entry_id
903: and status = 'P';
904: end if;