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_BATCH_BALANCEADJ_WRAPPER dependencies on PER_ALL_ASSIGNMENTS_F

Line 677: from per_all_assignments_f paf,

673: -- Bug: 5079557
674:
675: cursor get_gre IS
676: select segment1
677: from per_all_assignments_f paf,
678: hr_soft_coding_keyflex hsck
679: where paf.business_group_id = p_business_group_id
680: and sysdate between paf.effective_start_date and paf.effective_end_date
681: and paf.assignment_number = p_assignment_id

Line 696: from per_all_assignments_f paf,

692:
693: cursor get_gre_ca IS
694: select segment1, segment11, segment12,
695: nvl(segment1,nvl(segment11,segment12))
696: from per_all_assignments_f paf,
697: hr_soft_coding_keyflex hsck
698: where paf.business_group_id = p_business_group_id
699: and sysdate between paf.effective_start_date and paf.effective_end_date
700: and paf.assignment_number = p_assignment_id

Line 715: from per_all_assignments_f paf,

711: /* cursor to get the assignment_id */
712:
713: CURSOR csr_get_asg_id is
714: select paf.assignment_id
715: from per_all_assignments_f paf,
716: per_all_people_f ppf
717: where ltrim(ppf.full_name) = p_employee_id
718: and ppf.person_id = paf.person_id
719: and ppf.business_group_id = p_business_group_id

Line 727: from per_all_assignments_f

723: and paf.business_group_id = p_business_group_id;
724:
725: CURSOR csr_get_eff_dates(l_assignment_id number) IS
726: select effective_start_date, effective_end_date
727: from per_all_assignments_f
728: where assignment_id = l_assignment_id
729: and business_group_id = p_business_group_id
730: and p_effective_date between effective_start_date and effective_end_date;
731: