APPS.IGR_IMP_003 dependencies on IGS_PE_HZ_PARTIES

Line 422: lv_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;

418: for the same.
419: ***************************************************************/
420:
421: -------------------------Variable Declarations-------------------------------------------------------
422: lv_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;
423:
424: lv_exist varchar2(2000);
425: l_birth_date igs_pe_person_base_v.birth_date%TYPE;
426:

Line 592: CURSOR c_deceased(cp_party_id igs_pe_hz_parties.party_id%TYPE) IS

588: AND lkupv.lookup_type='CAL_CAT' and lkupv.lookup_code = 'ADMISSION'
589: AND lkupv1.lookup_type = 'CALENDAR_STATUS' and lkupv1.lookup_code = ciav1.s_cal_status;
590:
591: -- Validation for the deceased person is added as a part of the bug #2028066
592: CURSOR c_deceased(cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
593: SELECT
594: deceased_ind
595: FROM
596: igs_pe_hz_parties

Line 596: igs_pe_hz_parties

592: CURSOR c_deceased(cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
593: SELECT
594: deceased_ind
595: FROM
596: igs_pe_hz_parties
597: WHERE
598: party_id = cp_party_id;
599:
600: -- Validation for the source_promotion_id added as a part of the Capture Campaign event