APPS.PQP_BUDGET_MAINTENANCE dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 15: ,old_budget_value per_assignment_budget_values_f.VALUE%TYPE

11: ,uom VARCHAR2(80)
12: ,employee_number per_all_people_f.employee_number%TYPE
13: ,assignment_number per_all_assignments_f.assignment_number%TYPE
14: ,effective_date per_all_assignments_f.effective_start_date%TYPE
15: ,old_budget_value per_assignment_budget_values_f.VALUE%TYPE
16: ,change_type VARCHAR2(80)
17: ,new_budget_value per_assignment_budget_values_f.VALUE%TYPE
18: ,MESSAGE fnd_new_messages.MESSAGE_TEXT%TYPE
19: );

Line 17: ,new_budget_value per_assignment_budget_values_f.VALUE%TYPE

13: ,assignment_number per_all_assignments_f.assignment_number%TYPE
14: ,effective_date per_all_assignments_f.effective_start_date%TYPE
15: ,old_budget_value per_assignment_budget_values_f.VALUE%TYPE
16: ,change_type VARCHAR2(80)
17: ,new_budget_value per_assignment_budget_values_f.VALUE%TYPE
18: ,MESSAGE fnd_new_messages.MESSAGE_TEXT%TYPE
19: );
20:
21: TYPE t_output_file_record_type IS TABLE OF g_output_file_rec_type

Line 3343: FROM per_assignment_budget_values_f

3339: IS
3340: CURSOR csr_abv_exists(p_assignment_id NUMBER, p_uom VARCHAR2)
3341: IS
3342: SELECT 1
3343: FROM per_assignment_budget_values_f
3344: WHERE assignment_id = p_assignment_id AND unit = p_uom
3345: AND ROWNUM < 2;
3346:
3347: CURSOR csr_effective_abv(

Line 3355: FROM per_assignment_budget_values_f

3351: )
3352: IS
3353: SELECT assignment_budget_value_id, VALUE, effective_start_date
3354: ,effective_end_date, object_version_number
3355: FROM per_assignment_budget_values_f
3356: WHERE assignment_id = p_assignment_id
3357: AND unit = p_uom
3358: AND p_effective_date BETWEEN effective_start_date
3359: AND effective_end_date;

Line 3367: FROM per_assignment_budget_values_f

3363: ,p_effective_date DATE
3364: )
3365: IS
3366: SELECT effective_end_date
3367: FROM per_assignment_budget_values_f
3368: WHERE assignment_budget_value_id = p_assignment_budget_value_id
3369: AND effective_start_date > p_effective_date
3370: AND ROWNUM < 2;
3371: