APPS.IGS_FI_PRC_APPL dependencies on IGS_PE_PERSON_V

Line 44: sarakshi 27-Feb-2002 bug:2238362, changed the view igs_pe_person_v to igs_fi_parties_v

40: bug#2326163.
41: vvutukur 22-APR-2002 Modified as part of bug#2326163 not to show ids in log file but
42: numbers and names.
43: smadathi 28-Feb-2002 Bug. 2238413. modified mass _application procedure.
44: sarakshi 27-Feb-2002 bug:2238362, changed the view igs_pe_person_v to igs_fi_parties_v
45: masehgal 17-Jan-2002 ENH # 2170429
46: Obsoletion of SPONSOR_CD from UPDATE_ROW Call to IGS_FI_INV_INT Tablehandler
47: msrinivi 13 aug,2001 bug 1882122: Take only ch_lns with err_acc ='N'
48: sykrishn 28-JAN changes to mass application - sfcr020 - 2191470

Line 645: CURSOR cur_fund_auth (cp_person_id IN igs_pe_person_v.person_id%TYPE)

641: FROM igs_fi_cr_types
642: WHERE credit_type_id = cp_credit_type_id;
643:
644: /* cursor for getting the funds authorization for the person_id */
645: CURSOR cur_fund_auth (cp_person_id IN igs_pe_person_v.person_id%TYPE)
646: IS
647: SELECT pd.fund_authorization, p.party_number
648: --bug:2238362, changed the view igs_pe_person_v to igs_fi_parties_v
649: --bug:5018036, replaced igs_fi_person_v by base tables

Line 648: --bug:2238362, changed the view igs_pe_person_v to igs_fi_parties_v

644: /* cursor for getting the funds authorization for the person_id */
645: CURSOR cur_fund_auth (cp_person_id IN igs_pe_person_v.person_id%TYPE)
646: IS
647: SELECT pd.fund_authorization, p.party_number
648: --bug:2238362, changed the view igs_pe_person_v to igs_fi_parties_v
649: --bug:5018036, replaced igs_fi_person_v by base tables
650: FROM hz_parties p, igs_pe_hz_parties pd
651: WHERE p.party_id = cp_person_id
652: AND p.party_id = pd.party_id;