APPS.IGS_PE_GEN_001 dependencies on IGS_CA_INST

Line 421: p_cal_type igs_ca_inst.cal_type%TYPE,

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: /*
425: || Created By : ssawhney

Line 422: p_sequence_number igs_ca_inst.sequence_number%TYPE

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: /*
425: || Created By : ssawhney
426: || Created On : 8-nov-2004

Line 437: cp_cal_type igs_ca_inst.cal_type%TYPE,

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
441: FROM igs_pe_res_dtls_all

Line 438: cp_sequence_number igs_ca_inst.sequence_number%TYPE

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
441: FROM igs_pe_res_dtls_all
442: WHERE person_id = cp_person_id AND

Line 449: CURSOR c_ca ( cp_cal_type igs_ca_inst.cal_type%TYPE,

445: sequence_number = cp_sequence_number;
446: residency_rec c_residency%ROWTYPE;
447:
448:
449: CURSOR c_ca ( cp_cal_type igs_ca_inst.cal_type%TYPE,
450: cp_sequence_number igs_ca_inst.sequence_number%TYPE
451: ) IS
452: SELECT cal.start_dt, cal.end_dt FROM igs_ca_inst cal
453: WHERE cal.cal_type = cp_cal_type AND

Line 450: cp_sequence_number igs_ca_inst.sequence_number%TYPE

446: residency_rec c_residency%ROWTYPE;
447:
448:
449: CURSOR c_ca ( cp_cal_type igs_ca_inst.cal_type%TYPE,
450: cp_sequence_number igs_ca_inst.sequence_number%TYPE
451: ) IS
452: SELECT cal.start_dt, cal.end_dt FROM igs_ca_inst cal
453: WHERE cal.cal_type = cp_cal_type AND
454: cal.sequence_number = cp_sequence_number;

Line 452: SELECT cal.start_dt, cal.end_dt FROM igs_ca_inst cal

448:
449: CURSOR c_ca ( cp_cal_type igs_ca_inst.cal_type%TYPE,
450: cp_sequence_number igs_ca_inst.sequence_number%TYPE
451: ) IS
452: SELECT cal.start_dt, cal.end_dt FROM igs_ca_inst cal
453: WHERE cal.cal_type = cp_cal_type AND
454: cal.sequence_number = cp_sequence_number;
455: ca_rec c_ca%ROWTYPE;
456:

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