DBA Data[Home] [Help]

APPS.GMD_COMMON_VAL dependencies on CM_MTHD_MST

Line 2129: SELECT cost_type from cm_mthd_mst

2125: Period_code = pPeriod_code AND
2126: period_status = 1;
2127:
2128: CURSOR Get_Cost_type IS
2129: SELECT cost_type from cm_mthd_mst
2130: WHERE cost_mthd_code = pCost_mthd_code;
2131:
2132: CURSOR Get_Recipe_id(vValidity_Rule_id NUMBER) IS
2133: SELECT recipe_id from gmd_recipe_validity_rules

Line 2956: SELECT cost_type from cm_mthd_mst

2952: WHERE period_id = l_period_id AND
2953: period_status = 'F';
2954:
2955: CURSOR Get_Cost_type IS
2956: SELECT cost_type from cm_mthd_mst
2957: WHERE cost_type_id = pCost_type_id;
2958:
2959: CURSOR Get_Recipe_id(vValidity_Rule_id NUMBER) IS
2960: SELECT recipe_id from gmd_recipe_validity_rules