APPS.IGS_FI_GEN_REFUNDS dependencies on IGS_FI_PARTIES_V

Line 21: FUNCTION check_fund_auth(p_person_id igs_fi_parties_v.person_id%TYPE) RETURN BOOLEAN AS

17: g_refund CONSTANT VARCHAR2(10) := 'REFUND';
18: g_stoprefund CONSTANT VARCHAR2(15) := 'STOPREFUND';
19: g_borrower CONSTANT VARCHAR2(10) := 'BORROWER';
20:
21: FUNCTION check_fund_auth(p_person_id igs_fi_parties_v.person_id%TYPE) RETURN BOOLEAN AS
22:
23: /*************************************************************
24: Created By : vchappid
25: Date Created By : 01-Mar-2002

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 38: l_fund_auth igs_fi_parties_v.fund_authorization%TYPE;

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
41: -- if no record is found then the function returns FALSE else returns TRUE
42: OPEN cur_fund_auth(p_person_id);