DBA Data[Home] [Help]

APPS.GMS_BUDGET_CORE dependencies on PA_BUDGET_ENTRY_METHODS

Line 424: pa_budget_entry_methods b

420: x_entry_level_code
421: from pa_project_types t,
422: pa_projects p,
423: gms_budget_versions v,
424: pa_budget_entry_methods b
425: where v.budget_version_id = x_draft_version_id
426: and v.project_id = p.project_id
427: and b.budget_entry_method_code = v.budget_entry_method_code
428: and p.project_type = t.project_type;

Line 1178: from pa_budget_entry_methods m,

1174: select m.time_phased_type_code,
1175: m.entry_level_code
1176: into x_time_phased_type_code,
1177: x_entry_level_code
1178: from pa_budget_entry_methods m,
1179: gms_budget_versions v
1180: where v.budget_version_id = x_src_version_id
1181: and v.budget_entry_method_code = m.budget_entry_method_code;
1182:

Line 1485: from pa_budget_entry_methods m,

1481: select m.time_phased_type_code,
1482: m.entry_level_code
1483: into x_time_phased_type_code,
1484: x_entry_level_code
1485: from pa_budget_entry_methods m,
1486: gms_budget_versions v
1487: where v.budget_version_id = x_src_version_id
1488: and v.budget_entry_method_code = m.budget_entry_method_code;
1489:

Line 1870: FROM gms_budget_versions gbv, pa_budget_entry_methods pbem

1866:
1867: CURSOR c_budget_details (p_budget_version NUMBER) IS
1868: SELECT gbv.budget_entry_method_code, resource_list_id,
1869: entry_level_code
1870: FROM gms_budget_versions gbv, pa_budget_entry_methods pbem
1871: WHERE gbv.budget_version_id = p_budget_version
1872: AND gbv.budget_entry_method_code = pbem.budget_entry_method_code;
1873:
1874: CURSOR c_period_dates_draft IS

Line 2288: from pa_budget_entry_methods

2284: select entry_level_code, categorization_code,
2285: time_phased_type_code
2286: into x_entry_level_code, x_categorization_code,
2287: x_time_phased_type_code
2288: from pa_budget_entry_methods
2289: where budget_entry_method_code = x_budget_entry_method_code;
2290:
2291: if ( (x_time_phased_type_code = 'N')
2292: or (x_time_phased_type_code = 'R')) then