APPS.IGS_FI_PRC_APPL dependencies on IGS_FI_PARTIES_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 466: sapanigr 12-Feb-2006 Bug#5018036 - Cursor cur_fund_auth now uses base tables directly instead of igs_fi_parties_v. (R12 SQL Repository tuning)

462: Who When What
463: akandreg 17-May-2006 Bug 5134636: Added code logic for locking and trapping the exception
464: sapanigr 24-Feb-2006 Bug#5018036 - Cursor cur_person broken into three separate cursors: cur_person_group_id, cur_person_id, cur_all_person_id.
465: to resolve non mergable view.
466: sapanigr 12-Feb-2006 Bug#5018036 - Cursor cur_fund_auth now uses base tables directly instead of igs_fi_parties_v. (R12 SQL Repository tuning)
467: pathipat 04-Nov-2005 Bug 4634950 - Modified CUR_CREDITS - removed unwanted join with igs_fi_cr_types_all
468: sapanigr 20-Sep-2005 Enh#4228665. Modified CUR_CREDITS to select APPL_HIERARCHY_ID also from table IGS_FI_CR_TYPES_ALL
469: Modified CUR_HIERARCHIES.
470: Modified code logic to pass APPL_HIERARCHY_ID from CUR_CREDITS to CUR_HIERARCHIES

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;

Line 665: l_person_number igs_fi_parties_v.person_number%TYPE;

661: TYPE tab_party_rec IS TABLE OF hz_parties.party_id%TYPE INDEX BY BINARY_INTEGER;
662: v_tab_party_rec tab_party_rec ;
663: l_person_id hz_parties.party_id%TYPE;
664:
665: l_person_number igs_fi_parties_v.person_number%TYPE;
666: l_credit_type_name igs_fi_cr_types.credit_type_name%TYPE;
667:
668: -- cursor rowtype variables
669: l_credits cur_credits%ROWTYPE;