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_ASSIGNMENTS_F

Line 184: from per_assignments_f paf

180: -- Cursor to fetch Assignment Start Date
181: cursor c_check_assignment_validity(c_assignment_id number
182: ,c_start_date date) is
183: select 1
184: from per_assignments_f paf
185: where paf.assignment_id = c_assignment_id
186: and paf.effective_start_date <= c_start_date;
187:
188: -- Cursor to get Period Start and End Dates

Line 193: from per_assignments_f paf,

189: cursor c_get_period_dates(c_assignment_id number
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

Line 485: per_assignments_f paf

481: ,pelf.effective_end_date Link_End_Date
482: ,pelf.element_link_id Element_Link_Id
483: from pay_element_types_f petf,
484: pay_element_links_f pelf,
485: per_assignments_f paf
486: where petf.element_type_id = c_element_type_id
487: and petf.element_type_id = pelf.element_type_id
488: and paf.assignment_id = c_assignment_id
489: and c_effective_start_date <= paf.effective_end_date

Line 1320: from per_assignments_f paf

1316: ,c_time_def_id NUMBER) is
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

Line 1346: from per_assignments_f paf

1342: ,c_time_def_id NUMBER) is
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

Line 1409: per_assignments_f paf

1405: ,pelf.effective_end_date Link_End_Date
1406: ,pelf.element_link_id Element_Link_Id
1407: from pay_element_types_f petf,
1408: pay_element_links_f pelf,
1409: per_assignments_f paf
1410: where petf.element_type_id = c_element_type_id
1411: and petf.element_type_id = pelf.element_type_id
1412: and paf.assignment_id = c_assignment_id
1413: and c_effective_start_date <= paf.effective_end_date

Line 2240: from per_assignments_f paf

2236: ,c_time_def_id NUMBER) is
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