APPS.PAY_JP_BAL_UPLOAD dependencies on PER_ALL_ASSIGNMENTS_F

Line 43: per_assignments_f => per_all_assignments_f

39: 115.2 K.Yazawa 17-JUN-1999 Change the package name.
40: (hr_jpbal => hr_jprts)
41: 115.4 Y.Tohya 06-Oct-1999 Fix 1020589.
42: 115.5 K.Yazawa 08-Oct-1999 Remove Multi byte Character.
43: per_assignments_f => per_all_assignments_f
44: 115.6 T.Tagawa 25-Sep-2002 2597843 ASG_ITD support.
45: Added code to avoid HR_6614_PAY_NO_TIME_PERIOD.
46: 115.7 T.Tagawa 18-OCT-2002 2597843 IS_SUPPORTED function simplified(UTF8 support).
47: 115.8 T.Tagawa 06-NOV-2002 2597843 Added code to avoid error if the payroll on actual

Line 107: from per_all_assignments_f

103: select business_group_id,
104: payroll_id
105: into l_business_group_id,
106: l_payroll_id
107: from per_all_assignments_f
108: where assignment_id = p_assignment_id
109: and p_upload_date
110: between effective_start_date and effective_end_date;
111: --

Line 141: from per_all_assignments_f asg

137: hr_utility.set_location(c_proc, 30);
138: --
139: select max(asg.effective_end_date) + 1
140: into l_asg_start_date
141: from per_all_assignments_f asg
142: where asg.assignment_id = p_assignment_id
143: and asg.effective_end_date < p_upload_date
144: and nvl(asg.payroll_id, -1) <> l_payroll_id;
145: --

Line 151: from per_all_assignments_f asg

147: hr_utility.set_location(c_proc, 35);
148: --
149: select min(asg.effective_start_date)
150: into l_asg_start_date
151: from per_all_assignments_f asg
152: where asg.assignment_id = p_assignment_id;
153: end if;
154: --
155: -- In case of element level dimension