APPS.IGS_PE_GEN_002 dependencies on IGS_PE_PERS_ENCUMB_V

Line 242: cp_encumbrance_type igs_pe_pers_encumb_v.encumbrance_type%TYPE,

238:
239: -- check whether release hold should be called or apply hold should be called
240: -- change view IGS_PE_PERS_ENCUMB from igs_pe_pers_pen_encumb_v
241: CURSOR c_hold_alrdy_exst(cp_person_id igs_pe_person_base_v.person_id%TYPE,
242: cp_encumbrance_type igs_pe_pers_encumb_v.encumbrance_type%TYPE,
243: cp_start_dt DATE) IS
244: SELECT
245: expiry_dt
246: FROM

Line 256: cp_encumbrance_type igs_pe_pers_encumb_v.encumbrance_type%TYPE,

252:
253: -- check for mismatch of external ref passed
254: -- remove reference to the view.
255: CURSOR c_external_hold_exst(cp_person_id igs_pe_person_base_v.person_id%TYPE,
256: cp_encumbrance_type igs_pe_pers_encumb_v.encumbrance_type%TYPE,
257: cp_start_dt DATE,
258: cp_external_reference igs_pe_pers_encumb_v.external_reference%TYPE) IS
259: SELECT
260: 'X'

Line 258: cp_external_reference igs_pe_pers_encumb_v.external_reference%TYPE) IS

254: -- remove reference to the view.
255: CURSOR c_external_hold_exst(cp_person_id igs_pe_person_base_v.person_id%TYPE,
256: cp_encumbrance_type igs_pe_pers_encumb_v.encumbrance_type%TYPE,
257: cp_start_dt DATE,
258: cp_external_reference igs_pe_pers_encumb_v.external_reference%TYPE) IS
259: SELECT
260: 'X'
261: FROM
262: igs_pe_pers_encumb

Line 270: CURSOR c_hold_eff(cp_hold_type igs_pe_pers_encumb_v.encumbrance_type%TYPE) IS

266: start_dt = cp_start_dt AND
267: external_reference = cp_external_reference;
268:
269: -- cursor to check if the hold has an effect of SUS_COURSE.
270: CURSOR c_hold_eff(cp_hold_type igs_pe_pers_encumb_v.encumbrance_type%TYPE) IS
271: SELECT 'X'
272: FROM igs_fi_enc_dflt_eft
273: WHERE encumbrance_type = cp_hold_type AND
274: s_encmb_effect_type = 'SUS_COURSE';