APPS.PER_ASG_BUS1 dependencies on PER_APPLICATIONS

Line 3393: from per_applications

3389: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3390: --
3391: cursor csr_valid_apl_1 is
3392: select business_group_id
3393: from per_applications
3394: where application_id = p_application_id
3395: and date_received = p_validation_start_date;
3396: --
3397: cursor csr_valid_apl_2 is

Line 3399: from per_applications

3395: and date_received = p_validation_start_date;
3396: --
3397: cursor csr_valid_apl_2 is
3398: select business_group_id
3399: from per_applications
3400: where application_id = p_application_id
3401: and p_validation_start_date
3402: between date_received
3403: and nvl(date_end,hr_api.g_eot);

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

3497: and (not l_api_updating)
3498: and p_assignment_type <> 'O'
3499: then
3500: --
3501: -- Check if the application exists in PER_APPLICATIONS
3502: -- and the application date received is the same as the
3503: -- assignment effective start date.
3504: --
3505: open csr_valid_apl_1;

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

3520: close csr_valid_apl_1;
3521: end if;
3522: else -- not the first applicant assignment
3523: --
3524: -- Check if the application exists in PER_APPLICATIONS
3525: -- and the assignment effective start date is between the
3526: -- date received and the date end of the application when
3527: -- the application date end is set.
3528: --