APPS.IGR_I_A_ITYPE_PKG dependencies on IGS_PE_HZ_PARTIES

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

59: p_inserting IN BOOLEAN DEFAULT FALSE,
60: p_updating IN BOOLEAN DEFAULT FALSE,
61: p_deleting IN BOOLEAN DEFAULT FALSE
62: ) as
63: CURSOR c_deceased(cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
64: SELECT deceased_ind
65: FROM igs_pe_hz_parties
66: WHERE party_id = cp_party_id;
67:

Line 65: FROM igs_pe_hz_parties

61: p_deleting IN BOOLEAN DEFAULT FALSE
62: ) as
63: CURSOR c_deceased(cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
64: SELECT deceased_ind
65: FROM igs_pe_hz_parties
66: WHERE party_id = cp_party_id;
67:
68: CURSOR c_information_type (p_info_type_id igr_i_info_types_v.info_type_id%TYPE) IS
69: SELECT information_type

Line 73: v_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;

69: SELECT information_type
70: FROM igr_i_info_types_v
71: WHERE info_type_id =p_info_type_id ;
72:
73: v_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;
74: v_message_name varchar2(30);
75: p_enquiry_information_type igr_i_info_types_v.information_type%TYPE;
76: BEGIN
77: -- Fetch the Deceased Indicator