APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on PAY_ELEMENT_TYPES_F

Line 115: from pay_element_types_f pet

111: -- pabodla : mapping data
112: --
113: cursor c_get_mapping_name1(p_id in number,p_date in date) is
114: select pet.element_name element_name
115: from pay_element_types_f pet
116: where (pet.business_group_id is null
117: or pet.business_group_id = p_business_group_id)
118: and pet.element_type_id = p_id
119: and p_date between nvl(pet.effective_start_date,p_date)

Line 124: from pay_element_types_f

120: and nvl(pet.effective_end_date,p_date) ;
121:
122: cursor c_element_type_start_date(c_element_type_id number) is
123: select min(effective_start_date) effective_start_date
124: from pay_element_types_f
125: where element_type_id = c_element_type_id;
126:
127: cursor c_get_mapping_name2(p_id in number, p_id1 in number, p_date in date) is
128: select piv.name name

Line 179: l_element_type_start_date pay_element_types_f.effective_start_date%type;

175: l_input_value_name pay_input_values_f.name%type;
176:
177: l_abr_acty_base_rt_esd ben_acty_base_rt_f.effective_start_date%type;
178:
179: l_element_type_start_date pay_element_types_f.effective_start_date%type;
180: l_input_value_start_date pay_input_values_f.effective_start_date%type;
181:
182: ---------------------------------------------------------------
183: -- END OF BEN_ACTY_BASE_RT_F ----------------------