DBA Data[Home] [Help]

APPS.IGS_FI_CRDAPI_UTIL dependencies on HZ_PARTIES

Line 1183: sapanigr 12-Feb-2006 Bug#5018036 - Cursor c_valid_person now uses hz_parties instead of igs_fi_parties_v. (R12 SQL Repository tuning)

1179:
1180: Known limitations,enhancements,remarks:
1181: Change History
1182: Who When What
1183: sapanigr 12-Feb-2006 Bug#5018036 - Cursor c_valid_person now uses hz_parties instead of igs_fi_parties_v. (R12 SQL Repository tuning)
1184: vvutukur 13-Sep-2003 Enh#3045007.Payment Plans Build. Modified the code so that the function validates if the
1185: input person is on an Active Payment Plan if the input credit class is Installment Payments.
1186: ***********************************************************************************************/
1187: CURSOR c_valid_person( cp_party_id igs_fi_parties_v.person_id%TYPE,

Line 1191: FROM hz_parties

1187: CURSOR c_valid_person( cp_party_id igs_fi_parties_v.person_id%TYPE,
1188: cp_party_type igs_fi_parties_v.party_type%TYPE
1189: ) IS
1190: SELECT 'x'
1191: FROM hz_parties
1192: WHERE party_id = cp_party_id
1193: AND party_type = cp_party_type;
1194: rec_valid_person c_valid_person%ROWTYPE;
1195: