DBA Data[Home] [Help]

APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 672: FROM per_assignment_budget_values_f

668: -- Cursor to get FTE value
669: CURSOR csr_get_fte_value (c_assignment_id NUMBER, c_effective_date DATE)
670: IS
671: SELECT VALUE fte
672: FROM per_assignment_budget_values_f
673: WHERE assignment_id = c_assignment_id
674: AND unit = 'FTE'
675: AND c_effective_date BETWEEN effective_start_date
676: AND effective_end_date