APPS.HR_ELEMENTS dependencies on PER_TIME_PERIODS

Line 1657: FROM per_time_periods

1653: --
1654: SELECT end_date, start_date
1655: INTO v_period_end_date,
1656: v_period_start_date
1657: FROM per_time_periods
1658: WHERE p_passed_date BETWEEN start_date AND end_date
1659: AND payroll_id = p_payroll_id;
1660:
1661: SELECT TPT.number_per_fiscal_year

Line 1688: FROM per_time_periods PTP

1684: --
1685: if p_whole_period_only in ('D','N') then
1686: SELECT COUNT(0)
1687: INTO v_run_number
1688: FROM per_time_periods PTP
1689: WHERE to_date(to_char(PTP.end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1690: BETWEEN TRUNC(v_period_end_date,'YEAR')
1691: AND to_date(to_char(v_period_end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1692: AND PTP.payroll_id = p_payroll_id;

Line 1696: FROM per_time_periods PTP

1692: AND PTP.payroll_id = p_payroll_id;
1693: elsif p_whole_period_only = 'R' then
1694: SELECT COUNT(0)
1695: INTO v_run_number
1696: FROM per_time_periods PTP
1697: WHERE to_date(to_char(PTP.regular_payment_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1698: BETWEEN TRUNC(p_passed_date,'YEAR')
1699: AND to_date(to_char(p_passed_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1700: AND PTP.payroll_id = p_payroll_id;

Line 1704: FROM per_time_periods PTP

1700: AND PTP.payroll_id = p_payroll_id;
1701: else
1702: SELECT COUNT(0)
1703: INTO v_run_number
1704: FROM per_time_periods PTP
1705: WHERE to_date(to_char(PTP.start_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1706: BETWEEN TRUNC(v_period_start_date,'YEAR')
1707: AND to_date(to_char(v_period_end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1708: AND PTP.payroll_id = p_payroll_id;

Line 1722: FROM per_time_periods PTP

1718: --
1719: if p_whole_period_only in ('D','N') then
1720: SELECT COUNT(0)
1721: INTO v_run_number
1722: FROM per_time_periods PTP
1723: WHERE to_date(to_char(PTP.end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1724: BETWEEN TRUNC(v_period_end_date, 'MONTH')
1725: AND to_date(to_char(v_period_end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1726: AND PTP.payroll_id = p_payroll_id;

Line 1730: FROM per_time_periods PTP

1726: AND PTP.payroll_id = p_payroll_id;
1727: elsif p_whole_period_only = 'R' then
1728: SELECT COUNT(0)
1729: INTO v_run_number
1730: FROM per_time_periods PTP
1731: WHERE to_date(to_char(PTP.regular_payment_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1732: BETWEEN TRUNC(p_passed_date, 'MONTH')
1733: AND to_date(to_char(p_passed_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1734: AND PTP.payroll_id = p_payroll_id;

Line 1738: FROM per_time_periods PTP

1734: AND PTP.payroll_id = p_payroll_id;
1735: else
1736: SELECT COUNT(0)
1737: INTO v_run_number
1738: FROM per_time_periods PTP
1739: WHERE to_date(to_char(PTP.start_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1740: BETWEEN TRUNC(v_period_start_date, 'MONTH')
1741: AND to_date(to_char(v_period_end_date,'YYYY/MM/DD'),'YYYY/MM/DD')
1742: AND PTP.payroll_id = p_payroll_id;

Line 1799: from per_time_periods pte

1795: l_whole_period varchar2(1);
1796: --
1797: cursor csr_regular_payment_date is
1798: select pte.regular_payment_date
1799: from per_time_periods pte
1800: where pte.payroll_id = p_payroll_id
1801: and p_date_earned between
1802: pte.start_date and pte.end_date;
1803: --