DBA Data[Home] [Help]

APPS.IGS_PE_WF_GEN dependencies on IGS_PE_PERSON_BASE_V

Line 108: FROM igs_pe_person_base_v

104: ******************************************************************/
105:
106: CURSOR c_get_person_name(cp_person_id NUMBER) IS
107: SELECT full_name person_name,person_number
108: FROM igs_pe_person_base_v
109: WHERE person_id = cp_person_id;
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,

Line 1338: FROM igs_pe_person_base_v

1334: vskumar 23-May-2006 bug 5211157 forward port the procedure from bug 2882588.
1335: ******************************************************************/
1336: CURSOR person_dtl_cur(cp_person_id NUMBER) IS
1337: SELECT person_number, full_name
1338: FROM igs_pe_person_base_v
1339: WHERE person_id = cp_person_id;
1340:
1341: CURSOR acad_intent_dtl_cur (cp_lookup_code VARCHAR2, cp_lookup_type VARCHAR2) IS
1342: SELECT meaning