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

190: ,c_effective_start_date date) is
191: select ptp.start_date
192: ,ptp.end_date
193: from per_assignments_f paf,
194: per_time_periods ptp
195: where paf.assignment_id = c_assignment_id
196: and ptp.payroll_id = paf.payroll_id
197: and c_effective_start_date between paf.effective_start_date
198: and paf.effective_end_date

Line 1321: ,per_time_periods ptpp

1317: select /*+ use_nl(paf ptpp)*/
1318: ptpp.end_date + 1,
1319: ptpt.end_date
1320: from per_assignments_f paf
1321: ,per_time_periods ptpp
1322: ,per_time_periods ptpt
1323: where paf.assignment_id = c_assignment_id
1324: and NVL(c_date_earned,c_effective_start_date) between paf.effective_start_date
1325: and paf.effective_end_date

Line 1322: ,per_time_periods ptpt

1318: ptpp.end_date + 1,
1319: ptpt.end_date
1320: from per_assignments_f paf
1321: ,per_time_periods ptpp
1322: ,per_time_periods ptpt
1323: where paf.assignment_id = c_assignment_id
1324: and NVL(c_date_earned,c_effective_start_date) between paf.effective_start_date
1325: and paf.effective_end_date
1326: and ptpp.payroll_id = paf.payroll_id

Line 1347: ,per_time_periods ptpp

1343: select /*+ use_nl(paf ptpp)*/
1344: ptpp.end_date + 1,
1345: ptpt.end_date
1346: from per_assignments_f paf
1347: ,per_time_periods ptpp
1348: ,per_time_periods ptpt
1349: where paf.assignment_id = c_assignment_id
1350: and ptpp.payroll_id = paf.payroll_id
1351: and ptpp.start_date <= (select max(peef.effective_end_date)

Line 1348: ,per_time_periods ptpt

1344: ptpp.end_date + 1,
1345: ptpt.end_date
1346: from per_assignments_f paf
1347: ,per_time_periods ptpp
1348: ,per_time_periods ptpt
1349: where paf.assignment_id = c_assignment_id
1350: and ptpp.payroll_id = paf.payroll_id
1351: and ptpp.start_date <= (select max(peef.effective_end_date)
1352: from pay_element_entries_f peef

Line 2241: ,per_time_periods ptpp

2237: select /*+ use_nl(paf ptpp)*/
2238: ptpp.end_date + 1,
2239: ptpt.end_date
2240: from per_assignments_f paf
2241: ,per_time_periods ptpp
2242: ,per_time_periods ptpt
2243: where paf.assignment_id = c_assignment_id
2244: and NVL(c_date_earned,c_effective_start_date) between paf.effective_start_date
2245: and paf.effective_end_date

Line 2242: ,per_time_periods ptpt

2238: ptpp.end_date + 1,
2239: ptpt.end_date
2240: from per_assignments_f paf
2241: ,per_time_periods ptpp
2242: ,per_time_periods ptpt
2243: where paf.assignment_id = c_assignment_id
2244: and NVL(c_date_earned,c_effective_start_date) between paf.effective_start_date
2245: and paf.effective_end_date
2246: and ptpp.payroll_id = paf.payroll_id