DBA Data[Home] [Help]

APPS.IGS_FI_REFUNDS_PROCESS dependencies on HZ_PARTIES

Line 119: 2. Cursor cur_pers changed to query hz_parties instead of igs_fi_parties_v

115: Change History
116: Who When What
117: sapanigr 14-Feb-2006 Bug#5018036 - 1. Cursor cur_date modified to use igs_fi_f_typ_ca_inst_all and igs_ca_inst
118: instead of igs_fi_f_typ_ca_inst_lkp_v
119: 2. Cursor cur_pers changed to query hz_parties instead of igs_fi_parties_v
120:
121: ********************************************************************************************** */
122:
123: CURSOR cur_pers(cp_person_id hz_parties.party_id%TYPE) IS

Line 123: CURSOR cur_pers(cp_person_id hz_parties.party_id%TYPE) IS

119: 2. Cursor cur_pers changed to query hz_parties instead of igs_fi_parties_v
120:
121: ********************************************************************************************** */
122:
123: CURSOR cur_pers(cp_person_id hz_parties.party_id%TYPE) IS
124: SELECT party_number
125: FROM hz_parties
126: WHERE party_id= cp_person_id;
127: l_cur_pers cur_pers%ROWTYPE;

Line 125: FROM hz_parties

121: ********************************************************************************************** */
122:
123: CURSOR cur_pers(cp_person_id hz_parties.party_id%TYPE) IS
124: SELECT party_number
125: FROM hz_parties
126: WHERE party_id= cp_person_id;
127: l_cur_pers cur_pers%ROWTYPE;
128:
129: CURSOR cur_inv IS

Line 540: sapanigr 14-Feb-2006 Bug #5018036. Cursor cur_pers modified to query hz_parties instead of igs_fi_parties_v

536: of the refund record accordingly.
537: Known limitations,enhancements,remarks:
538: Change History
539: Who When What
540: sapanigr 14-Feb-2006 Bug #5018036. Cursor cur_pers modified to query hz_parties instead of igs_fi_parties_v
541: ridas 13-Feb-2006 Bug #5021084. Added new parameter lv_group_type in call to igf_ap_ss_pkg.get_pid
542: pathipat 23-Apr-2003 Enh 2831569 - Commercial Receivables build
543: Added validation for manage_account - call to chk_manage_account()
544: Added code to log messages for test run = Y and for no-data-found cases

Line 555: CURSOR cur_pers(cp_person_id hz_parties.party_id%TYPE) IS

551: vvutukur 03-Jan-2003 Bug#2727216.Modified the logic for logging the parameters, by removing the
552: redundant code.
553: vchappid 13-Jun-2002 Bug#2411529, Incorrectly used message name has been modified
554: ********************************************************************************************** */
555: CURSOR cur_pers(cp_person_id hz_parties.party_id%TYPE) IS
556: SELECT party_number
557: FROM hz_parties
558: WHERE party_id=cp_person_id;
559: l_cur_pers cur_pers%ROWTYPE;

Line 557: FROM hz_parties

553: vchappid 13-Jun-2002 Bug#2411529, Incorrectly used message name has been modified
554: ********************************************************************************************** */
555: CURSOR cur_pers(cp_person_id hz_parties.party_id%TYPE) IS
556: SELECT party_number
557: FROM hz_parties
558: WHERE party_id=cp_person_id;
559: l_cur_pers cur_pers%ROWTYPE;
560:
561: -- Cursor for validating Person Id Group