eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_GENERAL dependencies on PAY_ELEMENT_TYPES_F

Line 1476: FROM pay_element_types_f

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;

Line 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;

Line 1497: FROM pay_element_types_f

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

Line 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:

Line 1504: l_element_name pay_element_types_f.element_name%TYPE;

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;

Line 3781: , pay_element_types_f petf

3777: RETURN NUMBER IS
3778: CURSOR c_poeta_setup_element_entries IS
3779: SELECT 1
3780: FROM psp_element_types pet
3781: , pay_element_types_f petf
3782: , pay_element_entries_f peef
3783: WHERE pet.element_type_id = petf.element_type_id
3784: AND peef.element_type_id = petf.element_type_id
3785: AND peef.entry_information3 = nvl (p_project_id, peef.entry_information3)