APPS.IGS_PE_WF_GEN dependencies on IGS_PE_RES_DTLS_ALL

Line 128: l_res_dtls_id igs_pe_res_dtls_all.resident_details_id%TYPE;

124: SELECT user_name
125: FROM fnd_user
126: WHERE user_id = cp_user_id;
127:
128: l_res_dtls_id igs_pe_res_dtls_all.resident_details_id%TYPE;
129: l_old_res_status igs_pe_res_dtls_all.residency_status_cd%TYPE;
130: l_old_eval_date DATE;
131: l_old_evaluator igs_pe_res_dtls_all.evaluator%TYPE;
132: l_old_comments igs_pe_res_dtls_all.comments%TYPE;

Line 129: l_old_res_status igs_pe_res_dtls_all.residency_status_cd%TYPE;

125: FROM fnd_user
126: WHERE user_id = cp_user_id;
127:
128: l_res_dtls_id igs_pe_res_dtls_all.resident_details_id%TYPE;
129: l_old_res_status igs_pe_res_dtls_all.residency_status_cd%TYPE;
130: l_old_eval_date DATE;
131: l_old_evaluator igs_pe_res_dtls_all.evaluator%TYPE;
132: l_old_comments igs_pe_res_dtls_all.comments%TYPE;
133: l_res_status_desc igs_lookup_values.meaning%TYPE;

Line 131: l_old_evaluator igs_pe_res_dtls_all.evaluator%TYPE;

127:
128: l_res_dtls_id igs_pe_res_dtls_all.resident_details_id%TYPE;
129: l_old_res_status igs_pe_res_dtls_all.residency_status_cd%TYPE;
130: l_old_eval_date DATE;
131: l_old_evaluator igs_pe_res_dtls_all.evaluator%TYPE;
132: l_old_comments igs_pe_res_dtls_all.comments%TYPE;
133: l_res_status_desc igs_lookup_values.meaning%TYPE;
134: l_user_name fnd_user.user_name%TYPE;
135: l_date DATE;

Line 132: l_old_comments igs_pe_res_dtls_all.comments%TYPE;

128: l_res_dtls_id igs_pe_res_dtls_all.resident_details_id%TYPE;
129: l_old_res_status igs_pe_res_dtls_all.residency_status_cd%TYPE;
130: l_old_eval_date DATE;
131: l_old_evaluator igs_pe_res_dtls_all.evaluator%TYPE;
132: l_old_comments igs_pe_res_dtls_all.comments%TYPE;
133: l_res_status_desc igs_lookup_values.meaning%TYPE;
134: l_user_name fnd_user.user_name%TYPE;
135: l_date DATE;
136: l_action VARCHAR2(30);