APPS.IGS_PE_WF_GEN dependencies on IGS_PE_RES_DTLS_V

Line 114: FROM igs_pe_res_dtls_v

110:
111: CURSOR res_dtl_cur(cp_resident_details_id NUMBER) IS
112: SELECT person_id, cal_type, sequence_number, residency_class, residency_class_desc, residency_status_desc,
113: calendar_desc, evaluation_date, evaluator, comments, last_updated_by
114: FROM igs_pe_res_dtls_v
115: WHERE resident_details_id = cp_resident_details_id;
116:
117: CURSOR res_status_cur (cp_lookup_type VARCHAR2, cp_lookup_code VARCHAR2) IS
118: SELECT meaning

Line 272: p_res_dtls_rec OUT NOCOPY igs_pe_res_dtls_v%ROWTYPE,

268:
269: PROCEDURE get_res_details(
270: p_person_id IN NUMBER,
271: p_res_class IN VARCHAR2,
272: p_res_dtls_rec OUT NOCOPY igs_pe_res_dtls_v%ROWTYPE,
273: p_ind IN VARCHAR2 DEFAULT 'NEW' ) IS
274:
275: /******************************************************************
276: Created By : Ashwini Bala