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.PAY_MX_TAX_FUNCTIONS dependencies on PER_TIME_PERIODS

Line 880: per_time_periods ptp,

876: ppf.payroll_id,
877: paa.tax_unit_id,
878: paa.assignment_id
879: FROM pay_payrolls_f ppf,
880: per_time_periods ptp,
881: pay_assignment_actions paa,
882: pay_payroll_actions ppa
883: WHERE ptp.payroll_id = ppf.payroll_id
884: AND ppf.payroll_id = ppa.payroll_id

Line 898: per_time_periods ptp,

894: paf.payroll_id,
895: -- paa.tax_unit_id,
896: paf.assignment_id
897: FROM per_assignments_f paf,
898: per_time_periods ptp,
899: pay_temp_object_actions ptoa,
900: pay_payroll_actions ppa
901: WHERE ptp.payroll_id = paf.payroll_id
902: AND ppa.payroll_action_id = ptoa.payroll_action_id

Line 1314: FROM per_time_periods ptp

1310: WHERE paa.assignment_id = p_ctx_assignment_id
1311: AND paa.payroll_action_id = ppa.payroll_action_id
1312: AND paa.action_sequence =
1313: (SELECT max(paa_prev.action_sequence)
1314: FROM per_time_periods ptp
1315: , pay_payroll_actions ppa1
1316: , pay_assignment_actions paa1
1317: , per_time_periods ptp_prev
1318: , pay_payroll_actions ppa_prev

Line 1317: , per_time_periods ptp_prev

1313: (SELECT max(paa_prev.action_sequence)
1314: FROM per_time_periods ptp
1315: , pay_payroll_actions ppa1
1316: , pay_assignment_actions paa1
1317: , per_time_periods ptp_prev
1318: , pay_payroll_actions ppa_prev
1319: , pay_assignment_actions paa_prev
1320: WHERE paa1.assignment_action_id = p_ctx_assignment_action_id
1321: AND ppa1.payroll_action_id = paa1.payroll_action_id

Line 1788: lv_period_type per_time_periods.period_type%TYPE;

1784: ln_mult_num NUMBER;
1785: ln_period_end_mtd DATE;
1786: ln_period_start_mtd DATE;
1787: ln_max_row NUMBER;
1788: lv_period_type per_time_periods.period_type%TYPE;
1789: ln_days_in_a_period NUMBER;
1790: ln_days_in_period_sub_empl NUMBER;
1791: ln_period_number NUMBER;
1792: ln_pre_date_paid NUMBER := 0;

Line 1838: FROM per_time_periods ptp,

1834:
1835: CURSOR csr_date_earned IS
1836: SELECT ppa.effective_date l_date_paid,
1837: ptp.end_date l_date_earned
1838: FROM per_time_periods ptp,
1839: pay_payroll_actions ppa
1840: WHERE ppa.payroll_action_id = p_payroll_action_id
1841: AND ppa.time_period_id = ptp.time_period_id;
1842:

Line 1849: per_time_periods ptp

1845: CURSOR csr_get_first_pay_date IS
1846: SELECT MIN(ptp.start_date)
1847: FROM pay_assignment_actions paa,
1848: pay_payroll_actions ppa,
1849: per_time_periods ptp
1850: WHERE paa.assignment_id = p_assignment_id
1851: AND paa.payroll_action_id = ppa.payroll_action_id
1852: AND ptp.time_period_id = ppa.time_period_id
1853: AND ppa.action_type IN ('R', 'Q', 'B')

Line 1864: FROM PER_TIME_PERIODS ptp

1860: SELECT ROWNUM mult_num
1861: ,end_date period_end_mtd
1862: ,start_date period_start_mtd
1863: ,period_type
1864: FROM PER_TIME_PERIODS ptp
1865: WHERE payroll_id = ln_payroll_id
1866: AND (TO_CHAR(l_date_paid,'yyyymm') = TO_CHAR(end_date,'yyyymm')
1867: OR
1868: l_date_paid BETWEEN start_date AND end_date

Line 1876: FROM PER_TIME_PERIODS ptp

1872: ORDER BY end_date;
1873:
1874: CURSOR csr_get_no_of_days_in_period(p_payroll_id number) IS
1875: SELECT end_date - start_date +1 period_days
1876: FROM PER_TIME_PERIODS ptp
1877: WHERE payroll_id = p_payroll_id
1878: AND TO_CHAR(l_date_earned,'yyyymmdd') = TO_CHAR(end_date,'yyyymmdd');
1879:
1880:

Line 2229: per_time_periods ptp

2225: select least(count(*),1)
2226: into ln_pre_date_paid
2227: from pay_payroll_actions ppa,
2228: pay_assignment_actions paa,
2229: per_time_periods ptp
2230: where ppa.payroll_action_id = paa.payroll_action_id
2231: and ptp.time_period_id = ppa.time_period_id
2232: and paa.assignment_id = p_assignment_id
2233: and to_char(ptp.end_date,'yyyymm') = to_char(l_date_paid,'yyyymm')

Line 2277: from PER_TIME_PERIODS ptp1

2273: hr_utility_trace('Current Period Subsidy for Empl '||to_char(p_credit_to_salary));
2274:
2275: select count(*) max_row
2276: into ln_max_row
2277: from PER_TIME_PERIODS ptp1
2278: where payroll_id = ln_payroll_id
2279: and to_char(l_date_paid,'yyyymm') = to_char(end_date,'yyyymm');
2280:
2281: open csr_get_period_count_in_month;

Line 2415: from PER_TIME_PERIODS ptp

2411: ln_days_in_a_period NUMBER;
2412:
2413: CURSOR csr_get_period_count_in_month IS
2414: select end_date - start_date +1 period_days
2415: from PER_TIME_PERIODS ptp
2416: where payroll_id = p_payroll_id
2417: and to_char(p_date_earned,'yyyymmdd') = to_char(end_date,'yyyymmdd');
2418:
2419: BEGIN

Line 2968: from PER_TIME_PERIODS ptp

2964: select rownum mult_num,
2965: to_char(end_date,'yyyymmdd') period_end_mtd,
2966: to_char(start_date,'yyyymmdd') period_start_mtd,
2967: time_period_id
2968: from PER_TIME_PERIODS ptp
2969: where payroll_id = p_payroll_id
2970: and (to_char(p_date_earned,'yyyymm') = to_char(end_date,'yyyymm')
2971: or
2972: p_date_earned between start_date and end_date