APPS.PQP_FTE_UTILITIES dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 15: ,FTE_old_value per_assignment_budget_values_f.value%TYPE

11: ,employee_number per_all_people_f.employee_number%TYPE
12: ,assignment_number per_all_assignments_f.assignment_number%TYPE
13: ,effective_date per_all_assignments_f.effective_start_date%TYPE
14: ,change_in VARCHAR2(80)
15: ,FTE_old_value per_assignment_budget_values_f.value%TYPE
16: ,change_type VARCHAR2(80)
17: ,FTE_new_value per_assignment_budget_values_f.value%TYPE
18: ,normal_hours per_all_assignments_f.normal_hours%TYPE
19: ,frequency per_all_assignments_f.frequency%TYPE

Line 17: ,FTE_new_value per_assignment_budget_values_f.value%TYPE

13: ,effective_date per_all_assignments_f.effective_start_date%TYPE
14: ,change_in VARCHAR2(80)
15: ,FTE_old_value per_assignment_budget_values_f.value%TYPE
16: ,change_type VARCHAR2(80)
17: ,FTE_new_value per_assignment_budget_values_f.value%TYPE
18: ,normal_hours per_all_assignments_f.normal_hours%TYPE
19: ,frequency per_all_assignments_f.frequency%TYPE
20: ,contract_type pqp_assignment_attributes_f.contract_type%TYPE
21: ,annual_hours pay_user_column_instances_f.value%TYPE

Line 58: FROM per_assignment_budget_values_f

54: CURSOR csr_fte_exists
55: (p_assignment_id NUMBER
56: ) IS
57: SELECT 1
58: FROM per_assignment_budget_values_f
59: WHERE assignment_id = p_assignment_id
60: AND unit = 'FTE'
61: AND ROWNUM < 2;
62:

Line 72: FROM per_assignment_budget_values_f

68: value,
69: effective_start_date,
70: effective_end_date,
71: object_version_number
72: FROM per_assignment_budget_values_f
73: WHERE assignment_id = p_assignment_id
74: AND unit = 'FTE'
75: AND p_effective_date
76: BETWEEN effective_start_date

Line 944: FROM per_assignment_budget_values_f

940: ,p_effective_date DATE
941: )
942: IS
943: SELECT effective_end_date
944: FROM per_assignment_budget_values_f
945: WHERE assignment_budget_value_id = p_assignment_budget_value_id
946: AND effective_start_date > p_effective_date
947: AND ROWNUM < 2;
948: