APPS.HR_ASSIGNMENT_INTERNAL dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 165: from pay_element_entry_values_f eev,

161: for update nowait;
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; */

Line 182: from pay_element_entry_values_f eev,

178: for update nowait;
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

Line 588: from pay_element_entry_values_f eev,

584: for update nowait;
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; */

Line 603: from pay_element_entry_values_f eev,

599: for update nowait;
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

Line 1112: from pay_element_entry_values_f eev,

1108: for update nowait;
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;

Line 1128: from pay_element_entry_values_f eev,

1124: for update nowait;
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

Line 2345: from pay_element_entry_values_f eev,

2341: for update nowait;
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; */

Line 2361: from pay_element_entry_values_f eev,

2357: for update nowait;
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