APPS.PER_OTHERBG_APL_API dependencies on PER_ASSIGNMENTS_F

Line 624: update per_assignments_f a

620: p_assignment_id number ) is
621: --
622: begin
623: --
624: update per_assignments_f a
625: set a.effective_end_date = p_new_end_date
626: where a.assignment_id = p_assignment_id
627: and a.effective_end_date = (
628: select max(a2.effective_end_date)

Line 629: from per_assignments_f a2

625: set a.effective_end_date = p_new_end_date
626: where a.assignment_id = p_assignment_id
627: and a.effective_end_date = (
628: select max(a2.effective_end_date)
629: from per_assignments_f a2
630: where a2.assignment_id = a.assignment_id);
631: --
632: end set_end_date;
633:

Line 690: -- delete from per_assignments_f a

686:
687: delete_child ( p_assignment_id ,p_delete_mode);
688:
689:
690: -- delete from per_assignments_f a
691: -- where a.rowid = chartorowid(P_ROW_ID);
692: -- because we dont have rowid, replacing the above with the below one.
693:
694: /*

Line 695: delete from per_assignments_f a

691: -- where a.rowid = chartorowid(P_ROW_ID);
692: -- because we dont have rowid, replacing the above with the below one.
693:
694: /*
695: delete from per_assignments_f a
696: where assignment_id = p_assignment_id;
697: */
698:
699: if ( p_new_end_date is null ) then