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 3119: -- - PAY_ASSIGNMENT_ACTIONS

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
3121: -- - PER_COBRA_COVERAGE_BENEFITS_F
3122: -- - PER_ASSIGNMENTS_EXTRA_INFO
3123: -- - HR_ASSIGNMENT_SET_AMENDMENTS

Line 3201: cursor csr_pay_assignment_actions is

3197: and (p_datetrack_mode = 'ZAP'
3198: or (p_datetrack_mode = 'DELETE'
3199: and effective_start_date > p_validation_start_date)));
3200: --
3201: cursor csr_pay_assignment_actions is
3202: select null
3203: from sys.dual
3204: where exists(select null
3205: from pay_assignment_actions aa

Line 3205: from pay_assignment_actions aa

3201: cursor csr_pay_assignment_actions is
3202: select null
3203: from sys.dual
3204: where exists(select null
3205: from pay_assignment_actions aa
3206: , pay_payroll_actions pa
3207: where aa.assignment_id = p_assignment_id
3208: and pa.payroll_action_id = aa.payroll_action_id
3209: and (p_datetrack_mode = 'ZAP'

Line 3331: open csr_pay_assignment_actions;

3327: -- Check that no child records exist for the
3328: -- assignment on pay_payroll_actions when
3329: -- the assignment is deleted
3330: --
3331: open csr_pay_assignment_actions;
3332: fetch csr_pay_assignment_actions into l_exists;
3333: if csr_pay_assignment_actions%found then
3334: close csr_pay_assignment_actions;
3335: hr_utility.set_message(801,'HR_7403_ASG_NO_DEL_PAYROLL_ACT');

Line 3332: fetch csr_pay_assignment_actions into l_exists;

3328: -- assignment on pay_payroll_actions when
3329: -- the assignment is deleted
3330: --
3331: open csr_pay_assignment_actions;
3332: fetch csr_pay_assignment_actions into l_exists;
3333: if csr_pay_assignment_actions%found then
3334: close csr_pay_assignment_actions;
3335: hr_utility.set_message(801,'HR_7403_ASG_NO_DEL_PAYROLL_ACT');
3336: hr_utility.raise_error;

Line 3333: if csr_pay_assignment_actions%found then

3329: -- the assignment is deleted
3330: --
3331: open csr_pay_assignment_actions;
3332: fetch csr_pay_assignment_actions into l_exists;
3333: if csr_pay_assignment_actions%found then
3334: close csr_pay_assignment_actions;
3335: hr_utility.set_message(801,'HR_7403_ASG_NO_DEL_PAYROLL_ACT');
3336: hr_utility.raise_error;
3337: end if;

Line 3334: close csr_pay_assignment_actions;

3330: --
3331: open csr_pay_assignment_actions;
3332: fetch csr_pay_assignment_actions into l_exists;
3333: if csr_pay_assignment_actions%found then
3334: close csr_pay_assignment_actions;
3335: hr_utility.set_message(801,'HR_7403_ASG_NO_DEL_PAYROLL_ACT');
3336: hr_utility.raise_error;
3337: end if;
3338: close csr_pay_assignment_actions;

Line 3338: close csr_pay_assignment_actions;

3334: close csr_pay_assignment_actions;
3335: hr_utility.set_message(801,'HR_7403_ASG_NO_DEL_PAYROLL_ACT');
3336: hr_utility.raise_error;
3337: end if;
3338: close csr_pay_assignment_actions;
3339: --
3340: hr_utility.set_location(l_proc, 6);
3341: --
3342: -- Check that no child records exist for the