APPS.IGS_FI_GEN_REFUNDS dependencies on IGS_PE_HZ_PARTIES

Line 30: sapanigr 13-Feb-2006 Bug 5018036. Modified cur_fund_auth to query from igs_pe_hz_parties instead of igs_fi_parties_v

26: Purpose : Identifies whether the Fund Autorization is set for the person
27: Know limitations, enhancements or remarks
28: Change History
29: Who When What
30: sapanigr 13-Feb-2006 Bug 5018036. Modified cur_fund_auth to query from igs_pe_hz_parties instead of igs_fi_parties_v
31: (reverse chronological order - newest change first)
32: ***************************************************************/
33:
34: CURSOR cur_fund_auth (cp_person_id igs_pe_hz_parties.party_id%TYPE) IS

Line 34: CURSOR cur_fund_auth (cp_person_id igs_pe_hz_parties.party_id%TYPE) IS

30: sapanigr 13-Feb-2006 Bug 5018036. Modified cur_fund_auth to query from igs_pe_hz_parties instead of igs_fi_parties_v
31: (reverse chronological order - newest change first)
32: ***************************************************************/
33:
34: CURSOR cur_fund_auth (cp_person_id igs_pe_hz_parties.party_id%TYPE) IS
35: SELECT NVL(fund_authorization,'N') fund_authorization
36: FROM igs_pe_hz_parties
37: WHERE party_id = cp_person_id;
38: l_fund_auth igs_fi_parties_v.fund_authorization%TYPE;

Line 36: FROM igs_pe_hz_parties

32: ***************************************************************/
33:
34: CURSOR cur_fund_auth (cp_person_id igs_pe_hz_parties.party_id%TYPE) IS
35: SELECT NVL(fund_authorization,'N') fund_authorization
36: FROM igs_pe_hz_parties
37: WHERE party_id = cp_person_id;
38: l_fund_auth igs_fi_parties_v.fund_authorization%TYPE;
39: BEGIN
40: -- For the person in context get the fund authorization is enabled or not