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.PER_ASG_BUS2 dependencies on PER_PERIODS_OF_SERVICE

Line 1243: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

1239: --
1240: l_api_updating boolean;
1241: l_exists varchar2(1);
1242: l_proc varchar2(72):= g_package||'chk_period_of_service_id';
1243: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
1244: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1245: --
1246: cursor csr_valid_pds is
1247: select business_group_id, actual_termination_date

Line 1248: from per_periods_of_service

1244: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1245: --
1246: cursor csr_valid_pds is
1247: select business_group_id, actual_termination_date
1248: from per_periods_of_service
1249: where period_of_service_id = p_period_of_service_id
1250: and p_validation_start_date
1251: between date_start
1252: and nvl(actual_termination_date, hr_api.g_eot);