APPS.PER_ABV_PKG dependencies on PER_ASSIGNMENT_BUDGET_VALUES

Line 11: -- of table per_assignment_budget_values.

7: +===========================================================================*/
8:
9: --
10: -- 110.1 31-MAR-1998 SASmith Change to add two new procedures related to datetracking
11: -- of table per_assignment_budget_values.
12: -- 1. get_parent_max_end_date. This procedure will return the
13: -- maximum end date for the assignment id. This is required to
14: -- be used to set the end date for the child record(s)
15: -- 2. check_for_duplicate_record. If the current record has effective dates

Line 35: from per_assignment_budget_values

31: ,p_unit varchar2
32: ,p_rowid varchar2) is
33: cursor c is
34: select 'x'
35: from per_assignment_budget_values
36: where assignment_id = p_assignment_id
37: and unit = p_unit
38: AND ((p_rowid IS NULL)
39: OR (p_rowid is not null and

Line 57: select per_assignment_budget_values_s.nextval

53: --
54: --
55: function get_unique_id return number is
56: cursor c is
57: select per_assignment_budget_values_s.nextval
58: from sys.dual;
59: --
60: l_id number;
61: --

Line 150: from PER_ASSIGNMENT_BUDGET_VALUES_F

146: ,p_end_date date ) is
147:
148: cursor C_EXIST_1 is
149: select null
150: from PER_ASSIGNMENT_BUDGET_VALUES_F
151: where assignment_id = p_assignment_id
152: and unit = p_unit
153: and effective_start_date <= p_end_date
154: and effective_end_date >= p_start_date;