DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_BUDGET_ENTRY_METHODS

Line 6032: pa_budget_entry_methods pm,

6028: pbc.ext_bdgt_flag
6029: FROM
6030: pa_bc_packets pbc,
6031: pa_budget_versions pbv,
6032: pa_budget_entry_methods pm,
6033: pa_budgetary_control_options pb,
6034: pa_projects_all pp,
6035: pa_resource_list_members rlm,
6036: PA_RESOURCE_LISTS_ALL_BG list

Line 6632: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;

6628: l_resource_list_member_id pa_bc_packets.resource_list_member_id%TYPE;
6629: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
6630: l_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
6631: l_level pa_resource_list_members.member_level%TYPE;
6632: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
6633: l_bud_res_list_member_id pa_bc_packets.bud_resource_list_member_id%TYPE;
6634: l_parent_resource_id pa_resource_list_members.parent_member_id%TYPE;
6635: BEGIN
6636:

Line 7627: pa_budget_entry_methods pm,

7623: pbc.vendor_id
7624: FROM pa_bc_packets pbc,
7625: pa_projects_all pp,
7626: pa_budget_versions bv,
7627: pa_budget_entry_methods pm,
7628: pa_expenditure_types type,
7629: pa_expenditure_items_all ei
7630: WHERE pbc.packet_id = p_packet_id
7631: AND pp.project_id = pbc.project_id

Line 7757: ,pa_budget_entry_methods pm

7753: ,bv.budget_version_id
7754: ,bv.project_id
7755: ,NVL(pm.categorization_code,'N') resource_category_code
7756: FROM pa_budget_versions bv
7757: ,pa_budget_entry_methods pm
7758: ,pa_bc_packets pkt
7759: WHERE pkt.packet_id = p_packet_id
7760: AND bv.budget_version_id = pkt.budget_version_id
7761: AND substr(nvl(pkt.result_code,'P'),1,1) <> ('F')

Line 8341: pa_budget_entry_methods pm,

8337: pbc.budget_line_id,
8338: pbc.budget_ccid
8339: FROM pa_bc_packets pbc,
8340: pa_budget_versions bv,
8341: pa_budget_entry_methods pm,
8342: pa_budgetary_control_options pb
8343: WHERE pbc.packet_id = p_packet_id
8344: AND pbc.budget_version_id = bv.budget_version_id
8345: AND bv.budget_entry_method_code = pm.budget_entry_method_code

Line 14892: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;

14888:
14889: l_count NUMBER(4);
14890: l_validation_failed VARCHAR2(1);
14891: l_set_of_books_id pa_implementations_all.set_of_books_id%type;
14892: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
14893: l_current_budget_version_id pa_budget_versions.budget_version_id%TYPE;
14894: l_draft_budget_version_id pa_budget_versions.budget_version_id%TYPE;
14895: l_result_code pa_bc_packets.result_code%TYPE;
14896: l_acct_changed VARCHAR2(1);

Line 15154: from pa_budget_entry_methods pbem,

15150: End If;
15151:
15152: select pbem.entry_level_code
15153: into l_budget_entry_level_code
15154: from pa_budget_entry_methods pbem,
15155: pa_budget_versions pbv
15156: where pbv.budget_version_id = l_current_budget_version_id
15157: and pbem.budget_entry_method_code = pbv.budget_entry_method_code;
15158: