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.PAY_JP_CUSTOM_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 313: l_asg_num per_all_assignments_f.assignment_number%TYPE;

309: p_message OUT NOCOPY VARCHAR2)
310: IS
311: -- Bug 16322188
312: --l_asg_num varchar2(10);
313: l_asg_num per_all_assignments_f.assignment_number%TYPE;
314: BEGIN
315: hr_utility.set_location('pay_jp_custom_pkg.validate_record',10);
316:
317: p_action_status := 'C';

Line 318: select distinct assignment_number into l_asg_num from per_all_assignments_f where assignment_id = p_assignment_id;

314: BEGIN
315: hr_utility.set_location('pay_jp_custom_pkg.validate_record',10);
316:
317: p_action_status := 'C';
318: select distinct assignment_number into l_asg_num from per_all_assignments_f where assignment_id = p_assignment_id;
319: -- Write your own validation here.
320: -- 1) Health Insurance Premium Validation
321: if not(p_value.hi_prem_ee = 0 or p_value.hi_prem_er = 0 or p_value.ci_prem_ee = 0 or p_value.ci_prem_er = 0) and (p_value.hi_org_id is NULL) then
322: p_action_status := 'I';