DBA Data[Home] [Help]

APPS.PA_BUDGET_INTG_WF dependencies on PA_BUDGET_TYPES

Line 85: FROM pa_budget_types

81: -- Budget Information
82: CURSOR l_budget_type_csr( p_budget_type_code VARCHAR2 )
83: IS
84: SELECT budget_type
85: FROM pa_budget_types
86: WHERE budget_type_code = p_budget_type_code;
87:
88:
89: l_return_status VARCHAR2(1);

Line 114: l_budget_type pa_budget_types.budget_type%TYPE;

110: l_project_manager_uname VARCHAR2(200) := NULL;
111: l_project_party_id NUMBER := NULL;
112: l_project_role_id NUMBER := NULL;
113: l_project_role_name VARCHAR2(80):= NULL;
114: l_budget_type pa_budget_types.budget_type%TYPE;
115: l_mark_as_original pa_budget_versions.original_flag%TYPE;
116:
117:
118: l_projects_rec l_projects_csr%ROWTYPE;

Line 448: l_budget_type_code pa_budget_types.budget_type_code%TYPE := NULL;

444: l_err_stack VARCHAR2(630) := NULL;
445:
446: l_project_id NUMBER := NULL;
447: l_draft_version_id NUMBER := NULL;
448: l_budget_type_code pa_budget_types.budget_type_code%TYPE := NULL;
449: l_mark_as_original pa_budget_versions.original_flag%TYPE := NULL;
450: l_budget_wf_flag VARCHAR2(1) := NULL;
451: l_bgt_intg_flag VARCHAR2(1) := NULL;
452: l_fck_req_flag VARCHAR2(1) := NULL;