DBA Data[Home] [Help]

APPS.GMS_BUDGET_UTILS dependencies on PA_BUDGET_ENTRY_METHODS

Line 410: from pa_budget_entry_methods

406: x_budget_entry_method_code := NULL;
407:
408: select budget_entry_method_code
409: into x_budget_entry_method_code
410: from pa_budget_entry_methods
411: where budget_entry_method = x_budget_entry_method;
412:
413: return x_budget_entry_method_code;
414:

Line 1682: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )

1678: ,p_burdened_cost IN VARCHAR2)
1679: IS
1680:
1681: CURSOR l_budget_entry_method_csr
1682: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )
1683: IS
1684: SELECT cost_quantity_flag
1685: , raw_cost_flag
1686: , burdened_cost_flag

Line 1688: FROM pa_budget_entry_methods

1684: SELECT cost_quantity_flag
1685: , raw_cost_flag
1686: , burdened_cost_flag
1687: , rev_quantity_flag
1688: FROM pa_budget_entry_methods
1689: WHERE budget_entry_method_code = p_budget_entry_method_code
1690: AND trunc(sysdate) BETWEEN trunc(start_date_active) and trunc(nvl(end_date_active,sysdate));
1691:
1692: l_api_name CONSTANT VARCHAR2(30) := 'check_entry_method_flags';