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.HREMPTER dependencies on PAY_ELEMENT_ENTRIES_F

Line 104: pay_element_entries_f with

100: the same person. This allows
101: terminations to be cancelled for
102: Employee-Applicants.
103: 70.22 24-JUL-95 TMathers 294069 Update LAST_UPDATE_DATE on
104: pay_element_entries_f with
105: sysdate.
106: 70.23 26-JUL-95 RFine 291763 Added missing column PAY_BASIS_ID to
107: the SQL statement which inserts the new
108: term_assign row in per_assignments_f.

Line 322: pay_element_entries_f.

318: in per_saladmin_utility to fix bug 5200269
319: 115.65 14-JUN-2006 avarri 4371218 Modified cancel_termination to fix 4371218
320: 115.66 17-JUL-2006 agolechh 4308892 This version of hrempter calls pay_element_entry_api
321: instead of performing direct DML statements on
322: pay_element_entries_f.
323: 115.67 26-Jul-2006 thabara 5368246 Modified terminate_entries_and_alus and
324: delete_alus to end date ALUs with final
325: process date regardless of the
326: termination rule.

Line 1023: FROM pay_element_entries_f ee

1019: ee.element_link_id,
1020: ee.element_type_id,
1021: MIN(ee.effective_start_date) effective_start_date,
1022: MAX(ee.effective_end_date) effective_end_date
1023: FROM pay_element_entries_f ee
1024: WHERE ee.assignment_id = p_assignment_id
1025: AND ee.effective_end_date >= p_term_date
1026: AND ee.entry_type = 'E'
1027: GROUP BY ee.element_entry_id, ee.element_link_id,ee.element_type_id;

Line 1049: FROM pay_element_entries_f ee

