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 984: per_time_periods ptp

980: p_date date) is
981: select
982: ptp.end_date
983: from
984: per_time_periods ptp
985: where
986: ptp.payroll_id = p_payroll_id and
987: p_date between
988: ptp.start_date and ptp.end_date;

Line 1739: per_time_periods ptp

1735: p_date date) is
1736: select
1737: ptp.end_date
1738: from
1739: per_time_periods ptp
1740: where
1741: ptp.payroll_id = p_payroll_id and
1742: p_date between
1743: ptp.start_date and ptp.end_date;

Line 1962: , per_time_periods timep

1958: , per_grades grade
1959: , per_jobs job
1960: , per_assignment_status_types ast
1961: , pay_all_payrolls_f payroll
1962: , per_time_periods timep
1963: , hr_locations loc
1964: , hr_all_organization_units org
1965: , pay_people_groups grp
1966: , per_all_vacancies vac

Line 2032: per_time_periods ptp,

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