APPS.IGS_PE_WF_GEN dependencies on IGS_LOOKUP_VALUES

Line 119: FROM igs_lookup_values

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
119: FROM igs_lookup_values
120: WHERE lookup_type = cp_lookup_type AND
121: lookup_code = cp_lookup_code;
122:
123: CURSOR updated_by_cur(cp_user_id NUMBER) IS

Line 133: l_res_status_desc igs_lookup_values.meaning%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);
137: l_name hz_person_profiles.person_name%TYPE;

Line 341: FROM igs_lookup_values

337: WHERE territory_code = cp_country;
338:
339: CURSOR get_lkup_meaning(cp_lk_code VARCHAR2) IS
340: SELECT meaning
341: FROM igs_lookup_values
342: WHERE
343: lookup_type='YES_NO' AND
344: lookup_code=cp_lk_code;
345:

Line 966: CURSOR cur_party_type (cp_lookup_type igs_lookup_values.lookup_type%TYPE,

962: --Change History:
963: --Who When What
964: -------------------------------------------------------------------------------------
965: AS
966: CURSOR cur_party_type (cp_lookup_type igs_lookup_values.lookup_type%TYPE,
967: cp_lookup_code igs_lookup_values.lookup_code%TYPE) IS
968: SELECT meaning
969: FROM igs_lookup_values
970: WHERE lookup_type=cp_lookup_type

Line 967: cp_lookup_code igs_lookup_values.lookup_code%TYPE) IS

963: --Who When What
964: -------------------------------------------------------------------------------------
965: AS
966: CURSOR cur_party_type (cp_lookup_type igs_lookup_values.lookup_type%TYPE,
967: cp_lookup_code igs_lookup_values.lookup_code%TYPE) IS
968: SELECT meaning
969: FROM igs_lookup_values
970: WHERE lookup_type=cp_lookup_type
971: AND lookup_code=cp_lookup_code;

Line 969: FROM igs_lookup_values

965: AS
966: CURSOR cur_party_type (cp_lookup_type igs_lookup_values.lookup_type%TYPE,
967: cp_lookup_code igs_lookup_values.lookup_code%TYPE) IS
968: SELECT meaning
969: FROM igs_lookup_values
970: WHERE lookup_type=cp_lookup_type
971: AND lookup_code=cp_lookup_code;
972: l_party_type igs_lookup_values.meaning%TYPE;
973:

Line 972: l_party_type igs_lookup_values.meaning%TYPE;

968: SELECT meaning
969: FROM igs_lookup_values
970: WHERE lookup_type=cp_lookup_type
971: AND lookup_code=cp_lookup_code;
972: l_party_type igs_lookup_values.meaning%TYPE;
973:
974: CURSOR cur_message_text (cp_message_name fnd_new_messages.message_name%TYPE) IS
975: SELECT message_text
976: FROM fnd_new_messages

Line 1343: FROM igs_lookup_values

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
1343: FROM igs_lookup_values
1344: WHERE lookup_type = cp_lookup_type
1345: AND lookup_code = cp_lookup_code;
1346:
1347: CURSOR term_desc_cur (cp_cal_type VARCHAR2, cp_sequence_number NUMBER) IS