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_ELEMENTS dependencies on PER_TIME_PERIODS

Line 1664: FROM per_time_periods

1660: --
1661: SELECT end_date, start_date
1662: INTO v_period_end_date,
1663: v_period_start_date
1664: FROM per_time_periods
1665: WHERE p_passed_date BETWEEN start_date AND end_date
1666: AND payroll_id = p_payroll_id;
1667:
1668: SELECT TPT.number_per_fiscal_year

Line 1698: FROM per_time_periods PTP

1694: /*The pay_action_parameter value is mainly used for controlling the effective_date period number calc*/
1695: if p_whole_period_only in ('D','N','R') then
1696: SELECT COUNT(0)
1697: INTO v_run_number
1698: FROM per_time_periods PTP
1699: WHERE to_date(to_char(PTP.end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1700: BETWEEN TRUNC(v_period_end_date,'YEAR')
1701: AND to_date(to_char(v_period_end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1702: AND PTP.payroll_id = p_payroll_id;

Line 1707: FROM per_time_periods PTP

1703: ELSE
1704: /*If the parameter is set we use the period start date of the passed date_paid date*/
1705: SELECT COUNT(0)
1706: INTO v_run_number
1707: FROM per_time_periods PTP
1708: WHERE to_date(to_char(PTP.start_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1709: BETWEEN TRUNC(v_period_start_date,'YEAR')
1710: AND to_date(to_char(v_period_end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1711: AND PTP.payroll_id = p_payroll_id;

Line 1717: FROM per_time_periods PTP

1713: ELSIF v_rule_date_code = 'E' THEN
1714: /*The period number will be calculated by taking of the last date of the passed date_earned date*/
1715: SELECT COUNT(0)
1716: INTO v_run_number
1717: FROM per_time_periods PTP
1718: WHERE to_date(to_char(PTP.end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1719: BETWEEN TRUNC(v_period_end_date,'YEAR')
1720: AND to_date(to_char(v_period_end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1721: AND PTP.payroll_id = p_payroll_id;

Line 1727: FROM per_time_periods PTP

1723: /*If the rule_date_code is set as date_paid we use payment Date, this is done by adding the look_value to
1724: PAY_FRULE_DATES orPAY_US_FRULE_DATES, mostly the value will be 'R' */
1725: SELECT COUNT(0)
1726: INTO v_run_number
1727: FROM per_time_periods PTP
1728: WHERE to_date(to_char(PTP.regular_payment_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1729: BETWEEN TRUNC(p_passed_date,'YEAR')
1730: AND to_date(to_char(p_passed_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1731: AND PTP.payroll_id = p_payroll_id;

Line 1737: FROM per_time_periods PTP

1733: /* if v_rule_date_code in ('E','F') then
1734: if p_whole_period_only in ('D','N','R') then
1735: SELECT COUNT(0)
1736: INTO v_run_number
1737: FROM per_time_periods PTP
1738: WHERE to_date(to_char(PTP.end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1739: BETWEEN TRUNC(v_period_end_date,'YEAR')
1740: AND to_date(to_char(v_period_end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1741: AND PTP.payroll_id = p_payroll_id;

Line 1745: FROM per_time_periods PTP

1741: AND PTP.payroll_id = p_payroll_id;
1742: else
1743: SELECT COUNT(0)
1744: INTO v_run_number
1745: FROM per_time_periods PTP
1746: WHERE to_date(to_char(PTP.start_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1747: BETWEEN TRUNC(v_period_start_date,'YEAR')
1748: AND to_date(to_char(v_period_end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1749: AND PTP.payroll_id = p_payroll_id;

Line 1754: FROM per_time_periods PTP

1750: end if;
1751: else
1752: SELECT COUNT(0)
1753: INTO v_run_number
1754: FROM per_time_periods PTP
1755: WHERE to_date(to_char(PTP.regular_payment_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1756: BETWEEN TRUNC(p_passed_date,'YEAR')
1757: AND to_date(to_char(p_passed_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1758: AND PTP.payroll_id = p_payroll_id;

Line 1775: FROM per_time_periods PTP

1771: IF p_whole_period_only IN ('D','N','R') THEN
1772: /*The pay_action_parameter value is mainly used for controlling the effective_date period number calc*/
1773: SELECT COUNT(0)
1774: INTO v_run_number
1775: FROM per_time_periods PTP
1776: WHERE to_date(to_char(PTP.end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1777: BETWEEN TRUNC(v_period_end_date, 'MONTH')
1778: AND to_date(to_char(v_period_end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1779: AND PTP.payroll_id = p_payroll_id;

Line 1784: FROM per_time_periods PTP

1780: ELSE
1781: /*If the parameter is set we use the period start date of the passed date_paid date*/
1782: SELECT COUNT(0)
1783: INTO v_run_number
1784: FROM per_time_periods PTP
1785: WHERE to_date(to_char(PTP.start_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1786: BETWEEN TRUNC(v_period_start_date, 'MONTH')
1787: AND to_date(to_char(v_period_end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1788: AND PTP.payroll_id = p_payroll_id;

Line 1794: FROM per_time_periods PTP

1790: ELSIF v_rule_date_code = 'E' THEN
1791: /*The period number will be calculated by taking of the last date of the passed date_earned date*/
1792: SELECT COUNT(0)
1793: INTO v_run_number
1794: FROM per_time_periods PTP
1795: WHERE to_date(to_char(PTP.end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1796: BETWEEN TRUNC(v_period_end_date, 'MONTH')
1797: AND to_date(to_char(v_period_end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1798: AND PTP.payroll_id = p_payroll_id;

Line 1805: FROM per_time_periods PTP

1801: /*If the rule_date_code is set as date_paid we use payment Date, this is done by adding the look_value to
1802: PAY_FRULE_DATES orPAY_US_FRULE_DATES, mostly the value will be 'R' */
1803: SELECT COUNT(0)
1804: INTO v_run_number
1805: FROM per_time_periods PTP
1806: WHERE to_date(to_char(PTP.regular_payment_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1807: BETWEEN TRUNC(p_passed_date, 'MONTH')
1808: AND to_date(to_char(p_passed_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1809: AND PTP.payroll_id = p_payroll_id;

Line 1817: FROM per_time_periods PTP

1813: /*if v_rule_date_code in ('E','F') then
1814: if p_whole_period_only in ('D','N','R') then
1815: SELECT COUNT(0)
1816: INTO v_run_number
1817: FROM per_time_periods PTP
1818: WHERE to_date(to_char(PTP.end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1819: BETWEEN TRUNC(v_period_end_date, 'MONTH')
1820: AND to_date(to_char(v_period_end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1821: AND PTP.payroll_id = p_payroll_id;

Line 1825: FROM per_time_periods PTP

1821: AND PTP.payroll_id = p_payroll_id;
1822: else
1823: SELECT COUNT(0)
1824: INTO v_run_number
1825: FROM per_time_periods PTP
1826: WHERE to_date(to_char(PTP.start_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1827: BETWEEN TRUNC(v_period_start_date, 'MONTH')
1828: AND to_date(to_char(v_period_end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1829: AND PTP.payroll_id = p_payroll_id;

Line 1834: FROM per_time_periods PTP

1830: end if;
1831: else
1832: SELECT COUNT(0)
1833: INTO v_run_number
1834: FROM per_time_periods PTP
1835: WHERE to_date(to_char(PTP.regular_payment_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1836: BETWEEN TRUNC(p_passed_date, 'MONTH')
1837: AND to_date(to_char(p_passed_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1838: AND PTP.payroll_id = p_payroll_id;

Line 1895: from per_time_periods pte

1891: l_whole_period varchar2(1);
1892: --
1893: cursor csr_regular_payment_date is
1894: select pte.regular_payment_date
1895: from per_time_periods pte
1896: where pte.payroll_id = p_payroll_id
1897: and p_date_earned between
1898: pte.start_date and pte.end_date;
1899: --