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 949: per_time_periods ptp,

945: ppf.payroll_id,
946: paa.tax_unit_id,
947: paa.assignment_id
948: FROM pay_payrolls_f ppf,
949: per_time_periods ptp,
950: pay_assignment_actions paa,
951: pay_payroll_actions ppa
952: WHERE ptp.payroll_id = ppf.payroll_id
953: AND ppf.payroll_id = ppa.payroll_id

Line 967: per_time_periods ptp,

963: paf.payroll_id,
964: -- paa.tax_unit_id,
965: paf.assignment_id
966: FROM per_assignments_f paf,
967: per_time_periods ptp,
968: pay_temp_object_actions ptoa,
969: pay_payroll_actions ppa
970: WHERE ptp.payroll_id = paf.payroll_id
971: AND ppa.payroll_action_id = ptoa.payroll_action_id

Line 987: per_time_periods ptp,

983: paf.payroll_id,
984: -- paa.tax_unit_id,
985: paf.assignment_id
986: FROM per_assignments_f paf,
987: per_time_periods ptp,
988: pay_temp_object_actions ptoa,
989: pay_payroll_actions ppa
990: WHERE ptp.payroll_id = paf.payroll_id
991: AND ppa.payroll_action_id = ptoa.payroll_action_id

Line 1448: FROM per_time_periods ptp

