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 3385: FROM per_assignment_budget_values_f

3381: IS
3382: CURSOR csr_abv_exists(p_assignment_id NUMBER, p_uom VARCHAR2)
3383: IS
3384: SELECT 1
3385: FROM per_assignment_budget_values_f
3386: WHERE assignment_id = p_assignment_id AND unit = p_uom
3387: AND ROWNUM < 2;
3388:
3389: CURSOR csr_effective_abv(

Line 3397: FROM per_assignment_budget_values_f

3393: )
3394: IS
3395: SELECT assignment_budget_value_id, VALUE, effective_start_date
3396: ,effective_end_date, object_version_number
3397: FROM per_assignment_budget_values_f
3398: WHERE assignment_id = p_assignment_id
3399: AND unit = p_uom
3400: AND p_effective_date BETWEEN effective_start_date
3401: AND effective_end_date;

Line 3409: FROM per_assignment_budget_values_f

3405: ,p_effective_date DATE
3406: )
3407: IS
3408: SELECT effective_end_date
3409: FROM per_assignment_budget_values_f
3410: WHERE assignment_budget_value_id = p_assignment_budget_value_id
3411: AND effective_start_date > p_effective_date
3412: AND ROWNUM < 2;
3413: