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_ES_SS_REP_ARCHIVE_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 287: FROM per_assignment_extra_info asg_extra

283: AND hoi.org_information_context = 'ES_STATUTORY_INFO'
284: AND hloc.location_id (+) = hou.location_id
285: AND hoi.organization_id = nvl(c_organization_id,hoi.organization_id)
286: AND EXISTS (SELECT asg_run.assignment_id
287: FROM per_assignment_extra_info asg_extra
288: ,per_all_assignments_f asg_run
289: WHERE asg_extra.aei_information_category = 'ES_SS_REP'
290: AND asg_extra.INFORMATION_TYPE = 'ES_SS_REP'
291: AND asg_extra.aei_information5 = 'Y'

Line 408: FROM per_assignment_extra_info asg_extra

404: /* Reserved flag is left blank */
405: ,paa.assignment_id assignment_id
406: FROM per_all_people_f pap
407: ,(SELECT DISTINCT asg_run.assignment_id assignment_id, asg_run.person_id person_id
408: FROM per_assignment_extra_info asg_extra
409: ,per_all_assignments_f asg_run
410: WHERE asg_extra.aei_information_category = 'ES_SS_REP'
411: AND asg_extra.aei_information5 = 'Y'
412: AND asg_run.business_group_id = g_business_group_id

Line 743: FROM per_assignment_extra_info

739: aei_information3 event,
740: nvl(aei_information4, 'X') value,
741: aei_information6 action_type,
742: aei_information7 first_changed_date
743: FROM per_assignment_extra_info
744: WHERE assignment_id = c_assignment_id
745: AND aei_information5 = 'Y'
746: AND fnd_date.canonical_to_date(aei_information7) <= c_effective_end_date
747: ORDER BY aei_information3;

Line 1516: l_assignment_status_type_id per_assignment_extra_info.aei_information4%TYPE;

1512: WHERE pai.action_context_id = c_action_context_id
1513: AND pai.action_information1 = c_action_status
1514: AND effective_date = c_current_reporting_date;
1515: --
1516: l_assignment_status_type_id per_assignment_extra_info.aei_information4%TYPE;
1517: l_employment_category per_assignment_extra_info.aei_information4%TYPE;
1518: l_contribution_group per_assignment_extra_info.aei_information4%TYPE;
1519: l_epigraph_code per_assignment_extra_info.aei_information4%TYPE;
1520: l_actid pay_assignment_actions.assignment_action_id%TYPE;

Line 1517: l_employment_category per_assignment_extra_info.aei_information4%TYPE;

1513: AND pai.action_information1 = c_action_status
1514: AND effective_date = c_current_reporting_date;
1515: --
1516: l_assignment_status_type_id per_assignment_extra_info.aei_information4%TYPE;
1517: l_employment_category per_assignment_extra_info.aei_information4%TYPE;
1518: l_contribution_group per_assignment_extra_info.aei_information4%TYPE;
1519: l_epigraph_code per_assignment_extra_info.aei_information4%TYPE;
1520: l_actid pay_assignment_actions.assignment_action_id%TYPE;
1521: l_action_info_id pay_action_information.action_information_id%TYPE;

Line 1518: l_contribution_group per_assignment_extra_info.aei_information4%TYPE;

1514: AND effective_date = c_current_reporting_date;
1515: --
1516: l_assignment_status_type_id per_assignment_extra_info.aei_information4%TYPE;
1517: l_employment_category per_assignment_extra_info.aei_information4%TYPE;
1518: l_contribution_group per_assignment_extra_info.aei_information4%TYPE;
1519: l_epigraph_code per_assignment_extra_info.aei_information4%TYPE;
1520: l_actid pay_assignment_actions.assignment_action_id%TYPE;
1521: l_action_info_id pay_action_information.action_information_id%TYPE;
1522: l_ovn pay_action_information.object_version_number%TYPE;

Line 1519: l_epigraph_code per_assignment_extra_info.aei_information4%TYPE;

1515: --
1516: l_assignment_status_type_id per_assignment_extra_info.aei_information4%TYPE;
1517: l_employment_category per_assignment_extra_info.aei_information4%TYPE;
1518: l_contribution_group per_assignment_extra_info.aei_information4%TYPE;
1519: l_epigraph_code per_assignment_extra_info.aei_information4%TYPE;
1520: l_actid pay_assignment_actions.assignment_action_id%TYPE;
1521: l_action_info_id pay_action_information.action_information_id%TYPE;
1522: l_ovn pay_action_information.object_version_number%TYPE;
1523: l_unused_number NUMBER;

Line 1570: UPDATE per_assignment_extra_info

1566: AND effective_start_date >= qualifying_assignments.current_reporting_date
1567: AND assignment_id = qualifying_assignments.assignment_id;
1568:
1569: IF l_unused_number = 0 THEN
1570: UPDATE per_assignment_extra_info
1571: SET aei_information4 = l_assignment_status_type_id
1572: ,aei_information6 = 'U'
1573: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1574: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)

Line 1579: UPDATE per_assignment_extra_info

1575: ,aei_information5 = 'N'
1576: WHERE assignment_id = qualifying_assignments.assignment_id
1577: AND aei_information3 = 'AS';
1578: ELSE
1579: UPDATE per_assignment_extra_info
1580: SET aei_information4 = l_assignment_status_type_id
1581: ,aei_information6 = 'U'
1582: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1583: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)

