APPS.IGS_PE_GEN_001 dependencies on IGS_PE_RES_DTLS_ALL

Line 420: p_residency_class igs_pe_res_dtls_all.residency_class_cd%TYPE,

416: END release_hold;
417:
418: FUNCTION Get_Res_Status (
419: p_person_id hz_parties.party_id%TYPE,
420: p_residency_class igs_pe_res_dtls_all.residency_class_cd%TYPE,
421: p_cal_type igs_ca_inst.cal_type%TYPE,
422: p_sequence_number igs_ca_inst.sequence_number%TYPE
423: ) RETURN VARCHAR2 AS
424: /*

Line 436: cp_residency_class igs_pe_res_dtls_all.residency_class_cd%TYPE,

432: || (reverse chronological order - newest change first)
433: || vskumar 25-May-2006 Xbuild3 performance fix. Replace c_gap_res cursor query.
434: */
435: CURSOR c_residency ( cp_person_id hz_parties.party_id%TYPE,
436: cp_residency_class igs_pe_res_dtls_all.residency_class_cd%TYPE,
437: cp_cal_type igs_ca_inst.cal_type%TYPE,
438: cp_sequence_number igs_ca_inst.sequence_number%TYPE
439: ) IS
440: SELECT residency_status_cd

Line 441: FROM igs_pe_res_dtls_all

437: cp_cal_type igs_ca_inst.cal_type%TYPE,
438: cp_sequence_number igs_ca_inst.sequence_number%TYPE
439: ) IS
440: SELECT residency_status_cd
441: FROM igs_pe_res_dtls_all
442: WHERE person_id = cp_person_id AND
443: residency_class_cd = cp_residency_class AND
444: cal_type = cp_cal_type AND
445: sequence_number = cp_sequence_number;

Line 459: cp_residency_class igs_pe_res_dtls_all.residency_class_cd%TYPE,

455: ca_rec c_ca%ROWTYPE;
456:
457:
458: CURSOR c_gap_res ( cp_person_id hz_parties.party_id%TYPE,
459: cp_residency_class igs_pe_res_dtls_all.residency_class_cd%TYPE,
460: cp_start_dt DATE) IS
461: SELECT res.residency_status_cd, ci.start_dt
462: FROM igs_pe_res_dtls_all res,IGS_CA_INST_ALL ci
463: WHERE res.person_id = cp_person_id AND

Line 462: FROM igs_pe_res_dtls_all res,IGS_CA_INST_ALL ci

458: CURSOR c_gap_res ( cp_person_id hz_parties.party_id%TYPE,
459: cp_residency_class igs_pe_res_dtls_all.residency_class_cd%TYPE,
460: cp_start_dt DATE) IS
461: SELECT res.residency_status_cd, ci.start_dt
462: FROM igs_pe_res_dtls_all res,IGS_CA_INST_ALL ci
463: WHERE res.person_id = cp_person_id AND
464: res.residency_class_cd = cp_residency_class AND
465: res.start_dt <= cp_start_dt AND
466: res.CAL_TYPE = CI.CAL_TYPE AND