APPS.IGS_FI_PRC_STDNT_DPSTS dependencies on HZ_PARTIES

Line 488: sapanigr 12-Feb-2006 Bug#5018036 - Cursor c_person now queries hz_parties instead of

484: enhancements,
485: remarks :
486: Change History
487: Who When What
488: sapanigr 12-Feb-2006 Bug#5018036 - Cursor c_person now queries hz_parties instead of
489: igs_fi_parties_v. (R12 SQL Repository tuning)
490: vchappid 09-Jan-2003 Bug# 2729935, Invalid Value token is removed from all parameters when the
491: input parameter is an invalid value
492: ******************************************************************/

Line 494: CURSOR c_person (cp_n_person_id hz_parties.party_id%TYPE)

490: vchappid 09-Jan-2003 Bug# 2729935, Invalid Value token is removed from all parameters when the
491: input parameter is an invalid value
492: ******************************************************************/
493:
494: CURSOR c_person (cp_n_person_id hz_parties.party_id%TYPE)
495: IS
496: SELECT party_number
497: FROM hz_parties
498: WHERE party_id = cp_n_person_id;

Line 497: FROM hz_parties

493:
494: CURSOR c_person (cp_n_person_id hz_parties.party_id%TYPE)
495: IS
496: SELECT party_number
497: FROM hz_parties
498: WHERE party_id = cp_n_person_id;
499:
500: l_c_person_number hz_parties.party_number%TYPE;
501: l_v_message_text fnd_new_messages.message_text%TYPE;

Line 500: l_c_person_number hz_parties.party_number%TYPE;

496: SELECT party_number
497: FROM hz_parties
498: WHERE party_id = cp_n_person_id;
499:
500: l_c_person_number hz_parties.party_number%TYPE;
501: l_v_message_text fnd_new_messages.message_text%TYPE;
502: l_b_return_val BOOLEAN;
503:
504: BEGIN