DBA Data[Home] [Help]

APPS.PA_BUDGET_CHECK_PVT dependencies on PA_BUDGET_ENTRY_METHODS

Line 1070: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )

1066:
1067: -- needed to get the flags associated to a budget entry method
1068:
1069: CURSOR l_budget_entry_method_csr
1070: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )
1071: IS
1072: SELECT cost_quantity_flag
1073: , raw_cost_flag
1074: , burdened_cost_flag

Line 1077: FROM pa_budget_entry_methods

1073: , raw_cost_flag
1074: , burdened_cost_flag
1075: , rev_quantity_flag
1076: , revenue_flag
1077: FROM pa_budget_entry_methods
1078: WHERE budget_entry_method_code = p_budget_entry_method_code
1079: AND trunc(sysdate) BETWEEN trunc(start_date_active) and trunc(nvl(end_date_active,sysdate));
1080:
1081: l_api_name CONSTANT VARCHAR2(30) := 'check_entry_method_flags';