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 1041: FROM pay_element_entries_f ee

1037: ee.element_link_id,
1038: ee.element_type_id,
1039: MIN(ee.effective_start_date) effective_start_date,
1040: MAX(ee.effective_end_date) effective_end_date
1041: FROM pay_element_entries_f ee
1042: WHERE ee.assignment_id = p_assignment_id
1043: AND ee.effective_end_date >= p_term_date
1044: AND ee.entry_type = 'E'
1045: GROUP BY ee.element_entry_id, ee.element_link_id,ee.element_type_id;

Line 1067: FROM pay_element_entries_f ee

1063: SELECT ee.element_entry_id,
1064: ee.element_link_id,
1065: min(ee.effective_start_date) effective_start_date,
1066: max(ee.effective_end_date) effective_end_date
1067: FROM pay_element_entries_f ee
1068: WHERE ee.assignment_id = p_assignment_id
1069: AND ee.effective_end_date > p_term_date
1070: AND ((ee.entry_type <> 'E')
1071: OR (ee.entry_type = 'E'

Line 1191: (SELECT 'Y' FROM pay_element_entries_f ee

1187: END IF;
1188: BEGIN
1189: l_ret_chng := 'N';
1190: SELECT 'Y' INTO l_ret_chng FROM dual WHERE EXISTS
1191: (SELECT 'Y' FROM pay_element_entries_f ee
1192: WHERE ee.element_entry_id = rec_entry.element_entry_id
1193: AND ee.effective_start_date > p_term_date);
1194: EXCEPTION
1195: WHEN NO_DATA_FOUND THEN NULL;

Line 1215: (SELECT 'Y' FROM pay_element_entries_f ee

1211: END IF;
1212: BEGIN
1213: l_ret_chng := 'N';
1214: SELECT 'Y' INTO l_ret_chng FROM dual WHERE EXISTS
1215: (SELECT 'Y' FROM pay_element_entries_f ee
1216: WHERE ee.element_entry_id = rec_entry.element_entry_id
1217: AND ee.effective_end_date > p_term_date);
1218: EXCEPTION
1219: WHEN NO_DATA_FOUND THEN NULL;

Line 1227: (SELECT 'Y' FROM pay_element_entries_f ee

1223: END IF;
1224: BEGIN
1225: l_ret_chng := 'N';
1226: SELECT 'Y' INTO l_ret_chng FROM dual WHERE EXISTS
1227: (SELECT 'Y' FROM pay_element_entries_f ee
1228: WHERE ee.element_entry_id = rec_entry.element_entry_id
1229: AND ee.creator_type = 'SP'
1230: AND ee.effective_start_date > p_term_date);
1231: EXCEPTION

Line 1240: (SELECT 'Y' FROM pay_element_entries_f ee

1236: END IF;
1237: BEGIN
1238: l_ret_chng := 'N';
1239: SELECT 'Y' INTO l_ret_chng FROM dual WHERE EXISTS
1240: (SELECT 'Y' FROM pay_element_entries_f ee
1241: WHERE ee.element_entry_id = rec_entry.element_entry_id
1242: AND ee.creator_type = 'SP'
1243: AND ee.effective_end_date > p_term_date);
1244: EXCEPTION

Line 1294: (SELECT 'Y' FROM pay_element_entries_f ee

1290: END IF;
1291: BEGIN
1292: l_ret_chng := 'N';
1293: SELECT 'Y' INTO l_ret_chng FROM dual WHERE EXISTS
1294: (SELECT 'Y' FROM pay_element_entries_f ee
1295: WHERE ee.element_entry_id = nonrec_entry.element_entry_id);
1296: EXCEPTION
1297: WHEN NO_DATA_FOUND THEN NULL;
1298: END;

Line 1305: (SELECT 'Y' FROM pay_element_entries_f ee

1301: END IF;
1302: BEGIN
1303: l_ret_chng := 'N';
1304: SELECT 'Y' INTO l_ret_chng FROM dual WHERE EXISTS
1305: (SELECT 'Y' FROM pay_element_entries_f ee
1306: WHERE ee.element_entry_id = nonrec_entry.element_entry_id
1307: AND ee.creator_type = 'SP');
1308: EXCEPTION
1309: WHEN NO_DATA_FOUND THEN NULL;

Line 1335: (SELECT 'Y' FROM pay_element_entries_f ee

1331: IF p_term_rule IN ('A','L','F') THEN
1332: BEGIN
1333: l_ret_chng := 'N';
1334: SELECT 'Y' INTO l_ret_chng FROM dual WHERE EXISTS
1335: (SELECT 'Y' FROM pay_element_entries_f ee
1336: WHERE ee.element_entry_id = nonrec_entry.element_entry_id
1337: AND ee.effective_end_date = nonrec_entry.effective_end_date);
1338: EXCEPTION
1339: WHEN NO_DATA_FOUND THEN NULL;

Line 1347: (SELECT 'Y' FROM pay_element_entries_f ee

1343: END IF;
1344: BEGIN
1345: l_ret_chng := 'N';
1346: SELECT 'Y' INTO l_ret_chng FROM dual WHERE EXISTS
1347: (SELECT 'Y' FROM pay_element_entries_f ee
1348: WHERE ee.element_entry_id = nonrec_entry.element_entry_id
1349: AND ee.creator_type = 'SP'
1350: AND ee.effective_end_date = nonrec_entry.effective_end_date);
1351: EXCEPTION

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

1450: if rec_entry.effective_start_date > p_term_date then
1451: --
1452: hr_utility.set_location(l_proc,21);
1453: /*
1454: ** Original code, below, performs a delete from PAY_ELEMENT_ENTRIES_F
1455: ** and PAY_ELEMENT_ENTRY_VALUES_F where the entry effective start
1456: ** date is greater than the termination date (i.e. the entry starts
1457: ** after the employee is terminated). Therefore the entry, and its
1458: ** values, can be completely removed.

Line 1469: DELETE FROM pay_element_entries_f ee

1465: AND eev.effective_start_date > p_term_date;
1466: --
1467: hr_utility.set_location(l_proc,25);
1468: --
1469: DELETE FROM pay_element_entries_f ee
1470: WHERE ee.element_entry_id = rec_entry.element_entry_id
1471: AND ee.effective_start_date > p_term_date;
1472: **
1473: */

Line 1477: from pay_element_entries_f

1473: */
1474: --
1475: select object_version_number
1476: into l_ee_object_version_number
1477: from pay_element_entries_f
1478: where element_entry_id = rec_entry.element_entry_Id
1479: and effective_start_date = rec_entry.effective_start_date;
1480: --
1481: pay_element_entry_api.delete_element_entry(

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

1493: --
1494: hr_utility.set_location(l_proc,30);
1495: --
1496: /*
1497: ** Original code, below, updates PAY_ELEMENT_ENTRIES_F and
1498: ** PAY_ELEMENT_ENTRY_VALUES_F, setting the effective_end_date
1499: ** of the entry end date to the termination date where the
1500: ** entry end date falls some point after the termination date.
1501: ** The DML statements can be replaced with a single call to

Line 1512: UPDATE pay_element_entries_f ee

1508: AND eev.effective_end_date > p_term_date;
1509: --
1510: hr_utility.set_location(l_proc,35);
1511: --
1512: UPDATE pay_element_entries_f ee
1513: SET ee.effective_end_date = p_term_date
1514: , ee.last_update_date = l_last_update_date
1515: WHERE ee.element_entry_id = rec_entry.element_entry_id
1516: AND ee.effective_end_date > p_term_date;

Line 1522: from pay_element_entries_f

1518: */
1519: --
1520: select object_version_number
1521: into l_ee_object_version_number
1522: from pay_element_entries_f
1523: where element_entry_id = rec_entry.element_entry_Id
1524: and effective_start_date = rec_entry.effective_start_date;
1525: --
1526: l_ee_effective_end_date := rec_entry.effective_end_date;

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

1621: -- Replace DELETE statements with equivalent calls to
1622: -- pay_element_entry_api.delete_element_entry
1623: --
1624: /*
1625: ** Original code, below, performs a delete from PAY_ELEMENT_ENTRIES_F
1626: ** and PAY_ELEMENT_ENTRY_VALUES_F since the entry effective start
1627: ** date is greater than the termination date (i.e. the entry starts
1628: ** after the employee is terminated). Therefore the entry, and its
1629: ** values, can be completely removed.

Line 1638: DELETE FROM pay_element_entries_f ee

1634: WHERE eev.element_entry_id = nonrec_entry.element_entry_id;
1635: --
1636: hr_utility.set_location(l_proc,65);
1637: --
1638: DELETE FROM pay_element_entries_f ee
1639: WHERE ee.element_entry_id = nonrec_entry.element_entry_id;
1640: **
1641: */
1642: --

Line 1645: from pay_element_entries_f

1641: */
1642: --
1643: select object_version_number
1644: into l_ee_object_version_number
1645: from pay_element_entries_f
1646: where element_entry_id = nonrec_entry.element_entry_Id
1647: and effective_start_date = nonrec_entry.effective_start_date;
1648: --
1649: pay_element_entry_api.delete_element_entry(

Line 1710: -- UPDATE pay_element_entries_f ee

1706: --
1707: -- 31-oct-1995 WWBUG 314277 changed update to p_final_process_date
1708: -- to be p_term_date as this agrees with the relevant termination rule.
1709: -- VT 03/05/96 commented out to fix bug #314277
1710: -- UPDATE pay_element_entries_f ee
1711: -- SET ee.last_update_date = p_term_date
1712: -- WHERE ee.element_entry_id = nonrec_entry.element_entry_id
1713: -- AND ee.effective_end_date = nonrec_entry.effective_end_date;
1714: --

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

1752: -- Replace DELETE statements with equivalent calls to
1753: -- pay_element_entry_api.delete_element_entry
1754: --
1755: /*
1756: ** Original code, below, updates PAY_ELEMENT_ENTRIES_F and
1757: ** PAY_ELEMENT_ENTRY_VALUES_F, setting the effective_end_date
1758: ** of the entry end date to the termination date where the
1759: ** entry end date falls some point after the termination date.
1760: ** The DML statements can be replaced with a single call to

Line 1763: UPDATE pay_element_entries_f ee

1759: ** entry end date falls some point after the termination date.
1760: ** The DML statements can be replaced with a single call to
1761: ** pay_element_entry_api.delete_element_entry using the 'DELETE' mode.
1762: **
1763: UPDATE pay_element_entries_f ee
1764: SET ee.effective_end_date = p_final_process_date
1765: , ee.last_update_date = l_last_update_date
1766: WHERE ee.element_entry_id = nonrec_entry.element_entry_id
1767: AND ee.effective_end_date = nonrec_entry.effective_end_date;

Line 1777: from pay_element_entries_f

1773: */
1774: --
1775: select object_version_number
1776: into l_ee_object_version_number
1777: from pay_element_entries_f
1778: where element_entry_id = nonrec_entry.element_entry_Id
1779: and effective_start_date = nonrec_entry.effective_start_date;
1780: --
1781: pay_element_entry_api.delete_element_entry(

Line 1806: -- from pay_element_entries_f ee

1802: --delete from per_pay_proposals pp
1803: --where pp.assignment_id = p_assignment_id
1804: -- and not exists
1805: -- (select null
1806: -- from pay_element_entries_f ee
1807: -- where ee.assignment_id = pp.assignment_id
1808: -- and ee.entry_type = 'SP'
1809: -- and ee.creator_id = pp.pay_proposal_id);
1810: --