APPS.GHR_FORMULA_FUNCTIONS dependencies on GHR_PLAN_SERVICE_AREAS_F

Line 31: from ghr_plan_service_areas_f

27: and primary_flag = 'Y';
28:
29: Cursor c_check_if_nationwide_plan(l_plan_code in varchar2) is
30: select distinct 'N'
31: from ghr_plan_service_areas_f
32: where plan_short_code = l_plan_code
33: and p_effective_date between effective_start_date and effective_end_date;
34:
35: Cursor c_get_plan_duty_station(l_plan_code in varchar2

Line 38: from ghr_plan_service_areas_f

34:
35: Cursor c_get_plan_duty_station(l_plan_code in varchar2
36: ,l_ds_code in Varchar2) Is
37: select 'Y'
38: from ghr_plan_service_areas_f
39: where plan_short_code = l_plan_code
40: and ds_state_code = l_ds_code
41: and p_effective_date between effective_start_date and effective_end_date;
42:

Line 45: from ghr_plan_service_areas_f

41: and p_effective_date between effective_start_date and effective_end_date;
42:
43: Cursor c_get_plan_state(l_plan_code in varchar2,l_state_code in Varchar2) Is
44: select 'Y'
45: from ghr_plan_service_areas_f
46: where plan_short_code = l_plan_code
47: and state_short_name = l_state_code
48: and p_effective_date between effective_start_date and effective_end_date;
49: -------------------------------------------------------------------------------