DBA Data[Home] [Help]

APPS.GMS_WF_PKG dependencies on PA_BUDGET_ENTRY_METHODS

Line 1453: l_prev_entry_level_code pa_budget_entry_methods.entry_level_code%type;

1449: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
1450: l_baselined_version_id NUMBER;
1451: l_prev_baselined_version_id NUMBER;
1452: l_budget_version_id NUMBER;
1453: l_prev_entry_level_code pa_budget_entry_methods.entry_level_code%type;
1454: l_time_phased_type_code VARCHAR2(30);
1455: l_count NUMBER;
1456: l_packet_id NUMBER;
1457: l_app_short_name VARCHAR2(30);

Line 1493: pa_budget_entry_methods pbem

1489: IS
1490: SELECT pbem.time_phased_type_code,
1491: pbem.entry_level_code
1492: FROM gms_budget_versions gbv,
1493: pa_budget_entry_methods pbem
1494: WHERE gbv.budget_version_id = p_budget_version_id
1495: AND gbv.budget_entry_method_code = pbem.budget_entry_method_code;
1496:
1497: -- Cursor for Budgetary Control Default Setup -- 25-May-2000

Line 1572: pa_budget_entry_methods bem

1568: bem.entry_level_code
1569: into l_prev_baselined_version_id,
1570: l_prev_entry_level_code
1571: from gms_budget_versions bv,
1572: pa_budget_entry_methods bem
1573: where bv.award_id = l_award_id
1574: and bv.project_id = l_project_id
1575: and bv.budget_type_code = l_budget_type_code
1576: and bv.budget_status_code = 'B'