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 PAY_PAYROLLS_F

Line 2681: from pay_payrolls_f p

2677:
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

Line 3000: from pay_payrolls_f p

2996:
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

Line 3598: , pay_payrolls_f ppf

3594: CURSOR c_get_curr_action_type(p_payroll_id NUMBER)
3595: IS
3596: SELECT action_type
3597: FROM pay_payroll_actions ppa
3598: , pay_payrolls_f ppf
3599: WHERE ppf.payroll_id = p_payroll_id
3600: AND ppa.payroll_id = ppf.payroll_id
3601: AND ppa.business_group_id = ppf.business_group_id
3602: AND (ppa.consolidation_set_id = ppf.consolidation_set_id