1444: WHERE paa.assignment_id = p_ctx_assignment_id
1445: AND paa.payroll_action_id = ppa.payroll_action_id
1446: AND paa.action_sequence =
1447: (SELECT max(paa_prev.action_sequence)
1448: FROM per_time_periods ptp
1449: , pay_payroll_actions ppa1
1450: , pay_assignment_actions paa1
1451: , per_time_periods ptp_prev
1452: , pay_payroll_actions ppa_prev

Line 1451: , per_time_periods ptp_prev

1447: (SELECT max(paa_prev.action_sequence)
1448: FROM per_time_periods ptp
1449: , pay_payroll_actions ppa1
1450: , pay_assignment_actions paa1
1451: , per_time_periods ptp_prev
1452: , pay_payroll_actions ppa_prev
1453: , pay_assignment_actions paa_prev
1454: WHERE paa1.assignment_action_id = p_ctx_assignment_action_id
1455: AND ppa1.payroll_action_id = paa1.payroll_action_id

Line 1922: lv_period_type per_time_periods.period_type%TYPE;

1918: ln_mult_num NUMBER;
1919: ln_period_end_mtd DATE;
1920: ln_period_start_mtd DATE;
1921: ln_max_row NUMBER;
1922: lv_period_type per_time_periods.period_type%TYPE;
1923: ln_days_in_a_period NUMBER;
1924: ln_days_in_period_sub_empl NUMBER;
1925: ln_period_number NUMBER;
1926: ln_pre_date_paid NUMBER := 0;

Line 1979: FROM per_time_periods ptp,

1975:
1976: CURSOR csr_date_earned IS
1977: SELECT ppa.effective_date l_date_paid,
1978: ptp.end_date l_date_earned
1979: FROM per_time_periods ptp,
1980: pay_payroll_actions ppa
1981: WHERE ppa.payroll_action_id = p_payroll_action_id
1982: AND ppa.time_period_id = ptp.time_period_id;
1983:

Line 1990: per_time_periods ptp

1986: CURSOR csr_get_first_pay_date IS
1987: SELECT MIN(ptp.start_date)
1988: FROM pay_assignment_actions paa,
1989: pay_payroll_actions ppa,
1990: per_time_periods ptp
1991: WHERE paa.assignment_id = p_assignment_id
1992: AND paa.payroll_action_id = ppa.payroll_action_id
1993: AND ptp.time_period_id = ppa.time_period_id
1994: AND ppa.action_type IN ('R', 'Q', 'B')

Line 2005: FROM PER_TIME_PERIODS ptp

2001: SELECT ROWNUM mult_num
2002: ,end_date period_end_mtd
2003: ,start_date period_start_mtd
2004: ,period_type
2005: FROM PER_TIME_PERIODS ptp
2006: WHERE payroll_id = ln_payroll_id
2007: AND (TO_CHAR(l_date_paid,'yyyymm') = TO_CHAR(end_date,'yyyymm')
2008: OR
2009: l_date_paid BETWEEN start_date AND end_date

Line 2017: FROM PER_TIME_PERIODS ptp

2013: ORDER BY end_date;
2014:
2015: CURSOR csr_get_no_of_days_in_period(p_payroll_id number) IS
2016: SELECT end_date - start_date +1 period_days
2017: FROM PER_TIME_PERIODS ptp
2018: WHERE payroll_id = p_payroll_id
2019: AND TO_CHAR(l_date_earned,'yyyymmdd') = TO_CHAR(end_date,'yyyymmdd');
2020:
2021: CURSOR csr_get_compute_subsidy_flag IS /*bug#8438155*/

Line 2423: per_time_periods ptp

2419: select least(count(*),1)
2420: into ln_pre_date_paid
2421: from pay_payroll_actions ppa,
2422: pay_assignment_actions paa,
2423: per_time_periods ptp
2424: where ppa.payroll_action_id = paa.payroll_action_id
2425: and ptp.time_period_id = ppa.time_period_id
2426: and paa.assignment_id = p_assignment_id
2427: and to_char(ptp.end_date,'yyyymm') = to_char(l_date_paid,'yyyymm')

Line 2473: from PER_TIME_PERIODS ptp1

2469: hr_utility_trace('Current Period Subsidy for Empl '||to_char(p_credit_to_salary));
2470:
2471: select count(*) max_row
2472: into ln_max_row
2473: from PER_TIME_PERIODS ptp1
2474: where payroll_id = ln_payroll_id
2475: and to_char(l_date_paid,'yyyymm') = to_char(end_date,'yyyymm');
2476:
2477: open csr_get_period_count_in_month;

Line 2673: lv_period_type per_time_periods.period_type%TYPE;

2669: ln_period_end_mtd DATE;
2670: ln_period_start_mtd DATE;
2671: ln_max_row NUMBER;
2672: LN_ISR_SUBSIDY_EMPL_YTD NUMBER;
2673: lv_period_type per_time_periods.period_type%TYPE;
2674: ln_days_in_a_period NUMBER;
2675: ln_days_in_period_sub_empl NUMBER;
2676: ln_period_number NUMBER;
2677: ln_pre_date_paid NUMBER := 0;

Line 2756: FROM per_time_periods ptp,

2752:
2753: CURSOR csr_date_earned IS
2754: SELECT ppa.effective_date l_date_paid,
2755: ptp.end_date l_date_earned
2756: FROM per_time_periods ptp,
2757: pay_payroll_actions ppa
2758: WHERE ppa.payroll_action_id = p_payroll_action_id
2759: AND ppa.time_period_id = ptp.time_period_id;
2760:

Line 2767: per_time_periods ptp

2763: CURSOR csr_get_first_pay_date IS
2764: SELECT MIN(ptp.start_date)
2765: FROM pay_assignment_actions paa,
2766: pay_payroll_actions ppa,
2767: per_time_periods ptp
2768: WHERE paa.assignment_id = p_assignment_id
2769: AND paa.payroll_action_id = ppa.payroll_action_id
2770: AND ptp.time_period_id = ppa.time_period_id
2771: AND ppa.action_type IN ('R', 'Q', 'B')

Line 2782: FROM PER_TIME_PERIODS ptp

2778: SELECT ROWNUM mult_num
2779: ,end_date period_end_mtd
2780: ,start_date period_start_mtd
2781: ,period_type
2782: FROM PER_TIME_PERIODS ptp
2783: WHERE payroll_id = ln_payroll_id
2784: AND (TO_CHAR(l_date_paid,'yyyymm') = TO_CHAR(end_date,'yyyymm')
2785: OR
2786: l_date_paid BETWEEN start_date AND end_date

Line 2794: FROM PER_TIME_PERIODS ptp

2790: ORDER BY end_date;
2791:
2792: CURSOR csr_get_no_of_days_in_period(p_payroll_id NUMBER) IS
2793: SELECT end_date - start_date +1 period_days
2794: FROM PER_TIME_PERIODS ptp
2795: WHERE payroll_id = p_payroll_id
2796: AND TO_CHAR(l_date_earned,'yyyymmdd') = TO_CHAR(end_date,'yyyymmdd');
2797:
2798: CURSOR csr_get_no_of_days_in_ytd(p_payroll_id NUMBER) IS

Line 2800: FROM PER_TIME_PERIODS ptp, PER_TIME_PERIODS ptp1

2796: AND TO_CHAR(l_date_earned,'yyyymmdd') = TO_CHAR(end_date,'yyyymmdd');
2797:
2798: CURSOR csr_get_no_of_days_in_ytd(p_payroll_id NUMBER) IS
2799: SELECT ptp1.end_date-TRUNC(to_date(ptp.start_date),'YEAR') + 1 period_days , TRUNC(to_date(ptp.start_date),'YEAR'), ptp1.end_date
2800: FROM PER_TIME_PERIODS ptp, PER_TIME_PERIODS ptp1
2801: WHERE ptp.period_num = '1'
2802: AND l_date_earned BETWEEN ptp1.start_date AND ptp1.end_date
2803: AND ptp.payroll_id = p_payroll_id
2804: AND ptp1.payroll_id = p_payroll_id

Line 2850: FROM per_time_periods

2846: 'MX') = 'MX';
2847:
2848: CURSOR csr_get_no_of_days_in_mtd (p_payroll_id NUMBER) IS
2849: SELECT end_date-TRUNC(start_date, 'MONTH')+1, end_date, TRUNC(start_date, 'MONTH')
2850: FROM per_time_periods
2851: WHERE payroll_id = p_payroll_id
2852: AND l_date_paid BETWEEN start_date AND end_date;
2853:
2854: CURSOR csr_get_act_hire_date IS

Line 3246: per_time_periods ptp

3242: select least(count(*),1)
3243: into ln_pre_date_paid
3244: from pay_payroll_actions ppa,
3245: pay_assignment_actions paa,
3246: per_time_periods ptp
3247: where ppa.payroll_action_id = paa.payroll_action_id
3248: and ptp.time_period_id = ppa.time_period_id
3249: and paa.assignment_id = p_assignment_id
3250: and to_char(ptp.end_date,'yyyymm') = to_char(l_date_paid,'yyyymm')

Line 3296: from PER_TIME_PERIODS ptp1

3292: hr_utility_trace('Current Period Subsidy for Empl '||to_char(p_credit_to_salary));
3293:
3294: select count(*) max_row
3295: into ln_max_row
3296: from PER_TIME_PERIODS ptp1
3297: where payroll_id = ln_payroll_id
3298: and to_char(l_date_paid,'yyyymm') = to_char(end_date,'yyyymm');
3299:
3300: open csr_get_period_count_in_month;

Line 3713: from PER_TIME_PERIODS ptp

3709: ln_days_in_a_period NUMBER;
3710:
3711: CURSOR csr_get_period_count_in_month IS
3712: select end_date - start_date +1 period_days
3713: from PER_TIME_PERIODS ptp
3714: where payroll_id = p_payroll_id
3715: and to_char(p_date_earned,'yyyymmdd') = to_char(end_date,'yyyymmdd');
3716:
3717: BEGIN

Line 4266: from PER_TIME_PERIODS ptp

4262: select rownum mult_num,
4263: to_char(end_date,'yyyymmdd') period_end_mtd,
4264: to_char(start_date,'yyyymmdd') period_start_mtd,
4265: time_period_id
4266: from PER_TIME_PERIODS ptp
4267: where payroll_id = p_payroll_id
4268: and (to_char(p_date_earned,'yyyymm') = to_char(end_date,'yyyymm')
4269: or
4270: p_date_earned between start_date and end_date