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 3116: -- - PAY_COST_ALLOCATIONS_F

3112: -- references exist to any of the following tables :
3113: --
3114: -- - PER_EVENTS
3115: -- - PER_LETTER_REQUEST_LINES
3116: -- - PAY_COST_ALLOCATIONS_F
3117: -- - PAY_PAYROLL_ACTIONS
3118: -- - PAY_PERSONAL_PAYMENT_METHODS_F
3119: -- - PAY_ASSIGNMENT_ACTIONS
3120: -- - PER_COBRA_COV_ENROLLMENTS

Line 3181: cursor csr_pay_cost_allocations_f is

3177: or (p_datetrack_mode = 'DELETE'
3178: and date_from > p_validation_start_date)));*/
3179: -- End of 3096114
3180: --
3181: cursor csr_pay_cost_allocations_f is
3182: select null
3183: from sys.dual
3184: where exists(select null
3185: from pay_cost_allocations_f

Line 3185: from pay_cost_allocations_f

3181: cursor csr_pay_cost_allocations_f is
3182: select null
3183: from sys.dual
3184: where exists(select null
3185: from pay_cost_allocations_f
3186: where assignment_id = p_assignment_id
3187: and (p_datetrack_mode = 'ZAP'
3188: or (p_datetrack_mode = 'DELETE'
3189: and effective_start_date > p_validation_start_date)));

Line 3298: -- assignment on pay_cost_allocations_f when

3294: --
3295: hr_utility.set_location(l_proc, 3);
3296: --
3297: -- Check that no child records exist for the
3298: -- assignment on pay_cost_allocations_f when
3299: -- the assignment is deleted
3300: --
3301: open csr_pay_cost_allocations_f;
3302: fetch csr_pay_cost_allocations_f into l_exists;

Line 3301: open csr_pay_cost_allocations_f;

3297: -- Check that no child records exist for the
3298: -- assignment on pay_cost_allocations_f when
3299: -- the assignment is deleted
3300: --
3301: open csr_pay_cost_allocations_f;
3302: fetch csr_pay_cost_allocations_f into l_exists;
3303: if csr_pay_cost_allocations_f%found then
3304: close csr_pay_cost_allocations_f;
3305: hr_utility.set_message(801,'HR_7402_ASG_NO_DEL_COST_ALLOCS');

Line 3302: fetch csr_pay_cost_allocations_f into l_exists;

3298: -- assignment on pay_cost_allocations_f when
3299: -- the assignment is deleted
3300: --
3301: open csr_pay_cost_allocations_f;
3302: fetch csr_pay_cost_allocations_f into l_exists;
3303: if csr_pay_cost_allocations_f%found then
3304: close csr_pay_cost_allocations_f;
3305: hr_utility.set_message(801,'HR_7402_ASG_NO_DEL_COST_ALLOCS');
3306: hr_utility.raise_error;

Line 3303: if csr_pay_cost_allocations_f%found then

3299: -- the assignment is deleted
3300: --
3301: open csr_pay_cost_allocations_f;
3302: fetch csr_pay_cost_allocations_f into l_exists;
3303: if csr_pay_cost_allocations_f%found then
3304: close csr_pay_cost_allocations_f;
3305: hr_utility.set_message(801,'HR_7402_ASG_NO_DEL_COST_ALLOCS');
3306: hr_utility.raise_error;
3307: end if;

Line 3304: close csr_pay_cost_allocations_f;

3300: --
3301: open csr_pay_cost_allocations_f;
3302: fetch csr_pay_cost_allocations_f into l_exists;
3303: if csr_pay_cost_allocations_f%found then
3304: close csr_pay_cost_allocations_f;
3305: hr_utility.set_message(801,'HR_7402_ASG_NO_DEL_COST_ALLOCS');
3306: hr_utility.raise_error;
3307: end if;
3308: close csr_pay_cost_allocations_f;

Line 3308: close csr_pay_cost_allocations_f;

3304: close csr_pay_cost_allocations_f;
3305: hr_utility.set_message(801,'HR_7402_ASG_NO_DEL_COST_ALLOCS');
3306: hr_utility.raise_error;
3307: end if;
3308: close csr_pay_cost_allocations_f;
3309: --
3310: hr_utility.set_location(l_proc, 4);
3311: --
3312: -- Check that no child records exist for the