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.IGS_RE_GEN_003 dependencies on IGS_RE_SPRVSR

Line 269: v_person_id IGS_RE_SPRVSR.person_id%TYPE;

265: v_tracking_id IGS_TR_ITEM.tracking_id%TYPE;
266: v_target_days NUMBER;
267: v_tracking_type IGS_TR_TYPE.tracking_type%TYPE;
268: v_tracking_status IGS_TR_STATUS.tracking_status%TYPE;
269: v_person_id IGS_RE_SPRVSR.person_id%TYPE;
270: v_start_dt IGS_TR_ITEM.start_dt%TYPE;
271: v_business_days_ind IGS_TR_ITEM.business_days_ind%TYPE;
272: v_action_dt IGS_TR_STEP_V.action_dt%TYPE;
273: v_current_person_id IGS_PE_PERSON.person_id%TYPE;

Line 281: FROM IGS_RE_SPRVSR rsup,

277: FROM fnd_user
278: WHERE user_id = fnd_global.user_id;
279: CURSOR c_rst_rsup IS
280: SELECT rsup.person_id
281: FROM IGS_RE_SPRVSR rsup,
282: IGS_RE_SPRVSR_TYPE rst
283: WHERE rsup.ca_person_id = p_person_id AND
284: rsup.ca_sequence_number = p_ca_sequence_number AND
285: rst.research_supervisor_type = rsup.research_supervisor_type AND

Line 282: IGS_RE_SPRVSR_TYPE rst

278: WHERE user_id = fnd_global.user_id;
279: CURSOR c_rst_rsup IS
280: SELECT rsup.person_id
281: FROM IGS_RE_SPRVSR rsup,
282: IGS_RE_SPRVSR_TYPE rst
283: WHERE rsup.ca_person_id = p_person_id AND
284: rsup.ca_sequence_number = p_ca_sequence_number AND
285: rst.research_supervisor_type = rsup.research_supervisor_type AND
286: rst.principal_supervisor_ind = 'Y'

Line 892: v_person_id IGS_RE_SPRVSR.person_id%TYPE;

888: v_tracking_id IGS_TR_ITEM.tracking_id%TYPE;
889: v_target_days NUMBER;
890: v_tracking_type IGS_TR_TYPE.tracking_type%TYPE;
891: v_tracking_status IGS_TR_STATUS.tracking_status%TYPE;
892: v_person_id IGS_RE_SPRVSR.person_id%TYPE;
893: v_start_dt IGS_TR_ITEM.start_dt%TYPE;
894: v_business_days_ind IGS_TR_ITEM.business_days_ind%TYPE;
895: v_action_dt IGS_TR_STEP_V.action_dt%TYPE;
896: CURSOR c_pe IS

Line 902: FROM IGS_RE_SPRVSR rsup,

898: FROM fnd_user
899: WHERE user_id = fnd_global.user_id;
900: CURSOR c_rst_rsup IS
901: SELECT rsup.person_id
902: FROM IGS_RE_SPRVSR rsup,
903: IGS_RE_SPRVSR_TYPE rst
904: WHERE rsup.ca_person_id = p_ca_person_id AND
905: rsup.ca_sequence_number = p_ca_sequence_number AND
906: rst.research_supervisor_type = rsup.research_supervisor_type AND

Line 903: IGS_RE_SPRVSR_TYPE rst

899: WHERE user_id = fnd_global.user_id;
900: CURSOR c_rst_rsup IS
901: SELECT rsup.person_id
902: FROM IGS_RE_SPRVSR rsup,
903: IGS_RE_SPRVSR_TYPE rst
904: WHERE rsup.ca_person_id = p_ca_person_id AND
905: rsup.ca_sequence_number = p_ca_sequence_number AND
906: rst.research_supervisor_type = rsup.research_supervisor_type AND
907: rst.principal_supervisor_ind = 'Y'