APPS.IGR_I_A_PKGITM_PKG dependencies on IGS_PE_HZ_PARTIES

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

65: p_inserting IN BOOLEAN DEFAULT FALSE,
66: p_updating IN BOOLEAN DEFAULT FALSE,
67: p_deleting IN BOOLEAN DEFAULT FALSE
68: ) as
69: CURSOR c_deceased(cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
70: SELECT deceased_ind
71: FROM igs_pe_hz_parties
72: WHERE party_id = cp_party_id;
73: v_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;

Line 71: FROM igs_pe_hz_parties

67: p_deleting IN BOOLEAN DEFAULT FALSE
68: ) as
69: CURSOR c_deceased(cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
70: SELECT deceased_ind
71: FROM igs_pe_hz_parties
72: WHERE party_id = cp_party_id;
73: v_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;
74: v_message_name varchar2(30);
75: BEGIN

Line 73: v_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;

69: CURSOR c_deceased(cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
70: SELECT deceased_ind
71: FROM igs_pe_hz_parties
72: WHERE party_id = cp_party_id;
73: v_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;
74: v_message_name varchar2(30);
75: BEGIN
76: -- Fetch the Deceased Indicator
77: IF p_inserting OR p_updating THEN