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 168: from per_assignments_f paf

164: -- Cursor to fetch Assignment Start Date
165: cursor c_check_assignment_validity(c_assignment_id number
166: ,c_start_date date) is
167: select 1
168: from per_assignments_f paf
169: where paf.assignment_id = c_assignment_id
170: and paf.effective_start_date <= c_start_date;
171:
172: -- Cursor to get Period Start and End Dates

Line 177: from per_assignments_f paf,

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

Line 469: per_assignments_f paf

465: ,pelf.effective_end_date Link_End_Date
466: ,pelf.element_link_id Element_Link_Id
467: from pay_element_types_f petf,
468: pay_element_links_f pelf,
469: per_assignments_f paf
470: where petf.element_type_id = c_element_type_id
471: and petf.element_type_id = pelf.element_type_id
472: and paf.assignment_id = c_assignment_id
473: and c_effective_start_date <= paf.effective_end_date

Line 1234: from per_assignments_f paf

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

Line 1260: from per_assignments_f paf

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

Line 1323: per_assignments_f paf

1319: ,pelf.effective_end_date Link_End_Date
1320: ,pelf.element_link_id Element_Link_Id
1321: from pay_element_types_f petf,
1322: pay_element_links_f pelf,
1323: per_assignments_f paf
1324: where petf.element_type_id = c_element_type_id
1325: and petf.element_type_id = pelf.element_type_id
1326: and paf.assignment_id = c_assignment_id
1327: and c_effective_start_date <= paf.effective_end_date

Line 2142: from per_assignments_f paf

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