APPS.PAY_UK_BAL_UPLOAD dependencies on PER_ASSIGNMENTS_F

Line 102: from per_assignments_f ASS

98: p_assignment_id number
99: ,p_upload_date date
100: ) is
101: select nvl(max(ASS.effective_start_date), START_OF_TIME)
102: from per_assignments_f ASS
103: ,per_assignments_f ASS2
104: where ASS.assignment_id = p_assignment_id
105: and ASS.effective_start_date <= p_upload_date
106: and ASS2.assignment_id = ASS.assignment_id

Line 103: ,per_assignments_f ASS2

99: ,p_upload_date date
100: ) is
101: select nvl(max(ASS.effective_start_date), START_OF_TIME)
102: from per_assignments_f ASS
103: ,per_assignments_f ASS2
104: where ASS.assignment_id = p_assignment_id
105: and ASS.effective_start_date <= p_upload_date
106: and ASS2.assignment_id = ASS.assignment_id
107: and ASS2.effective_end_date = (ASS.effective_start_date - 1)

Line 122: ,per_assignments_f ASS

118: ,p_stat_yr_start_date date
119: ) is
120: select nvl(min(PTP.regular_payment_date), END_OF_TIME)
121: from per_time_periods PTP
122: ,per_assignments_f ASS
123: where ASS.assignment_id = p_assignment_id
124: and p_upload_date between ASS.effective_start_date
125: and ASS.effective_end_date
126: and PTP.payroll_id = ASS.payroll_id

Line 138: ,per_assignments_f ASS

134: ,p_upload_date date
135: ) is
136: select nvl(PTP.start_date, END_OF_TIME)
137: from per_time_periods PTP
138: ,per_assignments_f ASS
139: where ASS.assignment_id = p_assignment_id
140: and p_upload_date between ASS.effective_start_date
141: and ASS.effective_end_date
142: and PTP.payroll_id = ASS.payroll_id

Line 159: from per_assignments_f ASS

155: ,p_upload_date date
156: ) is
157: select nvl(greatest(min(ASS.effective_start_date),
158: min(PTP.start_date)), END_OF_TIME)
159: from per_assignments_f ASS
160: ,per_time_periods PTP
161: where ASS.assignment_id = p_assignment_id
162: and ASS.effective_start_date <= p_upload_date
163: and PTP.start_date <= p_upload_date

Line 192: per_assignments_f ASS

188: ,p_stat_yr_start_date date
189: ) is
190: select nvl(min(p.effective_start_date) ,END_OF_TIME)
191: from per_people_f p,
192: per_assignments_f ASS
193: where p.per_information2 = 'Y'
194: and ASS.assignment_id = p_assignment_id
195: and p_upload_date between
196: ASS.effective_start_date and ASS.effective_end_date

Line 261: FROM per_assignments_f

257: -- business group id.
258: --
259: SELECT DISTINCT business_group_id
260: INTO l_business_group_id
261: FROM per_assignments_f
262: WHERE assignment_id = p_assignment_id;
263:
264: l_expiry_date := hr_gbbal.dimension_reset_date(
265: p_dimension_name,