eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_YEAR_END_EXTRACT dependencies on DUAL

Line 778: from dual;

774: effective_start_date and effective_end_date;
775: --
776: select 10 * pay_run_results_s.nextval
777: into l_max_run_result_id
778: from dual;
779: --
780: select element_type_id into l_ni_id from
781: pay_element_types_f where element_name = 'NI'
782: and l_end_year between

Line 1127: ( select 'D' from dual where exists ( select '1' from

1123: -- was this employee ever a director this year
1124: hr_utility.set_location('PAY_YEAR_END_EXTRACT.EXTRACT',22);
1125: hr_utility.trace( 'set director indicator ' );
1126: update pay_gb_year_end_assignments ye_asg set ( DIRECTOR_INDICATOR ) =
1127: ( select 'D' from dual where exists ( select '1' from
1128: per_people_f per
1129: where ye_asg.person_id = per.person_id
1130: and per.effective_start_date <= l_end_year
1131: and per.effective_end_date >= l_start_year