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 1283: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

1279: --
1280: l_api_updating boolean;
1281: l_exists varchar2(1);
1282: l_proc varchar2(72):= g_package||'chk_period_of_service_id';
1283: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
1284: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1285: --
1286: cursor csr_valid_pds is
1287: select business_group_id, actual_termination_date

Line 1288: from per_periods_of_service

1284: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1285: --
1286: cursor csr_valid_pds is
1287: select business_group_id, actual_termination_date
1288: from per_periods_of_service
1289: where period_of_service_id = p_period_of_service_id
1290: and p_validation_start_date
1291: between date_start
1292: and nvl(actual_termination_date, hr_api.g_eot);