DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_BUDGET_ENTRY_METHODS

Line 956: from pa_budget_entry_methods a,

952: END IF;
953:
954: select time_phased_type_code
955: into x_time_phased_type_code
956: from pa_budget_entry_methods a,
957: pa_budget_versions b
958: where a.budget_entry_method_code = b.budget_entry_method_code
959: and b.budget_version_id = p_budget_version_id;
960:

Line 998: pa_budget_entry_methods pbm,

994: select pbv.budget_version_id, pbv.resource_list_id, pbm.entry_level_code
995: into x_base_version_id,x_res_list_id,x_entry_level_code
996: from pa_budget_versions pbv,
997: --pa_budget_types pbt,
998: pa_budget_entry_methods pbm,
999: pa_budgetary_control_options pbco
1000: where pbv.project_id = p_project_id
1001: and pbv.current_flag = 'Y'
1002: and pbv.budget_status_code = 'B'

Line 1157: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%type;

1153: P_budget_entry_level_code IN Varchar2 default null)
1154: return Varchar2
1155: IS
1156: l_return_status varchar2(1);
1157: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%type;
1158: l_period_name pa_budget_lines.period_name%type;
1159: l_start_date pa_budget_lines.start_date%type;
1160: l_rlmi pa_resource_assignments.resource_list_member_id%type;
1161: l_task_id pa_resource_assignments.task_id%type;

Line 1282: from pa_budget_entry_methods pbem,

1278: If l_budget_entry_level_code is null then
1279:
1280: select pbem.entry_level_code
1281: into l_budget_entry_level_code
1282: from pa_budget_entry_methods pbem,
1283: pa_budget_versions pbv
1284: where pbv.budget_version_id = P_budget_version_id
1285: and pbem.budget_entry_method_code = pbv.budget_entry_method_code;
1286:

Line 1685: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%type;

1681: p_entry_level_code IN Varchar2,
1682: p_mode IN Varchar2)
1683: return Varchar2
1684: IS
1685: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%type;
1686: l_allowed_flag varchar2(1);
1687: Begin
1688: IF P_DEBUG_MODE = 'Y' THEN
1689: pa_fck_util.debug_msg('In Is_account_change_allowed2:');

Line 2088: pa_budget_entry_methods bem,

2084: NULL budget_line_id,
2085: 'C' gl_period_status
2086: FROM pa_bc_commitments bc,
2087: pa_budget_versions pbv,
2088: pa_budget_entry_methods bem,
2089: gl_period_statuses gl
2090: WHERE GL.application_id = 101
2091: AND GL.set_of_books_id = bc.set_of_books_id
2092: AND gl.period_name = bc.period_name

Line 2117: pa_budget_entry_methods bem,

2113: NULL budget_line_id,
2114: DECODE(pbv.budget_version_id,pa_budget_fund_pkg.g_cost_prev_bvid,'C',NULL) gl_period_status
2115: from pa_bc_commitments bc,
2116: pa_budget_versions pbv,
2117: pa_budget_entry_methods bem,
2118: gl_period_statuses gl
2119: WHERE GL.application_id = 101
2120: AND GL.set_of_books_id = bc.set_of_books_id
2121: AND gl.period_name = bc.period_name