APPS.IGS_UC_TRAN_PROCESSOR_PKG dependencies on IGS_PE_HZ_PARTIES

Line 65: SELECT b.deceased_ind FROM igs_uc_applicants a,igs_pe_hz_parties b

61: (reverse chronological order - newest change first)
62: ***************************************************************/
63:
64: CURSOR cur_find_deceased IS
65: SELECT b.deceased_ind FROM igs_uc_applicants a,igs_pe_hz_parties b
66: WHERE a.app_no = P_App_no AND a.oss_person_id = b.party_id;
67:
68: -- 29-MAY-2006 anwest Bug #5190520 UCTD320 - UCAS 2006 CLEARING ISSUES
69: CURSOR cur_find_trans(cp_transaction_type igs_uc_transactions.transaction_type%TYPE) IS

Line 131: l_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;

127: l_decision igs_uc_app_choices.decision%TYPE;
128: l_reply igs_uc_app_choices.reply%TYPE;
129: l_cnt NUMBER;
130: l_cnt1 NUMBER;
131: l_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;
132: l_return1 igs_uc_transactions.return1%TYPE;
133: l_return2 igs_uc_transactions.return2%TYPE;
134: l_generate VARCHAR2(1);
135: l_generate_tran VARCHAR2(1);