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_NZ_HOLIDAYS dependencies on PER_TIME_PERIOD_TYPES

Line 1627: l_num_of_pay_periods_per_year per_time_period_types.number_per_fiscal_year%type;

1623: l_return_value NUMBER;
1624: l_invalid_exit BOOLEAN := TRUE;
1625:
1626: l_pay_period_start_date DATE;
1627: l_num_of_pay_periods_per_year per_time_period_types.number_per_fiscal_year%type;
1628: l_extra_weeks NUMBER;
1629: l_offset_flag BOOLEAN := FALSE;
1630:
1631:

Line 1646: per_time_period_types TPTYPE

1642: SELECT TPERIOD.start_date,
1643: TPTYPE.number_per_fiscal_year
1644: FROM pay_payroll_actions PACTION,
1645: per_time_periods TPERIOD,
1646: per_time_period_types TPTYPE
1647: where PACTION.payroll_action_id =
1648: (select max(paa.payroll_action_id)
1649: from pay_assignment_actions paa,
1650: pay_payroll_actions ppa

Line 2044: per_time_period_types TPTYPE

2040: SELECT TPERIOD.start_date,
2041: TPTYPE.number_per_fiscal_year
2042: FROM pay_payroll_actions PACTION,
2043: per_time_periods TPERIOD,
2044: per_time_period_types TPTYPE
2045: where PACTION.payroll_action_id =
2046: (select max(paa.payroll_action_id)
2047: from pay_assignment_actions paa,
2048: pay_payroll_actions ppa

Line 2672: l_pay_periods_per_year per_time_period_types.number_per_fiscal_year%type ;

2668: l_start_date date ;
2669: l_end_date date ;
2670: l_period_accrual number ;
2671: l_asg_working_hours per_all_assignments_f.normal_hours%type ;
2672: l_pay_periods_per_year per_time_period_types.number_per_fiscal_year%type ;
2673:
2674: e_accrual_function_failure exception ;
2675:
2676: -- cursor to get number of periods per year

Line 2682: , per_time_period_types tpt

2678: cursor c_number_of_periods_per_year (p_payroll_id number
2679: ,p_effective_date date) is
2680: select tpt.number_per_fiscal_year
2681: from pay_payrolls_f p
2682: , per_time_period_types tpt
2683: where p.payroll_id = p_payroll_id
2684: and p_effective_date between p.effective_start_date
2685: and p.effective_end_date
2686: and tpt.period_type = p.period_type ;

Line 2981: l_pay_periods_per_year per_time_period_types.number_per_fiscal_year%type ;

2977: l_start_date date ;
2978: l_end_date date ;
2979: l_period_accrual number ;
2980: l_asg_working_hours per_all_assignments_f.normal_hours%type ;
2981: l_pay_periods_per_year per_time_period_types.number_per_fiscal_year%type ;
2982: l_calc_service_date date;
2983: l_annual_accrual_1 number;
2984: l_annual_accrual_2 number;
2985: l_asg_working_hours_1 per_all_assignments_f.normal_hours%type;

Line 3001: , per_time_period_types tpt

2997: cursor c_number_of_periods_per_year (p_payroll_id number
2998: ,p_effective_date date) is
2999: select tpt.number_per_fiscal_year
3000: from pay_payrolls_f p
3001: , per_time_period_types tpt
3002: where p.payroll_id = p_payroll_id
3003: and p_effective_date between p.effective_start_date
3004: and p.effective_end_date
3005: and tpt.period_type = p.period_type ;

Line 3552: per_time_period_types TPTYPE

3548: SELECT TPERIOD.start_date,
3549: TPTYPE.number_per_fiscal_year
3550: FROM pay_payroll_actions PACTION,
3551: per_time_periods TPERIOD,
3552: per_time_period_types TPTYPE
3553: where PACTION.payroll_action_id =
3554: (select max(paa.payroll_action_id)
3555: from pay_assignment_actions paa,
3556: pay_payroll_actions ppa