DBA Data[Home] [Help]

APPS.PA_BUDGET_CHECK_PVT dependencies on PA_BUDGET_ENTRY_METHODS

Line 1048: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )

1044:
1045: -- needed to get the flags associated to a budget entry method
1046:
1047: CURSOR l_budget_entry_method_csr
1048: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )
1049: IS
1050: SELECT cost_quantity_flag
1051: , raw_cost_flag
1052: , burdened_cost_flag

Line 1055: FROM pa_budget_entry_methods

1051: , raw_cost_flag
1052: , burdened_cost_flag
1053: , rev_quantity_flag
1054: , revenue_flag
1055: FROM pa_budget_entry_methods
1056: WHERE budget_entry_method_code = p_budget_entry_method_code
1057: AND trunc(sysdate) BETWEEN trunc(start_date_active) and trunc(nvl(end_date_active,sysdate));
1058:
1059: l_api_name CONSTANT VARCHAR2(30) := 'check_entry_method_flags';