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 PAY_COST_ALLOCATIONS_F

Line 3076: -- - PAY_COST_ALLOCATIONS_F

3072: -- references exist to any of the following tables :
3073: --
3074: -- - PER_EVENTS
3075: -- - PER_LETTER_REQUEST_LINES
3076: -- - PAY_COST_ALLOCATIONS_F
3077: -- - PAY_PAYROLL_ACTIONS
3078: -- - PAY_PERSONAL_PAYMENT_METHODS_F
3079: -- - PAY_ASSIGNMENT_ACTIONS
3080: -- - PER_COBRA_COV_ENROLLMENTS

Line 3141: cursor csr_pay_cost_allocations_f is

3137: or (p_datetrack_mode = 'DELETE'
3138: and date_from > p_validation_start_date)));*/
3139: -- End of 3096114
3140: --
3141: cursor csr_pay_cost_allocations_f is
3142: select null
3143: from sys.dual
3144: where exists(select null
3145: from pay_cost_allocations_f

Line 3145: from pay_cost_allocations_f

3141: cursor csr_pay_cost_allocations_f is
3142: select null
3143: from sys.dual
3144: where exists(select null
3145: from pay_cost_allocations_f
3146: where assignment_id = p_assignment_id
3147: and (p_datetrack_mode = 'ZAP'
3148: or (p_datetrack_mode = 'DELETE'
3149: and effective_start_date > p_validation_start_date)));

Line 3258: -- assignment on pay_cost_allocations_f when

3254: --
3255: hr_utility.set_location(l_proc, 3);
3256: --
3257: -- Check that no child records exist for the
3258: -- assignment on pay_cost_allocations_f when
3259: -- the assignment is deleted
3260: --
3261: open csr_pay_cost_allocations_f;
3262: fetch csr_pay_cost_allocations_f into l_exists;

Line 3261: open csr_pay_cost_allocations_f;

3257: -- Check that no child records exist for the
3258: -- assignment on pay_cost_allocations_f when
3259: -- the assignment is deleted
3260: --
3261: open csr_pay_cost_allocations_f;
3262: fetch csr_pay_cost_allocations_f into l_exists;
3263: if csr_pay_cost_allocations_f%found then
3264: close csr_pay_cost_allocations_f;
3265: hr_utility.set_message(801,'HR_7402_ASG_NO_DEL_COST_ALLOCS');

Line 3262: fetch csr_pay_cost_allocations_f into l_exists;

3258: -- assignment on pay_cost_allocations_f when
3259: -- the assignment is deleted
3260: --
3261: open csr_pay_cost_allocations_f;
3262: fetch csr_pay_cost_allocations_f into l_exists;
3263: if csr_pay_cost_allocations_f%found then
3264: close csr_pay_cost_allocations_f;
3265: hr_utility.set_message(801,'HR_7402_ASG_NO_DEL_COST_ALLOCS');
3266: hr_utility.raise_error;

Line 3263: if csr_pay_cost_allocations_f%found then

3259: -- the assignment is deleted
3260: --
3261: open csr_pay_cost_allocations_f;
3262: fetch csr_pay_cost_allocations_f into l_exists;
3263: if csr_pay_cost_allocations_f%found then
3264: close csr_pay_cost_allocations_f;
3265: hr_utility.set_message(801,'HR_7402_ASG_NO_DEL_COST_ALLOCS');
3266: hr_utility.raise_error;
3267: end if;

Line 3264: close csr_pay_cost_allocations_f;

3260: --
3261: open csr_pay_cost_allocations_f;
3262: fetch csr_pay_cost_allocations_f into l_exists;
3263: if csr_pay_cost_allocations_f%found then
3264: close csr_pay_cost_allocations_f;
3265: hr_utility.set_message(801,'HR_7402_ASG_NO_DEL_COST_ALLOCS');
3266: hr_utility.raise_error;
3267: end if;
3268: close csr_pay_cost_allocations_f;

Line 3268: close csr_pay_cost_allocations_f;

3264: close csr_pay_cost_allocations_f;
3265: hr_utility.set_message(801,'HR_7402_ASG_NO_DEL_COST_ALLOCS');
3266: hr_utility.raise_error;
3267: end if;
3268: close csr_pay_cost_allocations_f;
3269: --
3270: hr_utility.set_location(l_proc, 4);
3271: --
3272: -- Check that no child records exist for the