1472: FUNCTION get_element_name (p_element_type_id IN NUMBER,
1473: p_effective_date IN DATE) RETURN VARCHAR2 IS
1474: CURSOR element_name_cur IS
1475: SELECT element_name
1476: FROM pay_element_types_f
1477: WHERE element_type_id = p_element_type_id
1478: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1479:
1480: l_element_name pay_element_types_f.element_name%TYPE;
1476: FROM pay_element_types_f
1477: WHERE element_type_id = p_element_type_id
1478: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1479:
1480: l_element_name pay_element_types_f.element_name%TYPE;
1481:
1482: BEGIN
1483: OPEN element_name_cur;
1484: FETCH element_name_cur INTO l_element_name;
1493: -- Introduced the following for bug fix 4189270
1494: FUNCTION get_element_name (p_element_type_id IN NUMBER) RETURN VARCHAR2 IS
1495: CURSOR element_name_cur IS
1496: SELECT element_name
1497: FROM pay_element_types_f
1498: WHERE element_type_id = p_element_type_id
1499: AND ( (TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date)
1500: OR (effective_start_date = (SELECT MIN(effective_start_date)
1501: FROM pay_element_types_f petf2
1497: FROM pay_element_types_f
1498: WHERE element_type_id = p_element_type_id
1499: AND ( (TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date)
1500: OR (effective_start_date = (SELECT MIN(effective_start_date)
1501: FROM pay_element_types_f petf2
1502: WHERE petf2.element_type_id = p_element_type_id)));
1503:
1504: l_element_name pay_element_types_f.element_name%TYPE;
1505:
1500: OR (effective_start_date = (SELECT MIN(effective_start_date)
1501: FROM pay_element_types_f petf2
1502: WHERE petf2.element_type_id = p_element_type_id)));
1503:
1504: l_element_name pay_element_types_f.element_name%TYPE;
1505:
1506: BEGIN
1507: OPEN element_name_cur;
1508: FETCH element_name_cur INTO l_element_name;