DBA Data[Home] [Help]

APPS.IGS_PE_FELONY_DTLS_PKG dependencies on IGS_PE_HZ_PARTIES

Line 139: --Purpose: To check the flag status of felony_convicted_flag in igs_pe_hz_parties table and

135: ----------------------------------------------------------------------------------------------
136: --Created by : skpandey
137: --Date created: 04-JUL-2005
138: --
139: --Purpose: To check the flag status of felony_convicted_flag in igs_pe_hz_parties table and
140: -- convict_ind and display error message according to Business Rule
141: --Known limitations/enhancements and/or remarks:
142: --
143: --Change History:

Line 150: FROM igs_pe_hz_parties

146: -- Changed the cursor felony_convicted_flag_cur Open and Close logic
147: ----------------------------------------------------------------------------------------------
148: CURSOR felony_convicted_flag_cur IS
149: SELECT felony_convicted_flag
150: FROM igs_pe_hz_parties
151: WHERE party_id = new_references.person_id;
152:
153: x_felony_convicted_flag VARCHAR2(1);
154: