DBA Data[Home] [Help]

APPS.GMD_COMMON_VAL dependencies on GMF_PERIOD_STATUSES

Line 2938: SELECT period_id from gmf_period_statuses

2934: TYPE VRtbl IS TABLE OF GMD_RECIPE_VALIDITY_RULES.Recipe_Validity_Rule_Id%TYPE;
2935: VRList VRtbl;
2936:
2937: CURSOR Get_period_id IS
2938: SELECT period_id from gmf_period_statuses
2939: WHERE Legal_Entity_Id = pLegal_entity_id AND
2940: Calendar_code = pCalendar_code AND
2941: Period_code = pPeriod_code AND
2942: Cost_type_id = pCost_type_id ;

Line 2951: SELECT count(*) FROM gmf_period_statuses

2947: cost_type_id = pCost_type_id AND
2948: ROLLOVER_IND = 1;
2949:
2950: CURSOR Get_Period_Status IS
2951: SELECT count(*) FROM gmf_period_statuses
2952: WHERE period_id = l_period_id AND
2953: period_status = 'F';
2954:
2955: CURSOR Get_Cost_type IS