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.PER_APPLICATIONS_PKG dependencies on PER_SECONDARY_ASS_STATUSES

Line 1290: from per_secondary_ass_statuses sa

1286: p_person_id NUMBER) IS
1287:
1288: CURSOR c_sec_stat_cancel IS
1289: select sa.assignment_id
1290: from per_secondary_ass_statuses sa
1291: where sa.business_group_id + 0 = p_business_group_id
1292: and sa.end_date = p_end_date
1293: and exists
1294: ( SELECT s.assignment_id

Line 1295: FROM PER_SECONDARY_ASS_STATUSES s

1291: where sa.business_group_id + 0 = p_business_group_id
1292: and sa.end_date = p_end_date
1293: and exists
1294: ( SELECT s.assignment_id
1295: FROM PER_SECONDARY_ASS_STATUSES s
1296: where s.business_group_id + 0 = p_business_group_id
1297: and s.end_date = p_end_date
1298: and sa.assignment_id = s.assignment_id
1299: and exists

Line 1316: UPDATE per_secondary_ass_statuses s

1312: OPEN c_sec_stat_cancel;
1313: LOOP
1314: FETCH c_sec_stat_cancel into v_assignment_id;
1315: EXIT WHEN c_sec_stat_cancel%NOTFOUND;
1316: UPDATE per_secondary_ass_statuses s
1317: SET s.END_DATE = NULL
1318: , s.LAST_UPDATE_DATE = trunc(SYSDATE)
1319: , s.LAST_UPDATED_BY = p_last_updated_by
1320: , s.LAST_UPDATE_LOGIN = p_last_update_login

Line 1348: -- scan on per_secondary_ass_statuses.

1344: ,p_last_update_login number
1345: ,p_person_id number) is
1346: -- WWbug 633263
1347: -- Modified cursor for performance improvements by removing the full table
1348: -- scan on per_secondary_ass_statuses.
1349: -- This was achieved by removing the sub-query
1350: cursor chk_sec_stat is
1351: select 1
1352: from per_secondary_ass_statuses s

Line 1352: from per_secondary_ass_statuses s

1348: -- scan on per_secondary_ass_statuses.
1349: -- This was achieved by removing the sub-query
1350: cursor chk_sec_stat is
1351: select 1
1352: from per_secondary_ass_statuses s
1353: ,per_assignments_f a
1354: where s.business_group_id + 0 = p_business_group_id
1355: and s.start_date is not null
1356: and a.business_group_id + 0 = p_business_group_id

Line 1366: -- scan on per_secondary_ass_statuses.

1362: between a.effective_start_date
1363: and a.effective_end_date;
1364: -- WWbug 633263
1365: -- Modified cursor for performance improvements by removing the full table
1366: -- scan on per_secondary_ass_statuses.
1367: -- This was achieved by removing the sub-query
1368: cursor c_sec_stat is
1369: select sa.assignment_id
1370: from per_secondary_ass_statuses sa

Line 1370: from per_secondary_ass_statuses sa

1366: -- scan on per_secondary_ass_statuses.
1367: -- This was achieved by removing the sub-query
1368: cursor c_sec_stat is
1369: select sa.assignment_id
1370: from per_secondary_ass_statuses sa
1371: ,per_assignments_f paf
1372: where sa.business_group_id + 0 = p_business_group_id
1373: and sa.start_date <= p_end_date
1374: and (sa.end_date is null

Line 1393: -- scan on per_secondary_ass_statuses.

1389: if chk_sec_stat%found then
1390: close chk_sec_stat;
1391: -- WWbug 633263
1392: -- Modified cursor for performance improvements by removing the full table
1393: -- scan on per_secondary_ass_statuses.
1394: -- This was achieved by replacing the EXISTS sub-query with an IN sub-query
1395: delete from per_secondary_ass_statuses s
1396: where s.business_group_id + 0 = p_business_group_id
1397: and trunc(s.start_date) > p_end_date

Line 1395: delete from per_secondary_ass_statuses s

1391: -- WWbug 633263
1392: -- Modified cursor for performance improvements by removing the full table
1393: -- scan on per_secondary_ass_statuses.
1394: -- This was achieved by replacing the EXISTS sub-query with an IN sub-query
1395: delete from per_secondary_ass_statuses s
1396: where s.business_group_id + 0 = p_business_group_id
1397: and trunc(s.start_date) > p_end_date
1398: and s.assignment_id in
1399: (select a.assignment_id

Line 1411: update per_secondary_ass_statuses s

1407: and a.effective_end_date);
1408: -- WWbug 633263
1409: -- Cleared up the previous code with a cursor for loop
1410: for csr_rec in c_sec_stat loop
1411: update per_secondary_ass_statuses s
1412: set s.end_date = p_end_date
1413: , s.last_update_date = trunc(sysdate)
1414: , s.last_updated_by = p_last_updated_by
1415: , s.last_update_login = p_last_update_login