DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_BUDGET_VERSIONS

Line 1820: x_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE := Null; /* added bug2619977 */

1816: AND project_id = p_project_id
1817: AND task_id = p_task_id;
1818: v_dummy NUMBER;
1819: allow_insert_flag VARCHAR2(1):= 'Y';
1820: x_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE := Null; /* added bug2619977 */
1821: x_return_status VARCHAR2(2000) := Null; /* added bug2619977 */
1822: x_msg_count NUMBER := 0 ; /* added bug2619977 */
1823: x_msg_data VARCHAR2(2000) := Null; /* added bug2619977 */
1824: BEGIN

Line 2071: FROM pa_budget_versions

2067: SELECT entry_level_code
2068: FROM pa_budget_entry_methods
2069: WHERE budget_entry_method_code =
2070: ( SELECT budget_entry_method_code
2071: FROM pa_budget_versions
2072: WHERE project_id = p_proj_id
2073: AND current_flag = 'Y'
2074: AND budget_type_code = p_bas_budget_type_code
2075: AND budget_entry_method_code = p_bas_budget_entry_method_code );