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

Line 178: per_time_periods ptp

174: ,c_effective_start_date date) is
175: select ptp.start_date
176: ,ptp.end_date
177: from per_assignments_f paf,
178: per_time_periods ptp
179: where paf.assignment_id = c_assignment_id
180: and ptp.payroll_id = paf.payroll_id
181: and c_effective_start_date between paf.effective_start_date
182: and paf.effective_end_date

Line 1235: ,per_time_periods ptpp

1231: select /*+ use_nl(paf ptpp)*/
1232: ptpp.end_date + 1,
1233: ptpt.end_date
1234: from per_assignments_f paf
1235: ,per_time_periods ptpp
1236: ,per_time_periods ptpt
1237: where paf.assignment_id = c_assignment_id
1238: and NVL(c_date_earned,c_effective_start_date) between paf.effective_start_date
1239: and paf.effective_end_date

Line 1236: ,per_time_periods ptpt

1232: ptpp.end_date + 1,
1233: ptpt.end_date
1234: from per_assignments_f paf
1235: ,per_time_periods ptpp
1236: ,per_time_periods ptpt
1237: where paf.assignment_id = c_assignment_id
1238: and NVL(c_date_earned,c_effective_start_date) between paf.effective_start_date
1239: and paf.effective_end_date
1240: and ptpp.payroll_id = paf.payroll_id

Line 1261: ,per_time_periods ptpp

1257: select /*+ use_nl(paf ptpp)*/
1258: ptpp.end_date + 1,
1259: ptpt.end_date
1260: from per_assignments_f paf
1261: ,per_time_periods ptpp
1262: ,per_time_periods ptpt
1263: where paf.assignment_id = c_assignment_id
1264: and ptpp.payroll_id = paf.payroll_id
1265: and ptpp.start_date <= (select max(peef.effective_end_date)

Line 1262: ,per_time_periods ptpt

1258: ptpp.end_date + 1,
1259: ptpt.end_date
1260: from per_assignments_f paf
1261: ,per_time_periods ptpp
1262: ,per_time_periods ptpt
1263: where paf.assignment_id = c_assignment_id
1264: and ptpp.payroll_id = paf.payroll_id
1265: and ptpp.start_date <= (select max(peef.effective_end_date)
1266: from pay_element_entries_f peef

Line 2143: ,per_time_periods ptpp

2139: select /*+ use_nl(paf ptpp)*/
2140: ptpp.end_date + 1,
2141: ptpt.end_date
2142: from per_assignments_f paf
2143: ,per_time_periods ptpp
2144: ,per_time_periods ptpt
2145: where paf.assignment_id = c_assignment_id
2146: and NVL(c_date_earned,c_effective_start_date) between paf.effective_start_date
2147: and paf.effective_end_date

Line 2144: ,per_time_periods ptpt

2140: ptpp.end_date + 1,
2141: ptpt.end_date
2142: from per_assignments_f paf
2143: ,per_time_periods ptpp
2144: ,per_time_periods ptpt
2145: where paf.assignment_id = c_assignment_id
2146: and NVL(c_date_earned,c_effective_start_date) between paf.effective_start_date
2147: and paf.effective_end_date
2148: and ptpp.payroll_id = paf.payroll_id