DBA Data[Home] [Help]

APPS.PAY_CN_ELEMENT_TEMPLATE_PKG dependencies on PAY_INPUT_VALUES_F

Line 299: FROM pay_input_values_f

295: IF p_result_rule_type = 'D' THEN
296:
297: SELECT input_value_id
298: INTO l_input_value_id
299: FROM pay_input_values_f
300: WHERE p_effective_date BETWEEN effective_start_date
301: AND effective_end_date
302: AND business_group_id = p_business_group_id
303: AND element_type_id = p_element_type_id

Line 312: FROM pay_input_values_f piv, pay_element_types_f pet

308: SELECT piv.input_value_id
309: , pet.element_type_id
310: INTO l_input_value_id
311: , l_element_type_id
312: FROM pay_input_values_f piv, pay_element_types_f pet
313: WHERE p_effective_date BETWEEN piv.effective_start_date
314: AND piv.effective_end_date
315: AND p_effective_date BETWEEN pet.effective_start_date
316: AND pet.effective_end_date