eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_PRC_APPL dependencies on IGS_FI_CR_TYPES

Line 78: igs_fi_cr_types b

74: CURSOR cur_min_date
75: IS
76: SELECT MIN(effective_date) min_date
77: FROM igs_fi_credits a,
78: igs_fi_cr_types b
79: WHERE a.credit_type_id = b.credit_type_id
80: AND b.credit_class NOT IN ('ENRDEPOSIT','OTHDEPOSIT');
81:
82: l_min_date cur_min_date%ROWTYPE;

Line 114: igs_fi_cr_types b

110: CURSOR cur_max_date
111: IS
112: SELECT MAX(effective_date) max_date
113: FROM igs_fi_credits a,
114: igs_fi_cr_types b
115: WHERE a.credit_type_id = b.credit_type_id
116: AND b.credit_class NOT IN ('ENRDEPOSIT','OTHDEPOSIT');
117:
118: l_max_date cur_max_date%ROWTYPE;

Line 467: pathipat 04-Nov-2005 Bug 4634950 - Modified CUR_CREDITS - removed unwanted join with igs_fi_cr_types_all

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
471: svuppala 07-JUL-2005 Enh 3392095 - Tution Waivers build

Line 468: sapanigr 20-Sep-2005 Enh#4228665. Modified CUR_CREDITS to select APPL_HIERARCHY_ID also from table IGS_FI_CR_TYPES_ALL

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
471: svuppala 07-JUL-2005 Enh 3392095 - Tution Waivers build
472: Modified CUR_CREDITS -- exclude credit class of 'Waiver'.

Line 533: FROM igs_fi_credits cr,igs_fi_cr_types crt

529: cp_credit_date_low DATE,
530: cp_credit_date_high DATE)
531: IS
532: SELECT cr.rowid, cr.*,crt.credit_type_name,crt.appl_hierarchy_id
533: FROM igs_fi_credits cr,igs_fi_cr_types crt
534: WHERE
535: (cr.party_id = cp_person_id OR (cp_person_id IS NULL)) AND
536: (cr.credit_number = p_credit_number OR (p_credit_number IS NULL)) AND
537: (cr.credit_type_id = p_credit_type_id OR (p_credit_type_id IS NULL)) AND

Line 638: CURSOR cur_title4_ind (cp_credit_type_id IN igs_fi_cr_types.credit_type_id%TYPE)

634: FOR UPDATE NOWAIT;
635:
636:
637: /* cursor for getting the title IV ind for the credit type id */
638: CURSOR cur_title4_ind (cp_credit_type_id IN igs_fi_cr_types.credit_type_id%TYPE)
639: IS
640: SELECT title4_type_ind
641: FROM igs_fi_cr_types
642: WHERE credit_type_id = cp_credit_type_id;

Line 641: FROM igs_fi_cr_types

637: /* cursor for getting the title IV ind for the credit type id */
638: CURSOR cur_title4_ind (cp_credit_type_id IN igs_fi_cr_types.credit_type_id%TYPE)
639: IS
640: SELECT title4_type_ind
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)

Line 656: CURSOR cur_credit_type (cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE) IS

652: AND p.party_id = pd.party_id;
653:
654: --added by vvutukur
655:
656: CURSOR cur_credit_type (cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE) IS
657: SELECT credit_type_name
658: FROM igs_fi_cr_types
659: WHERE credit_type_id = cp_credit_type_id;
660:

Line 658: FROM igs_fi_cr_types

654: --added by vvutukur
655:
656: CURSOR cur_credit_type (cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE) IS
657: SELECT credit_type_name
658: FROM igs_fi_cr_types
659: WHERE credit_type_id = cp_credit_type_id;
660:
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 ;

Line 666: l_credit_type_name igs_fi_cr_types.credit_type_name%TYPE;

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;
670: l_hierarchies cur_hierarchies%ROWTYPE;