Line 1619: UPDATE per_assignment_extra_info

1615: AND pev.effective_start_date BETWEEN piv.effective_start_date AND piv.effective_end_date
1616: AND pev.effective_start_date BETWEEN pet.effective_start_date AND pet.effective_end_date
1617: AND pev.effective_start_date BETWEEN pee.effective_start_date AND pee.effective_end_date;
1618: IF l_unused_number = 0 THEN
1619: UPDATE per_assignment_extra_info
1620: SET aei_information4 = l_employment_category
1621: ,aei_information6 = 'U'
1622: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1623: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)

Line 1628: UPDATE per_assignment_extra_info

1624: ,aei_information5 = 'N'
1625: WHERE assignment_id = qualifying_assignments.assignment_id
1626: AND aei_information3 = 'EC';
1627: ELSE
1628: UPDATE per_assignment_extra_info
1629: SET aei_information4 = l_employment_category
1630: ,aei_information6 = 'U'
1631: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1632: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)

Line 1647: UPDATE per_assignment_extra_info

1643: AND paa.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
1644: AND paa.effective_start_date >= qualifying_assignments.current_reporting_date
1645: AND paa.assignment_id = qualifying_assignments.assignment_id;
1646: IF l_unused_number = 0 THEN
1647: UPDATE per_assignment_extra_info
1648: SET aei_information4 = l_contribution_group
1649: ,aei_information6 = 'U'
1650: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1651: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)

Line 1656: UPDATE per_assignment_extra_info

1652: ,aei_information5 = 'N'
1653: WHERE assignment_id = qualifying_assignments.assignment_id
1654: AND aei_information3 = 'CG';
1655: ELSE
1656: UPDATE per_assignment_extra_info
1657: SET aei_information4 = l_contribution_group
1658: ,aei_information6 = 'U'
1659: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1660: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)

Line 1688: UPDATE per_assignment_extra_info

1684: AND pev.effective_start_date BETWEEN pet.effective_start_date AND pet.effective_end_date
1685: AND pev.effective_start_date BETWEEN pee.effective_start_date AND pee.effective_end_date;
1686: --
1687: IF l_unused_number = 0 THEN
1688: UPDATE per_assignment_extra_info
1689: SET aei_information4 = l_epigraph_code
1690: ,aei_information6 = 'U'
1691: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1692: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)

Line 1697: UPDATE per_assignment_extra_info

1693: ,aei_information5 = 'N'
1694: WHERE assignment_id = qualifying_assignments.assignment_id
1695: AND aei_information3 = 'EP';
1696: ELSE
1697: UPDATE per_assignment_extra_info
1698: SET aei_information4 = l_epigraph_code
1699: ,aei_information6 = 'U'
1700: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1701: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)

