DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_INTERNAL dependencies on PAY_ELEMENT_ENTRIES_F

Line 159: from pay_element_entries_f ele

155:
156: --
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 546: from pay_element_entries_f ele

542: for update nowait;
543: --
544: cursor csr_lock_ele is
545: select null
546: from pay_element_entries_f ele
547: where ele.assignment_id = p_assignment_id
548: for update nowait;
549: --
550: cursor csr_lock_eev is

Line 553: pay_element_entries_f ele

549: --
550: cursor csr_lock_eev is
551: select eev.element_entry_id
552: from pay_element_entry_values_f eev,
553: pay_element_entries_f ele
554: where ele.assignment_id = p_assignment_id
555: and eev.element_entry_id = ele.element_entry_id
556: for update nowait;
557: --

Line 1039: from pay_element_entries_f ele

1035:
1036: --
1037: cursor csr_lock_ele is
1038: select null
1039: from pay_element_entries_f ele
1040: where ele.assignment_id = p_assignment_id
1041: for update nowait;
1042: --
1043: cursor csr_lock_eev is

Line 1046: pay_element_entries_f ele

1042: --
1043: cursor csr_lock_eev is
1044: select eev.element_entry_id
1045: from pay_element_entry_values_f eev,
1046: pay_element_entries_f ele
1047: where ele.assignment_id = p_assignment_id
1048: and eev.element_entry_id = ele.element_entry_id
1049: for update nowait;
1050: --

Line 2236: from pay_element_entries_f ele

2232: for update nowait;
2233: --
2234: cursor csr_lock_ele is
2235: select null
2236: from pay_element_entries_f ele
2237: where ele.assignment_id = p_assignment_id
2238: for update nowait;
2239: --
2240: cursor csr_lock_eev is

Line 2243: pay_element_entries_f ele

2239: --
2240: cursor csr_lock_eev is
2241: select eev.element_entry_id
2242: from pay_element_entry_values_f eev,
2243: pay_element_entries_f ele
2244: where ele.assignment_id = p_assignment_id
2245: and eev.element_entry_id = ele.element_entry_id
2246: for update nowait;
2247: --