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

Line 139: per_time_periods ptp

135: SELECT ptp.start_date start_date,
136: ptp.end_date end_date
137: FROM pay_assignment_actions paa,
138: pay_payroll_actions ppa,
139: per_time_periods ptp
140: WHERE paa.assignment_action_id = p_assignment_action_id
141: AND paa.payroll_action_id = ppa.payroll_action_id
142: AND nvl(ppa.date_earned,ppa.effective_date) between ptp.START_DATE and ptp.END_DATE
143: AND ppa.payroll_id = ptp.payroll_id;

Line 2029: from per_time_periods ptp_td,

2025: p_time_def in number
2026: )
2027: is
2028: select ptp_td.start_date
2029: from per_time_periods ptp_td,
2030: pay_assignment_actions paa,
2031: pay_payroll_actions ppa,
2032: per_time_periods ptp_ppa
2033: where ptp_td.time_definition_id = p_time_def

Line 2032: per_time_periods ptp_ppa

2028: select ptp_td.start_date
2029: from per_time_periods ptp_td,
2030: pay_assignment_actions paa,
2031: pay_payroll_actions ppa,
2032: per_time_periods ptp_ppa
2033: where ptp_td.time_definition_id = p_time_def
2034: and paa.assignment_action_id = p_asg_act
2035: and paa.payroll_action_id = ppa.payroll_action_id
2036: and ppa.payroll_id = ptp_ppa.payroll_id