APPS.PSB_POSITION_ASSIGNMENTS_PVT dependencies on PSB_POSITION_ASSIGNMENTS_S

Line 91: update PSB_POSITION_ASSIGNMENTS set

87:
88: -- do the update of the record
89: --
90: -- truncated the p_effective_start_date and p_effective_end_date for bug 4377166
91: update PSB_POSITION_ASSIGNMENTS set
92: pay_element_id = decode(p_pay_element_id, FND_API.G_MISS_NUM, pay_element_id, p_pay_element_id),
93: pay_element_option_id = decode(p_pay_element_option_id, FND_API.G_MISS_NUM, pay_element_option_id, p_pay_element_option_id),
94: attribute_value_id = decode(p_attribute_value_id, FND_API.G_MISS_NUM, attribute_value_id, p_attribute_value_id),
95: attribute_value = decode(p_attribute_value, FND_API.G_MISS_CHAR, attribute_value, p_attribute_value),

Line 239: SELECT psb_position_assignments_s.NEXTVAL

235: end if;
236: --
237:
238: -- assign pos assignment id
239: SELECT psb_position_assignments_s.NEXTVAL
240: INTO p_position_assignment_id
241: FROM dual;
242:
243: --