APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_BUDGET_ENTRY_METHODS

Line 805: from pa_budget_entry_methods a,

801: END IF;
802:
803: select time_phased_type_code
804: into x_time_phased_type_code
805: from pa_budget_entry_methods a,
806: pa_budget_versions b
807: where a.budget_entry_method_code = b.budget_entry_method_code
808: and b.budget_version_id = p_budget_version_id;
809:

Line 847: pa_budget_entry_methods pbm,

843: select pbv.budget_version_id, pbv.resource_list_id, pbm.entry_level_code
844: into x_base_version_id,x_res_list_id,x_entry_level_code
845: from pa_budget_versions pbv,
846: --pa_budget_types pbt,
847: pa_budget_entry_methods pbm,
848: pa_budgetary_control_options pbco
849: where pbv.project_id = p_project_id
850: and pbv.current_flag = 'Y'
851: and pbv.budget_status_code = 'B'

Line 1006: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%type;

1002: P_budget_entry_level_code IN Varchar2 default null)
1003: return Varchar2
1004: IS
1005: l_return_status varchar2(1);
1006: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%type;
1007: l_period_name pa_budget_lines.period_name%type;
1008: l_start_date pa_budget_lines.start_date%type;
1009: l_rlmi pa_resource_assignments.resource_list_member_id%type;
1010: l_task_id pa_resource_assignments.task_id%type;

Line 1131: from pa_budget_entry_methods pbem,

1127: If l_budget_entry_level_code is null then
1128:
1129: select pbem.entry_level_code
1130: into l_budget_entry_level_code
1131: from pa_budget_entry_methods pbem,
1132: pa_budget_versions pbv
1133: where pbv.budget_version_id = P_budget_version_id
1134: and pbem.budget_entry_method_code = pbv.budget_entry_method_code;
1135:

Line 1534: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%type;

1530: p_entry_level_code IN Varchar2,
1531: p_mode IN Varchar2)
1532: return Varchar2
1533: IS
1534: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%type;
1535: l_allowed_flag varchar2(1);
1536: Begin
1537: IF P_DEBUG_MODE = 'Y' THEN
1538: pa_fck_util.debug_msg('In Is_account_change_allowed2:');

Line 1937: pa_budget_entry_methods bem,

1933: NULL budget_line_id,
1934: 'C' gl_period_status
1935: FROM pa_bc_commitments bc,
1936: pa_budget_versions pbv,
1937: pa_budget_entry_methods bem,
1938: gl_period_statuses gl
1939: WHERE GL.application_id = 101
1940: AND GL.set_of_books_id = bc.set_of_books_id
1941: AND gl.period_name = bc.period_name

Line 1966: pa_budget_entry_methods bem,

1962: NULL budget_line_id,
1963: DECODE(pbv.budget_version_id,pa_budget_fund_pkg.g_cost_prev_bvid,'C',NULL) gl_period_status
1964: from pa_bc_commitments bc,
1965: pa_budget_versions pbv,
1966: pa_budget_entry_methods bem,
1967: gl_period_statuses gl
1968: WHERE GL.application_id = 101
1969: AND GL.set_of_books_id = bc.set_of_books_id
1970: AND gl.period_name = bc.period_name