DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_BUDGET_VERSIONS

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

1826: AND project_id = p_project_id
1827: AND task_id = p_task_id;
1828: v_dummy NUMBER;
1829: allow_insert_flag VARCHAR2(1):= 'Y';
1830: x_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE := Null; /* added bug2619977 */
1831: x_return_status VARCHAR2(2000) := Null; /* added bug2619977 */
1832: x_msg_count NUMBER := 0 ; /* added bug2619977 */
1833: x_msg_data VARCHAR2(2000) := Null; /* added bug2619977 */
1834: BEGIN

Line 2081: FROM pa_budget_versions

2077: SELECT entry_level_code
2078: FROM pa_budget_entry_methods
2079: WHERE budget_entry_method_code =
2080: ( SELECT budget_entry_method_code
2081: FROM pa_budget_versions
2082: WHERE project_id = p_proj_id
2083: AND current_flag = 'Y'
2084: AND budget_type_code = p_bas_budget_type_code
2085: AND budget_entry_method_code = p_bas_budget_entry_method_code );