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.PER_IN_DISABILITY_LEG_HOOK dependencies on PER_DISABILITIES_F

Line 255: l_person_id per_disabilities_f.person_id%TYPE;

251: IS
252: --
253: l_procedure VARCHAR2(100);
254: l_message VARCHAR2(255);
255: l_person_id per_disabilities_f.person_id%TYPE;
256: l_category VARCHAR2(20);
257: l_status VARCHAR2(20);
258: l_degree NUMBER;
259: l_dis_information1 VARCHAR2(3);

Line 264: FROM per_disabilities_f

260: --
261:
262: CURSOR c_person_id IS
263: SELECT person_id,category,status,degree,dis_information1
264: FROM per_disabilities_f
265: WHERE disability_id = p_disability_id
266: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
267:
268: BEGIN