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_CA_ARCHIVE dependencies on PER_TIME_PERIODS

Line 980: per_time_periods ptp

976: p_date date) is
977: select
978: ptp.end_date
979: from
980: per_time_periods ptp
981: where
982: ptp.payroll_id = p_payroll_id and
983: p_date between
984: ptp.start_date and ptp.end_date;

Line 1735: per_time_periods ptp

1731: p_date date) is
1732: select
1733: ptp.end_date
1734: from
1735: per_time_periods ptp
1736: where
1737: ptp.payroll_id = p_payroll_id and
1738: p_date between
1739: ptp.start_date and ptp.end_date;

Line 1958: , per_time_periods timep

1954: , per_grades grade
1955: , per_jobs job
1956: , per_assignment_status_types ast
1957: , pay_all_payrolls_f payroll
1958: , per_time_periods timep
1959: , hr_locations loc
1960: , hr_all_organization_units org
1961: , pay_people_groups grp
1962: , per_all_vacancies vac

Line 2028: per_time_periods ptp,

2024: select min(ptp.start_date) start_date,
2025: max(ptp.end_date) end_date
2026: from pay_payroll_actions ppa,
2027: pay_assignment_actions paa,
2028: per_time_periods ptp,
2029: per_time_period_types tptype
2030: where paa.assignment_id = l_assignment_id
2031: and paa.tax_unit_id = l_tax_unit_id
2032: and paa.payroll_action_id = ppa.payroll_action_id