Line 1714: UPDATE per_assignment_extra_info

1710: WHERE assignment_status_type_id <> l_assignment_status_type_id
1711: AND effective_start_date >= qualifying_assignments.current_reporting_date
1712: AND assignment_id = qualifying_assignments.assignment_id;
1713: IF l_unused_number = 0 THEN
1714: UPDATE per_assignment_extra_info
1715: SET aei_information4 = l_assignment_status_type_id
1716: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1717: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1718: ,aei_information5 = 'N'

Line 1722: UPDATE per_assignment_extra_info

1718: ,aei_information5 = 'N'
1719: WHERE assignment_id = qualifying_assignments.assignment_id
1720: AND aei_information3 = 'AS';
1721: ELSE
1722: UPDATE per_assignment_extra_info
1723: SET aei_information4 = l_assignment_status_type_id
1724: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1725: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)
1726: WHERE assignment_id = qualifying_assignments.assignment_id

Line 1735: UPDATE per_assignment_extra_info

1731: while a person is terminated the AS report flag changes to Y
1732: and once the leaver is reported the flag shud be
1733: updated back to N*/
1734: --
1735: UPDATE per_assignment_extra_info
1736: SET aei_information4 = l_assignment_status_type_id
1737: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1738: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1739: ,aei_information5 = 'N'

Line 1775: UPDATE per_assignment_extra_info

1771: AND pev.effective_start_date BETWEEN pee.effective_start_date AND pee.effective_end_date;
1772:
1773: --
1774: IF l_unused_number = 0 THEN
1775: UPDATE per_assignment_extra_info
1776: SET aei_information4 = l_employment_category
1777: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1778: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1779: ,aei_information5 = 'N'

Line 1783: UPDATE per_assignment_extra_info

1779: ,aei_information5 = 'N'
1780: WHERE assignment_id = qualifying_assignments.assignment_id
1781: AND aei_information3 = 'EC';
1782: ELSE
1783: UPDATE per_assignment_extra_info
1784: SET aei_information4 = l_employment_category
1785: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1786: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)
1787: WHERE assignment_id = qualifying_assignments.assignment_id

Line 1803: UPDATE per_assignment_extra_info

1799: AND paa.effective_start_date >= qualifying_assignments.current_reporting_date
1800: AND paa.assignment_id = qualifying_assignments.assignment_id;
1801: --
1802: IF l_unused_number = 0 THEN
1803: UPDATE per_assignment_extra_info
1804: SET aei_information4 = l_contribution_group
1805: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1806: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1807: ,aei_information5 = 'N'

Line 1811: UPDATE per_assignment_extra_info

1807: ,aei_information5 = 'N'
1808: WHERE assignment_id = qualifying_assignments.assignment_id
1809: AND aei_information3 = 'CG';
1810: ELSE
1811: UPDATE per_assignment_extra_info
1812: SET aei_information4 = l_contribution_group
1813: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1814: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)
1815: WHERE assignment_id = qualifying_assignments.assignment_id

Line 1842: UPDATE per_assignment_extra_info

1838: AND pev.effective_start_date BETWEEN pet.effective_start_date AND pet.effective_end_date
1839: AND pev.effective_start_date BETWEEN pee.effective_start_date AND pee.effective_end_date;
1840: --
1841: IF l_unused_number = 0 THEN
1842: UPDATE per_assignment_extra_info
1843: SET aei_information4 = l_epigraph_code
1844: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1845: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1846: ,aei_information5 = 'N'

Line 1850: UPDATE per_assignment_extra_info

1846: ,aei_information5 = 'N'
1847: WHERE assignment_id = qualifying_assignments.assignment_id
1848: AND aei_information3 = 'EP';
1849: ELSE
1850: UPDATE per_assignment_extra_info
1851: SET aei_information4 = l_epigraph_code
1852: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1853: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)
1854: WHERE assignment_id = qualifying_assignments.assignment_id