APPS.PER_ABV_BUS dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 29: , per_assignment_budget_values_f abv

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , per_assignment_budget_values_f abv
30: where abv.assignment_budget_value_id = p_assignment_budget_value_id
31: and pbg.business_group_id = abv.business_group_id;
32: --
33: -- Declare local variables

Line 89: , per_assignment_budget_values_f abv

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , per_assignment_budget_values_f abv
90: where abv.assignment_budget_value_id = p_assignment_budget_value_id
91: and pbg.business_group_id = abv.business_group_id;
92: --
93: -- Declare local variables

Line 309: from per_assignment_budget_values_f

305: ,p_unit varchar2
306: ,p_effective_date date) is
307: cursor c is
308: select 'x'
309: from per_assignment_budget_values_f
310: where assignment_id = p_assignment_id
311: and unit = p_unit
312: and p_effective_date between effective_start_date and effective_end_date
313: and assignment_budget_value_id <> nvl(p_assignment_budget_value_id, -1);