APPS.PA_CLIENT_EXTN_BUDGET_WF dependencies on PA_BUDGET_TYPES

Line 42: -- pa_budget_types.

38: -- 24-JUN-97 jwhite - Updated to latest specs.
39: -- 29-JUL-97 jwhite - Updated to specs directed by jlowell.
40: -- 12-AUG -97 jwhite - Ditto; added check for enable flags
41: -- from pa_project_types and
42: -- pa_budget_types.
43: -- 21-OCT-87 jwhite - Updated as per Kevin Hudson's code review
44: --
45: -- 08-AUG-02 jwhite - Adapted default logic to also support the new FP model.
46: --

Line 96: FROM pa_budget_types b

92:
93: CURSOR l_budget_types_csr (p_budget_type_code VARCHAR2)
94: IS
95: SELECT b.enable_wf_flag
96: FROM pa_budget_types b
97: WHERE b.budget_type_code = p_budget_type_code;
98:
99: CURSOR l_plan_types_csr (p_fin_plan_type_id NUMBER)
100: IS

Line 108: l_enable_wf_flag pa_budget_types.enable_wf_flag%TYPE := 'N';

104:
105:
106:
107: l_enable_budget_wf_flag pa_project_types.enable_budget_wf_flag%TYPE := 'N';
108: l_enable_wf_flag pa_budget_types.enable_wf_flag%TYPE := 'N';
109:
110:
111: BEGIN
112:

Line 383: FROM pa_budget_types

379: --
380: CURSOR l_budget_type_csr( p_budget_type_code VARCHAR2 )
381: IS
382: SELECT budget_type
383: FROM pa_budget_types
384: WHERE budget_type_code = p_budget_type_code;
385: --
386: CURSOR l_wf_started_date_csr
387: IS

Line 467: l_budget_type pa_fin_plan_types_tl.name%TYPE; --Bug 6974760 pa_budget_types.budget_type%TYPE;

463: l_total_revenue NUMBER;
464: l_resource_list_id NUMBER;
465: l_resource_list_name pa_resource_lists.name%TYPE;
466: l_resource_list_description pa_resource_lists.description%TYPE;
467: l_budget_type pa_fin_plan_types_tl.name%TYPE; --Bug 6974760 pa_budget_types.budget_type%TYPE;
468: l_wf_started_date DATE;
469:
470: l_workflow_started_by_id NUMBER;
471: l_user_name VARCHAR2(240);