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_ASSIGNMENT_ACTIONS

Line 338: from pay_assignment_actions asa

334: and asg.effective_end_date >= p_validation_start_date;
335: --
336: cursor csr_any_future_asas is
337: select null
338: from pay_assignment_actions asa
339: ,pay_payroll_actions pra
340: ,per_all_assignments_f paf
341: where asa.assignment_id = p_assignment_id
342: and pra.payroll_action_id = asa.payroll_action_id

Line 3079: -- - PAY_ASSIGNMENT_ACTIONS

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
3081: -- - PER_COBRA_COVERAGE_BENEFITS_F
3082: -- - PER_ASSIGNMENTS_EXTRA_INFO
3083: -- - HR_ASSIGNMENT_SET_AMENDMENTS

Line 3161: cursor csr_pay_assignment_actions is

3157: and (p_datetrack_mode = 'ZAP'
3158: or (p_datetrack_mode = 'DELETE'
3159: and effective_start_date > p_validation_start_date)));
3160: --
3161: cursor csr_pay_assignment_actions is
3162: select null
3163: from sys.dual
3164: where exists(select null
3165: from pay_assignment_actions aa

Line 3165: from pay_assignment_actions aa

3161: cursor csr_pay_assignment_actions is
3162: select null
3163: from sys.dual
3164: where exists(select null
3165: from pay_assignment_actions aa
3166: , pay_payroll_actions pa
3167: where aa.assignment_id = p_assignment_id
3168: and pa.payroll_action_id = aa.payroll_action_id
3169: and (p_datetrack_mode = 'ZAP'

Line 3291: open csr_pay_assignment_actions;

3287: -- Check that no child records exist for the
3288: -- assignment on pay_payroll_actions when
3289: -- the assignment is deleted
3290: --
3291: open csr_pay_assignment_actions;
3292: fetch csr_pay_assignment_actions into l_exists;
3293: if csr_pay_assignment_actions%found then
3294: close csr_pay_assignment_actions;
3295: hr_utility.set_message(801,'HR_7403_ASG_NO_DEL_PAYROLL_ACT');

Line 3292: fetch csr_pay_assignment_actions into l_exists;

3288: -- assignment on pay_payroll_actions when
3289: -- the assignment is deleted
3290: --
3291: open csr_pay_assignment_actions;
3292: fetch csr_pay_assignment_actions into l_exists;
3293: if csr_pay_assignment_actions%found then
3294: close csr_pay_assignment_actions;
3295: hr_utility.set_message(801,'HR_7403_ASG_NO_DEL_PAYROLL_ACT');
3296: hr_utility.raise_error;

Line 3293: if csr_pay_assignment_actions%found then

3289: -- the assignment is deleted
3290: --
3291: open csr_pay_assignment_actions;
3292: fetch csr_pay_assignment_actions into l_exists;
3293: if csr_pay_assignment_actions%found then
3294: close csr_pay_assignment_actions;
3295: hr_utility.set_message(801,'HR_7403_ASG_NO_DEL_PAYROLL_ACT');
3296: hr_utility.raise_error;
3297: end if;

Line 3294: close csr_pay_assignment_actions;

3290: --
3291: open csr_pay_assignment_actions;
3292: fetch csr_pay_assignment_actions into l_exists;
3293: if csr_pay_assignment_actions%found then
3294: close csr_pay_assignment_actions;
3295: hr_utility.set_message(801,'HR_7403_ASG_NO_DEL_PAYROLL_ACT');
3296: hr_utility.raise_error;
3297: end if;
3298: close csr_pay_assignment_actions;

Line 3298: close csr_pay_assignment_actions;

3294: close csr_pay_assignment_actions;
3295: hr_utility.set_message(801,'HR_7403_ASG_NO_DEL_PAYROLL_ACT');
3296: hr_utility.raise_error;
3297: end if;
3298: close csr_pay_assignment_actions;
3299: --
3300: hr_utility.set_location(l_proc, 6);
3301: --
3302: -- Check that no child records exist for the