DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_BUDGET_ENTRY_METHODS

Line 5889: pa_budget_entry_methods pm,

5885: pbc.ext_bdgt_flag
5886: FROM
5887: pa_bc_packets pbc,
5888: pa_budget_versions pbv,
5889: pa_budget_entry_methods pm,
5890: pa_budgetary_control_options pb,
5891: pa_projects_all pp,
5892: pa_resource_list_members rlm,
5893: PA_RESOURCE_LISTS_ALL_BG list

Line 6480: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;

6476: l_resource_list_member_id pa_bc_packets.resource_list_member_id%TYPE;
6477: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
6478: l_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
6479: l_level pa_resource_list_members.member_level%TYPE;
6480: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
6481: l_bud_res_list_member_id pa_bc_packets.bud_resource_list_member_id%TYPE;
6482: l_parent_resource_id pa_resource_list_members.parent_member_id%TYPE;
6483: BEGIN
6484:

Line 7429: pa_budget_entry_methods pm,

7425: pbc.vendor_id
7426: FROM pa_bc_packets pbc,
7427: pa_projects_all pp,
7428: pa_budget_versions bv,
7429: pa_budget_entry_methods pm,
7430: pa_expenditure_types type,
7431: pa_expenditure_items_all ei
7432: WHERE pbc.packet_id = p_packet_id
7433: AND pp.project_id = pbc.project_id

Line 7559: ,pa_budget_entry_methods pm

7555: ,bv.budget_version_id
7556: ,bv.project_id
7557: ,NVL(pm.categorization_code,'N') resource_category_code
7558: FROM pa_budget_versions bv
7559: ,pa_budget_entry_methods pm
7560: ,pa_bc_packets pkt
7561: WHERE pkt.packet_id = p_packet_id
7562: AND bv.budget_version_id = pkt.budget_version_id
7563: AND substr(nvl(pkt.result_code,'P'),1,1) <> ('F')

Line 8119: pa_budget_entry_methods pm,

8115: pbc.budget_line_id,
8116: pbc.budget_ccid
8117: FROM pa_bc_packets pbc,
8118: pa_budget_versions bv,
8119: pa_budget_entry_methods pm,
8120: pa_budgetary_control_options pb
8121: WHERE pbc.packet_id = p_packet_id
8122: AND pbc.budget_version_id = bv.budget_version_id
8123: AND bv.budget_entry_method_code = pm.budget_entry_method_code

Line 14470: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;

14466:
14467: l_count NUMBER(4);
14468: l_validation_failed VARCHAR2(1);
14469: l_set_of_books_id pa_implementations_all.set_of_books_id%type;
14470: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
14471: l_current_budget_version_id pa_budget_versions.budget_version_id%TYPE;
14472: l_draft_budget_version_id pa_budget_versions.budget_version_id%TYPE;
14473: l_result_code pa_bc_packets.result_code%TYPE;
14474: l_acct_changed VARCHAR2(1);

Line 14732: from pa_budget_entry_methods pbem,

14728: End If;
14729:
14730: select pbem.entry_level_code
14731: into l_budget_entry_level_code
14732: from pa_budget_entry_methods pbem,
14733: pa_budget_versions pbv
14734: where pbv.budget_version_id = l_current_budget_version_id
14735: and pbem.budget_entry_method_code = pbv.budget_entry_method_code;
14736: