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_BUS1 dependencies on PER_APPLICATIONS

Line 3271: from per_applications

3267: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3268: --
3269: cursor csr_valid_apl_1 is
3270: select business_group_id
3271: from per_applications
3272: where application_id = p_application_id
3273: and date_received = p_validation_start_date;
3274: --
3275: cursor csr_valid_apl_2 is

Line 3277: from per_applications

3273: and date_received = p_validation_start_date;
3274: --
3275: cursor csr_valid_apl_2 is
3276: select business_group_id
3277: from per_applications
3278: where application_id = p_application_id
3279: and p_validation_start_date
3280: between date_received
3281: and nvl(date_end,hr_api.g_eot);

Line 3379: -- Check if the application exists in PER_APPLICATIONS

3375: and (not l_api_updating)
3376: and p_assignment_type <> 'O'
3377: then
3378: --
3379: -- Check if the application exists in PER_APPLICATIONS
3380: -- and the application date received is the same as the
3381: -- assignment effective start date.
3382: --
3383: open csr_valid_apl_1;

Line 3402: -- Check if the application exists in PER_APPLICATIONS

3398: close csr_valid_apl_1;
3399: end if;
3400: else -- not the first applicant assignment
3401: --
3402: -- Check if the application exists in PER_APPLICATIONS
3403: -- and the assignment effective start date is between the
3404: -- date received and the date end of the application when
3405: -- the application date end is set.
3406: --