DBA Data[Home] [Help]

APPS.PA_BC_COSTING dependencies on PA_BUDGET_VERSIONS

Line 194: ,pa_budget_versions bv

190: ,pa_cost_distribution_lines_all cdl
191: ,pa_project_types_all pt
192: ,pa_projects_all p
193: ,pa_expenditures exp
194: ,pa_budget_versions bv
195: ,pa_budgetary_control_options pbct
196: ,gl_period_statuses glp
197: WHERE ei.cost_distributed_flag = 'S'
198: AND ei.request_id = g_request_id

Line 455: ,pa_budget_versions bv

451: ,l_pkt_reference3_tab(l_this_fetch+1)
452: FROM pa_cost_distribution_lines_all cdl
453: ,pa_project_types_all pt
454: ,pa_projects_all p
455: ,pa_budget_versions bv
456: ,pa_budgetary_control_options pbct
457: ,gl_period_statuses glp
458: WHERE
459: /*

Line 918: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;

914:
915: l_prev_project_id pa_cost_distribution_lines.project_id%TYPE;
916: l_prev_flag VARCHAR2(1);
917: l_budget_version_id pa_bc_packets.budget_version_id%TYPE;
918: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
919: l_entry_level_code pa_budget_versions.budget_entry_method_code%TYPE;
920: l_resource_list_member_id pa_bc_packets.resource_list_member_id%TYPE;
921: l_budget_ccid pa_cost_distribution_lines.budget_ccid%TYPE;
922: l_budget_line_id pa_cost_distribution_lines.budget_line_id%TYPE;

Line 919: l_entry_level_code pa_budget_versions.budget_entry_method_code%TYPE;

915: l_prev_project_id pa_cost_distribution_lines.project_id%TYPE;
916: l_prev_flag VARCHAR2(1);
917: l_budget_version_id pa_bc_packets.budget_version_id%TYPE;
918: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
919: l_entry_level_code pa_budget_versions.budget_entry_method_code%TYPE;
920: l_resource_list_member_id pa_bc_packets.resource_list_member_id%TYPE;
921: l_budget_ccid pa_cost_distribution_lines.budget_ccid%TYPE;
922: l_budget_line_id pa_cost_distribution_lines.budget_line_id%TYPE;
923: l_prev_reslist_id Number;

Line 2036: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;

2032:
2033: l_prev_project_id pa_cost_distribution_lines.project_id%TYPE;
2034: l_prev_flag VARCHAR2(1);
2035: l_budget_version_id pa_bc_packets.budget_version_id%TYPE;
2036: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2037: l_entry_level_code pa_budget_versions.budget_entry_method_code%TYPE; --???
2038: l_resource_list_member_id pa_bc_packets.resource_list_member_id%TYPE;
2039: l_budget_ccid pa_cost_distribution_lines.budget_ccid%TYPE;
2040:

Line 2037: l_entry_level_code pa_budget_versions.budget_entry_method_code%TYPE; --???

2033: l_prev_project_id pa_cost_distribution_lines.project_id%TYPE;
2034: l_prev_flag VARCHAR2(1);
2035: l_budget_version_id pa_bc_packets.budget_version_id%TYPE;
2036: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2037: l_entry_level_code pa_budget_versions.budget_entry_method_code%TYPE; --???
2038: l_resource_list_member_id pa_bc_packets.resource_list_member_id%TYPE;
2039: l_budget_ccid pa_cost_distribution_lines.budget_ccid%TYPE;
2040:
2041: l_fnd_reqd_flag VARCHAR2(1);

Line 2337: ,pa_budget_versions bv

2333: ,pa_cost_distribution_lines_all cdl
2334: ,pa_project_types_all pt
2335: ,pa_projects_all p
2336: ,pa_expenditures exp
2337: ,pa_budget_versions bv
2338: ,pa_budgetary_control_options pbct
2339: ,gl_period_statuses glp
2340: ,po_distributions_all pod /* 6989758 */
2341: WHERE ei.cost_distributed_flag = 'S'

Line 2590: ,pa_budget_versions bv

2586: ,l_pkt_reference3_Tab(l_this_fetch+1)
2587: FROM pa_cost_distribution_lines_all cdl
2588: ,pa_project_types_all pt
2589: ,pa_projects_all p
2590: ,pa_budget_versions bv
2591: ,pa_budgetary_control_options pbct
2592: ,gl_period_statuses glp
2593: WHERE cdl.line_num_reversed IS NULL
2594: AND cdl.reversed_flag IS NULL