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.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 191: , per_all_assignments_f asg

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

Line 262: , per_all_assignments_f asg

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

Line 270: per_all_assignments_f asg where asg.assignment_id=p_assignment_id

266: order by asg.effective_end_date desc;
267:
268: cursor scf_id is
269: select soft_coding_keyflex_id from
270: per_all_assignments_f asg where asg.assignment_id=p_assignment_id
271: and asg.effective_end_date >= l_constant_effective_date
272: order by asg.effective_end_date asc;
273:
274: -- IN parameters for API

Line 275: l_asg_rec per_all_assignments_f%rowtype;

271: and asg.effective_end_date >= l_constant_effective_date
272: order by asg.effective_end_date asc;
273:
274: -- IN parameters for API
275: l_asg_rec per_all_assignments_f%rowtype;
276: l_comments hr_comments.comment_text%TYPE;
277: -- OUT parameters for API
278: l_soft_coding_keyflex_id number;
279: l_comment_id number;

Line 1299: from per_all_assignments_f asg

1295: -- cursor to lock all rows for which the datetrack operation could
1296: -- operate over
1297: cursor csr_asg_lck(c_lck_start_date date) is
1298: select 1
1299: from per_all_assignments_f asg
1300: where asg.assignment_id = p_assignment_id
1301: and asg.effective_end_date >= c_lck_start_date
1302: for update nowait;
1303: -- select current and future rows

Line 1318: from per_all_assignments_f asg

1314: ,asg.pay_basis_id
1315: ,asg.employment_category
1316: ,asg.effective_start_date
1317: ,asg.effective_end_date
1318: from per_all_assignments_f asg
1319: where asg.assignment_id=p_assignment_id
1320: and asg.effective_end_date >= l_constant_effective_date
1321: order by asg.effective_end_date asc;
1322: -- select past rows not including the current rows

Line 1337: from per_all_assignments_f asg

1333: ,asg.pay_basis_id
1334: ,asg.employment_category
1335: ,asg.effective_start_date
1336: ,asg.effective_end_date
1337: from per_all_assignments_f asg
1338: where asg.assignment_id=p_assignment_id
1339: and asg.effective_end_date < l_constant_effective_date
1340: order by asg.effective_end_date desc;
1341: -- IN parameters for API

Line 1342: l_asg_rec per_all_assignments_f%rowtype;

1338: where asg.assignment_id=p_assignment_id
1339: and asg.effective_end_date < l_constant_effective_date
1340: order by asg.effective_end_date desc;
1341: -- IN parameters for API
1342: l_asg_rec per_all_assignments_f%rowtype;
1343: -- OUT parameters for API
1344: l_people_group_id number;
1345: l_group_name varchar2(240);
1346: l_effective_start_date date;