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_DISC_SUA dependencies on IGS_LOOKUPS_VIEW

Line 157: FROM igs_lookups_view

153: AND enabled_flag='Y';
154:
155: CURSOR cur_test_run(cp_test_run IN VARCHAR2) IS
156: SELECT meaning
157: FROM igs_lookups_view
158: WHERE lookup_type = g_lookup_type_tr
159: AND lookup_code = cp_test_run;
160:
161: l_var VARCHAR2(1);

Line 164: l_test_run igs_lookups_view.meaning%TYPE;

160:
161: l_var VARCHAR2(1);
162: l_flag BOOLEAN;
163: rec_cur_person_id cur_person_id%ROWTYPE;
164: l_test_run igs_lookups_view.meaning%TYPE;
165: l_balance_type_meaning igs_lookups_view.meaning%TYPE;
166: l_dcnt_reason_cd_desc igs_en_dcnt_reasoncd_v.description%TYPE;
167: l_person_grp_cd igs_pe_persid_group.group_cd%TYPE;
168:

Line 165: l_balance_type_meaning igs_lookups_view.meaning%TYPE;

161: l_var VARCHAR2(1);
162: l_flag BOOLEAN;
163: rec_cur_person_id cur_person_id%ROWTYPE;
164: l_test_run igs_lookups_view.meaning%TYPE;
165: l_balance_type_meaning igs_lookups_view.meaning%TYPE;
166: l_dcnt_reason_cd_desc igs_en_dcnt_reasoncd_v.description%TYPE;
167: l_person_grp_cd igs_pe_persid_group.group_cd%TYPE;
168:
169: BEGIN