APPS.HR_ASSIGNMENT_ATT dependencies on PER_ALL_ASSIGNMENTS_F

Line 120: from per_all_assignments_f asg

116: -- cursor to lock all rows for which the datetrack operation could
117: -- operate over
118: cursor csr_asg_lck(c_lck_start_date date) is
119: select 1
120: from per_all_assignments_f asg
121: where asg.assignment_id = p_assignment_id
122: and asg.effective_end_date >= c_lck_start_date
123: for update nowait;
124: -- select current and future rows

Line 190: , per_all_assignments_f asg

186: ,asg.vendor_assignment_number
187: ,asg.vendor_employee_number
188: ,asg.vendor_id
189: from hr_comments hc
190: , per_all_assignments_f asg
191: where asg.assignment_id=p_assignment_id
192: and asg.effective_end_date >= l_constant_effective_date
193: and hc.comment_id(+) = asg.comment_id
194: order by asg.effective_end_date asc;

Line 260: , per_all_assignments_f asg

256: ,asg.vendor_assignment_number
257: ,asg.vendor_employee_number
258: ,asg.vendor_id
259: from hr_comments hc
260: , per_all_assignments_f asg
261: where asg.assignment_id=p_assignment_id
262: and asg.effective_end_date < l_constant_effective_date
263: and hc.comment_id(+) = asg.comment_id
264: order by asg.effective_end_date desc;

Line 266: l_asg_rec per_all_assignments_f%rowtype;

262: and asg.effective_end_date < l_constant_effective_date
263: and hc.comment_id(+) = asg.comment_id
264: order by asg.effective_end_date desc;
265: -- IN parameters for API
266: l_asg_rec per_all_assignments_f%rowtype;
267: l_comments hr_comments.comment_text%TYPE;
268: -- OUT parameters for API
269: l_soft_coding_keyflex_id number;
270: l_comment_id number;

Line 1261: from per_all_assignments_f asg

1257: -- cursor to lock all rows for which the datetrack operation could
1258: -- operate over
1259: cursor csr_asg_lck(c_lck_start_date date) is
1260: select 1
1261: from per_all_assignments_f asg
1262: where asg.assignment_id = p_assignment_id
1263: and asg.effective_end_date >= c_lck_start_date
1264: for update nowait;
1265: -- select current and future rows

Line 1280: from per_all_assignments_f asg

1276: ,asg.pay_basis_id
1277: ,asg.employment_category
1278: ,asg.effective_start_date
1279: ,asg.effective_end_date
1280: from per_all_assignments_f asg
1281: where asg.assignment_id=p_assignment_id
1282: and asg.effective_end_date >= l_constant_effective_date
1283: order by asg.effective_end_date asc;
1284: -- select past rows not including the current rows

Line 1299: from per_all_assignments_f asg

1295: ,asg.pay_basis_id
1296: ,asg.employment_category
1297: ,asg.effective_start_date
1298: ,asg.effective_end_date
1299: from per_all_assignments_f asg
1300: where asg.assignment_id=p_assignment_id
1301: and asg.effective_end_date < l_constant_effective_date
1302: order by asg.effective_end_date desc;
1303: -- IN parameters for API

Line 1304: l_asg_rec per_all_assignments_f%rowtype;

1300: where asg.assignment_id=p_assignment_id
1301: and asg.effective_end_date < l_constant_effective_date
1302: order by asg.effective_end_date desc;
1303: -- IN parameters for API
1304: l_asg_rec per_all_assignments_f%rowtype;
1305: -- OUT parameters for API
1306: l_people_group_id number;
1307: l_group_name varchar2(240);
1308: l_effective_start_date date;