1045: SELECT ee.element_entry_id,
1046: ee.element_link_id,
1047: min(ee.effective_start_date) effective_start_date,
1048: max(ee.effective_end_date) effective_end_date
1049: FROM pay_element_entries_f ee
1050: WHERE ee.assignment_id = p_assignment_id
1051: AND ee.effective_end_date > p_term_date
1052: AND ((ee.entry_type <> 'E')
1053: OR (ee.entry_type = 'E'

Line 1173: (SELECT 'Y' FROM pay_element_entries_f ee

1169: END IF;
1170: BEGIN
1171: l_ret_chng := 'N';
1172: SELECT 'Y' INTO l_ret_chng FROM dual WHERE EXISTS
1173: (SELECT 'Y' FROM pay_element_entries_f ee
1174: WHERE ee.element_entry_id = rec_entry.element_entry_id
1175: AND ee.effective_start_date > p_term_date);
1176: EXCEPTION
1177: WHEN NO_DATA_FOUND THEN NULL;

Line 1197: (SELECT 'Y' FROM pay_element_entries_f ee

1193: END IF;
1194: BEGIN
1195: l_ret_chng := 'N';
1196: SELECT 'Y' INTO l_ret_chng FROM dual WHERE EXISTS
1197: (SELECT 'Y' FROM pay_element_entries_f ee
1198: WHERE ee.element_entry_id = rec_entry.element_entry_id
1199: AND ee.effective_end_date > p_term_date);
1200: EXCEPTION
1201: WHEN NO_DATA_FOUND THEN NULL;

Line 1209: (SELECT 'Y' FROM pay_element_entries_f ee

1205: END IF;
1206: BEGIN
1207: l_ret_chng := 'N';
1208: SELECT 'Y' INTO l_ret_chng FROM dual WHERE EXISTS
1209: (SELECT 'Y' FROM pay_element_entries_f ee
1210: WHERE ee.element_entry_id = rec_entry.element_entry_id
1211: AND ee.creator_type = 'SP'
1212: AND ee.effective_start_date > p_term_date);
1213: EXCEPTION

Line 1222: (SELECT 'Y' FROM pay_element_entries_f ee

1218: END IF;
1219: BEGIN
1220: l_ret_chng := 'N';
1221: SELECT 'Y' INTO l_ret_chng FROM dual WHERE EXISTS
1222: (SELECT 'Y' FROM pay_element_entries_f ee
1223: WHERE ee.element_entry_id = rec_entry.element_entry_id
1224: AND ee.creator_type = 'SP'
1225: AND ee.effective_end_date > p_term_date);
1226: EXCEPTION

Line 1276: (SELECT 'Y' FROM pay_element_entries_f ee

1272: END IF;
1273: BEGIN
1274: l_ret_chng := 'N';
1275: SELECT 'Y' INTO l_ret_chng FROM dual WHERE EXISTS
1276: (SELECT 'Y' FROM pay_element_entries_f ee
1277: WHERE ee.element_entry_id = nonrec_entry.element_entry_id);
1278: EXCEPTION
1279: WHEN NO_DATA_FOUND THEN NULL;
1280: END;

Line 1287: (SELECT 'Y' FROM pay_element_entries_f ee

1283: END IF;
1284: BEGIN
1285: l_ret_chng := 'N';
1286: SELECT 'Y' INTO l_ret_chng FROM dual WHERE EXISTS
1287: (SELECT 'Y' FROM pay_element_entries_f ee
1288: WHERE ee.element_entry_id = nonrec_entry.element_entry_id
1289: AND ee.creator_type = 'SP');
1290: EXCEPTION
1291: WHEN NO_DATA_FOUND THEN NULL;

Line 1317: (SELECT 'Y' FROM pay_element_entries_f ee

1313: IF p_term_rule IN ('A','L','F') THEN
1314: BEGIN
1315: l_ret_chng := 'N';
1316: SELECT 'Y' INTO l_ret_chng FROM dual WHERE EXISTS
1317: (SELECT 'Y' FROM pay_element_entries_f ee
1318: WHERE ee.element_entry_id = nonrec_entry.element_entry_id
1319: AND ee.effective_end_date = nonrec_entry.effective_end_date);
1320: EXCEPTION
1321: WHEN NO_DATA_FOUND THEN NULL;

Line 1329: (SELECT 'Y' FROM pay_element_entries_f ee

1325: END IF;
1326: BEGIN
1327: l_ret_chng := 'N';
1328: SELECT 'Y' INTO l_ret_chng FROM dual WHERE EXISTS
1329: (SELECT 'Y' FROM pay_element_entries_f ee
1330: WHERE ee.element_entry_id = nonrec_entry.element_entry_id
1331: AND ee.creator_type = 'SP'
1332: AND ee.effective_end_date = nonrec_entry.effective_end_date);
1333: EXCEPTION

Line 1436: ** Original code, below, performs a delete from PAY_ELEMENT_ENTRIES_F

1432: if rec_entry.effective_start_date > p_term_date then
1433: --
1434: hr_utility.set_location(l_proc,21);
1435: /*
1436: ** Original code, below, performs a delete from PAY_ELEMENT_ENTRIES_F
1437: ** and PAY_ELEMENT_ENTRY_VALUES_F where the entry effective start
1438: ** date is greater than the termination date (i.e. the entry starts
1439: ** after the employee is terminated). Therefore the entry, and its
1440: ** values, can be completely removed.

Line 1451: DELETE FROM pay_element_entries_f ee

1447: AND eev.effective_start_date > p_term_date;
1448: --
1449: hr_utility.set_location(l_proc,25);
1450: --
1451: DELETE FROM pay_element_entries_f ee
1452: WHERE ee.element_entry_id = rec_entry.element_entry_id
1453: AND ee.effective_start_date > p_term_date;
1454: **
1455: */

Line 1459: from pay_element_entries_f

1455: */
1456: --
1457: select object_version_number
1458: into l_ee_object_version_number
1459: from pay_element_entries_f
1460: where element_entry_id = rec_entry.element_entry_Id
1461: and effective_start_date = rec_entry.effective_start_date;
1462: --
1463: pay_element_entry_api.delete_element_entry(

Line 1479: ** Original code, below, updates PAY_ELEMENT_ENTRIES_F and

1475: --
1476: hr_utility.set_location(l_proc,30);
1477: --
1478: /*
1479: ** Original code, below, updates PAY_ELEMENT_ENTRIES_F and
1480: ** PAY_ELEMENT_ENTRY_VALUES_F, setting the effective_end_date
1481: ** of the entry end date to the termination date where the
1482: ** entry end date falls some point after the termination date.
1483: ** The DML statements can be replaced with a single call to

Line 1494: UPDATE pay_element_entries_f ee

1490: AND eev.effective_end_date > p_term_date;
1491: --
1492: hr_utility.set_location(l_proc,35);
1493: --
1494: UPDATE pay_element_entries_f ee
1495: SET ee.effective_end_date = p_term_date
1496: , ee.last_update_date = l_last_update_date
1497: WHERE ee.element_entry_id = rec_entry.element_entry_id
1498: AND ee.effective_end_date > p_term_date;

Line 1504: from pay_element_entries_f

1500: */
1501: --
1502: select object_version_number
1503: into l_ee_object_version_number
1504: from pay_element_entries_f
1505: where element_entry_id = rec_entry.element_entry_Id
1506: and effective_start_date = rec_entry.effective_start_date;
1507: --
1508: l_ee_effective_end_date := rec_entry.effective_end_date;

Line 1607: ** Original code, below, performs a delete from PAY_ELEMENT_ENTRIES_F

1603: -- Replace DELETE statements with equivalent calls to
1604: -- pay_element_entry_api.delete_element_entry
1605: --
1606: /*
1607: ** Original code, below, performs a delete from PAY_ELEMENT_ENTRIES_F
1608: ** and PAY_ELEMENT_ENTRY_VALUES_F since the entry effective start
1609: ** date is greater than the termination date (i.e. the entry starts
1610: ** after the employee is terminated). Therefore the entry, and its
1611: ** values, can be completely removed.

Line 1620: DELETE FROM pay_element_entries_f ee

1616: WHERE eev.element_entry_id = nonrec_entry.element_entry_id;
1617: --
1618: hr_utility.set_location(l_proc,65);
1619: --
1620: DELETE FROM pay_element_entries_f ee
1621: WHERE ee.element_entry_id = nonrec_entry.element_entry_id;
1622: **
1623: */
1624: --

Line 1627: from pay_element_entries_f

1623: */
1624: --
1625: select object_version_number
1626: into l_ee_object_version_number
1627: from pay_element_entries_f
1628: where element_entry_id = nonrec_entry.element_entry_Id
1629: and effective_start_date = nonrec_entry.effective_start_date;
1630: --
1631: pay_element_entry_api.delete_element_entry(

Line 1692: -- UPDATE pay_element_entries_f ee

1688: --
1689: -- 31-oct-1995 WWBUG 314277 changed update to p_final_process_date
1690: -- to be p_term_date as this agrees with the relevant termination rule.
1691: -- VT 03/05/96 commented out to fix bug #314277
1692: -- UPDATE pay_element_entries_f ee
1693: -- SET ee.last_update_date = p_term_date
1694: -- WHERE ee.element_entry_id = nonrec_entry.element_entry_id
1695: -- AND ee.effective_end_date = nonrec_entry.effective_end_date;
1696: --

Line 1738: ** Original code, below, updates PAY_ELEMENT_ENTRIES_F and

1734: -- Replace DELETE statements with equivalent calls to
1735: -- pay_element_entry_api.delete_element_entry
1736: --
1737: /*
1738: ** Original code, below, updates PAY_ELEMENT_ENTRIES_F and
1739: ** PAY_ELEMENT_ENTRY_VALUES_F, setting the effective_end_date
1740: ** of the entry end date to the termination date where the
1741: ** entry end date falls some point after the termination date.
1742: ** The DML statements can be replaced with a single call to

Line 1745: UPDATE pay_element_entries_f ee

1741: ** entry end date falls some point after the termination date.
1742: ** The DML statements can be replaced with a single call to
1743: ** pay_element_entry_api.delete_element_entry using the 'DELETE' mode.
1744: **
1745: UPDATE pay_element_entries_f ee
1746: SET ee.effective_end_date = p_final_process_date
1747: , ee.last_update_date = l_last_update_date
1748: WHERE ee.element_entry_id = nonrec_entry.element_entry_id
1749: AND ee.effective_end_date = nonrec_entry.effective_end_date;

Line 1759: from pay_element_entries_f

1755: */
1756: --
1757: select object_version_number
1758: into l_ee_object_version_number
1759: from pay_element_entries_f
1760: where element_entry_id = nonrec_entry.element_entry_Id
1761: and effective_start_date = nonrec_entry.effective_start_date;
1762: --
1763: pay_element_entry_api.delete_element_entry(

Line 1788: -- from pay_element_entries_f ee

1784: --delete from per_pay_proposals pp
1785: --where pp.assignment_id = p_assignment_id
1786: -- and not exists
1787: -- (select null
1788: -- from pay_element_entries_f ee
1789: -- where ee.assignment_id = pp.assignment_id
1790: -- and ee.entry_type = 'SP'
1791: -- and ee.creator_id = pp.pay_proposal_id);
1792: --