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 PER_ALL_PEOPLE_F

Line 1223: FROM per_all_people_f ppf

1219: RETURN VARCHAR2 IS
1220:
1221: CURSOR c1 IS
1222: SELECT full_name
1223: FROM per_all_people_f ppf
1224: WHERE ppf.person_id = p_person_id
1225: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1226:
1227: v_name VARCHAR2(240);

Line 2505: from per_all_people_f

2501: function get_emp_term_flag(txn_id varchar2) return varchar2 is
2502: term_flag varchar2(1);
2503: cursor term_cur is
2504: select nvl(current_employee_flag,'N')
2505: from per_all_people_f
2506: where person_id = get_person_id(txn_id)
2507: and sysdate between effective_start_date and effective_end_date;
2508: begin
2509: open term_cur;