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.HR_ASSIGNMENT_INTERNAL dependencies on PAY_ELEMENT_ENTRIES_F

Line 159: from pay_element_entries_f ele

155:
156: -- Fix for bug 5841180 starts here
157: /* cursor csr_lock_ele is
158: select null
159: from pay_element_entries_f ele
160: where ele.assignment_id = p_assignment_id
161: for update nowait;
162: --
163: cursor csr_lock_eev is

Line 166: pay_element_entries_f ele

162: --
163: cursor csr_lock_eev is
164: select eev.element_entry_id
165: from pay_element_entry_values_f eev,
166: pay_element_entries_f ele
167: where ele.assignment_id = p_assignment_id
168: and eev.element_entry_id = ele.element_entry_id
169: for update nowait; */
170: --

Line 175: from pay_element_entries_f ele

171:
172:
173: cursor csr_lock_ele(p_effective_date date) is
174: select null
175: from pay_element_entries_f ele
176: where ele.assignment_id = p_assignment_id
177: and p_effective_date between effective_start_date and effective_end_date
178: for update nowait;
179:

Line 183: pay_element_entries_f ele

179:
180: cursor csr_lock_eev(p_effective_date date) is
181: select eev.element_entry_id
182: from pay_element_entry_values_f eev,
183: pay_element_entries_f ele
184: where ele.assignment_id = p_assignment_id
185: and eev.element_entry_id = ele.element_entry_id
186: and p_effective_date between ele.effective_start_date and ele.effective_end_date
187: for update nowait;

Line 582: from pay_element_entries_f ele

578:
579: -- fix fr bug 5841180 starts here
580: /* cursor csr_lock_ele is
581: select null
582: from pay_element_entries_f ele
583: where ele.assignment_id = p_assignment_id
584: for update nowait;
585: --
586: cursor csr_lock_eev is

Line 589: pay_element_entries_f ele

585: --
586: cursor csr_lock_eev is
587: select eev.element_entry_id
588: from pay_element_entry_values_f eev,
589: pay_element_entries_f ele
590: where ele.assignment_id = p_assignment_id
591: and eev.element_entry_id = ele.element_entry_id
592: for update nowait; */
593:

Line 596: from pay_element_entries_f ele

592: for update nowait; */
593:
594: cursor csr_lock_ele(p_effective_date date) is
595: select null
596: from pay_element_entries_f ele
597: where ele.assignment_id = p_assignment_id
598: and p_effective_date between effective_start_date and effective_end_date
599: for update nowait;
600:

Line 604: pay_element_entries_f ele

600:
601: cursor csr_lock_eev(p_effective_date date) is
602: select eev.element_entry_id
603: from pay_element_entry_values_f eev,
604: pay_element_entries_f ele
605: where ele.assignment_id = p_assignment_id
606: and eev.element_entry_id = ele.element_entry_id
607: and p_effective_date between ele.effective_start_date and ele.effective_end_date
608: for update nowait;

Line 1106: from pay_element_entries_f ele

1102: -- fix for bug 5841180 starts here
1103: /*
1104: cursor csr_lock_ele is
1105: select null
1106: from pay_element_entries_f ele
1107: where ele.assignment_id = p_assignment_id
1108: for update nowait;
1109: --
1110: cursor csr_lock_eev is

Line 1113: pay_element_entries_f ele

1109: --
1110: cursor csr_lock_eev is
1111: select eev.element_entry_id
1112: from pay_element_entry_values_f eev,
1113: pay_element_entries_f ele
1114: where ele.assignment_id = p_assignment_id
1115: and eev.element_entry_id = ele.element_entry_id
1116: for update nowait;
1117: */

Line 1121: from pay_element_entries_f ele

1117: */
1118:
1119: cursor csr_lock_ele(p_effective_date date) is
1120: select null
1121: from pay_element_entries_f ele
1122: where ele.assignment_id = p_assignment_id
1123: and p_effective_date between effective_start_date and effective_end_date
1124: for update nowait;
1125:

Line 1129: pay_element_entries_f ele

1125:
1126: cursor csr_lock_eev (p_effective_date date) is
1127: select eev.element_entry_id
1128: from pay_element_entry_values_f eev,
1129: pay_element_entries_f ele
1130: where ele.assignment_id = p_assignment_id
1131: and eev.element_entry_id = ele.element_entry_id
1132: and p_effective_date between ele.effective_start_date and ele.effective_end_date
1133: for update nowait;

Line 2339: from pay_element_entries_f ele

2335: --
2336: -- Fix for bug 5841180 starts here
2337: /* cursor csr_lock_ele is
2338: select null
2339: from pay_element_entries_f ele
2340: where ele.assignment_id = p_assignment_id
2341: for update nowait;
2342: --
2343: cursor csr_lock_eev is

Line 2346: pay_element_entries_f ele

2342: --
2343: cursor csr_lock_eev is
2344: select eev.element_entry_id
2345: from pay_element_entry_values_f eev,
2346: pay_element_entries_f ele
2347: where ele.assignment_id = p_assignment_id
2348: and eev.element_entry_id = ele.element_entry_id
2349: for update nowait; */
2350:

Line 2354: from pay_element_entries_f ele

2350:
2351:
2352: cursor csr_lock_ele(p_effective_date date) is
2353: select null
2354: from pay_element_entries_f ele
2355: where ele.assignment_id = p_assignment_id
2356: and p_effective_date between effective_start_date and effective_end_date
2357: for update nowait;
2358:

Line 2362: pay_element_entries_f ele

2358:
2359: cursor csr_lock_eev(p_effective_date date) is
2360: select eev.element_entry_id
2361: from pay_element_entry_values_f eev,
2362: pay_element_entries_f ele
2363: where ele.assignment_id = p_assignment_id
2364: and eev.element_entry_id = ele.element_entry_id
2365: and p_effective_date between ele.effective_start_date and ele.effective_end_date
2366: for update nowait;