1701: delete from per_pay_proposals par
1702: where par.assignment_id = p_assignment_id;
1703: --
1704: -- - pay_element_entries_f
1705: -- - pay_element_entry_values_f
1706: --
1707: delete from pay_element_entry_values_f chd
1708: where chd.ELEMENT_ENTRY_ID in
1709: (select par.ELEMENT_ENTRY_ID
1703: --
1704: -- - pay_element_entries_f
1705: -- - pay_element_entry_values_f
1706: --
1707: delete from pay_element_entry_values_f chd
1708: where chd.ELEMENT_ENTRY_ID in
1709: (select par.ELEMENT_ENTRY_ID
1710: from pay_element_entries_f par
1711: where par.assignment_id = p_assignment_id