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_FIN_LT_CHG dependencies on IGS_LOOKUP_VALUES

Line 616: l_v_tran_type igs_lookup_values.meaning%TYPE := lookup_desc('TRANSACTION_TYPE',p_cur_plan.plan_type);

612:
613: l_v_currency igs_fi_control_all.currency_cd%TYPE;
614: l_v_curr_desc fnd_currencies_tl.name%TYPE;
615: l_v_message_name fnd_new_messages.message_name%TYPE;
616: l_v_tran_type igs_lookup_values.meaning%TYPE := lookup_desc('TRANSACTION_TYPE',p_cur_plan.plan_type);
617: l_v_pmt_plan igs_lookup_values.meaning%TYPE := lookup_desc('IGS_FI_LOCKBOX','PAYMENT_PLAN');
618: l_v_instl_due igs_lookup_values.meaning%TYPE := lookup_desc('IGS_FI_LOCKBOX','INSTALLMENT_DUE');
619:
620: l_n_waiver_amount NUMBER;

Line 617: l_v_pmt_plan igs_lookup_values.meaning%TYPE := lookup_desc('IGS_FI_LOCKBOX','PAYMENT_PLAN');

613: l_v_currency igs_fi_control_all.currency_cd%TYPE;
614: l_v_curr_desc fnd_currencies_tl.name%TYPE;
615: l_v_message_name fnd_new_messages.message_name%TYPE;
616: l_v_tran_type igs_lookup_values.meaning%TYPE := lookup_desc('TRANSACTION_TYPE',p_cur_plan.plan_type);
617: l_v_pmt_plan igs_lookup_values.meaning%TYPE := lookup_desc('IGS_FI_LOCKBOX','PAYMENT_PLAN');
618: l_v_instl_due igs_lookup_values.meaning%TYPE := lookup_desc('IGS_FI_LOCKBOX','INSTALLMENT_DUE');
619:
620: l_n_waiver_amount NUMBER;
621: BEGIN

Line 618: l_v_instl_due igs_lookup_values.meaning%TYPE := lookup_desc('IGS_FI_LOCKBOX','INSTALLMENT_DUE');

614: l_v_curr_desc fnd_currencies_tl.name%TYPE;
615: l_v_message_name fnd_new_messages.message_name%TYPE;
616: l_v_tran_type igs_lookup_values.meaning%TYPE := lookup_desc('TRANSACTION_TYPE',p_cur_plan.plan_type);
617: l_v_pmt_plan igs_lookup_values.meaning%TYPE := lookup_desc('IGS_FI_LOCKBOX','PAYMENT_PLAN');
618: l_v_instl_due igs_lookup_values.meaning%TYPE := lookup_desc('IGS_FI_LOCKBOX','INSTALLMENT_DUE');
619:
620: l_n_waiver_amount NUMBER;
621: BEGIN
622:

Line 1469: with igs_lookup_values, changed lookup_type to YES_NO from SYS_YES_NO

1465: sapanigr 13-Feb-2006 Bug 5018036 - Modified cur_fee to reference base table igs_fi_f_typ_ca_inst_all and igs_ca_inst ci.
1466: It was earlier using igs_fi_f_typ_ca_inst_lkp_v.
1467: pmarada 01-sep-04 bug 3687308 - Enforcing user to pass either person id or personid group
1468: pathipat 26-Apr-2004 Bug 3578249 - Modified cursor cur_yes_no - Replaced fnd_lookup_values
1469: with igs_lookup_values, changed lookup_type to YES_NO from SYS_YES_NO
1470: Changed code related to p_test_flag to check for Y and N instead of 1 and 2 respectively.
1471: vvutukur 20-Jan-2004 Bug#3348787.Modified cursor cur_yes_no.
1472: vvutukur 17-Sep-2003 Enh#3045007.Payment Plans Build. Changes specific to Payment Plans TD.
1473: shtatiko 22-APR-2003 Enh# 2831569, Added check for Manage Accounts System Option.

Line 1504: FROM igs_lookup_values

1500: l_cur_fee cur_fee%ROWTYPE;
1501:
1502: CURSOR cur_yes_no IS
1503: SELECT meaning
1504: FROM igs_lookup_values
1505: WHERE lookup_type = 'YES_NO'
1506: AND lookup_code = p_test_flag;
1507:
1508: l_cur_yes_no cur_yes_no%ROWTYPE;