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

Line 106: p_balance_type IN igs_lookup_values.lookup_code%TYPE,

102:
103:
104: PROCEDURE calculate_balance(
105: p_person_id IN igs_pe_person_v.person_id%TYPE,
106: p_balance_type IN igs_lookup_values.lookup_code%TYPE,
107: p_balance_date IN igs_fi_balances.balance_date%TYPE,
108: p_action IN VARCHAR2,
109: p_balance_rule_id IN igs_fi_balance_rules.balance_rule_id%TYPE,
110: p_balance_amount OUT NOCOPY igs_fi_balances.standard_balance%TYPE,

Line 476: l_hold_bal_type CONSTANT igs_lookup_values.lookup_code%TYPE := 'HOLDS';

472:
473: --following local variables are declared as part of enh#2562745.
474: l_action_active CONSTANT VARCHAR2(10):= 'ACTIVE';
475: l_action_max CONSTANT VARCHAR2(10):= 'MAX';
476: l_hold_bal_type CONSTANT igs_lookup_values.lookup_code%TYPE := 'HOLDS';
477: l_fee_bal_type CONSTANT igs_lookup_values.lookup_code%TYPE := 'FEE';
478: l_std_bal_type CONSTANT igs_lookup_values.lookup_code%TYPE := 'STANDARD';
479:
480: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE := NULL;

Line 477: l_fee_bal_type CONSTANT igs_lookup_values.lookup_code%TYPE := 'FEE';

473: --following local variables are declared as part of enh#2562745.
474: l_action_active CONSTANT VARCHAR2(10):= 'ACTIVE';
475: l_action_max CONSTANT VARCHAR2(10):= 'MAX';
476: l_hold_bal_type CONSTANT igs_lookup_values.lookup_code%TYPE := 'HOLDS';
477: l_fee_bal_type CONSTANT igs_lookup_values.lookup_code%TYPE := 'FEE';
478: l_std_bal_type CONSTANT igs_lookup_values.lookup_code%TYPE := 'STANDARD';
479:
480: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE := NULL;
481: l_last_conversion_date DATE := NULL;

Line 478: l_std_bal_type CONSTANT igs_lookup_values.lookup_code%TYPE := 'STANDARD';

474: l_action_active CONSTANT VARCHAR2(10):= 'ACTIVE';
475: l_action_max CONSTANT VARCHAR2(10):= 'MAX';
476: l_hold_bal_type CONSTANT igs_lookup_values.lookup_code%TYPE := 'HOLDS';
477: l_fee_bal_type CONSTANT igs_lookup_values.lookup_code%TYPE := 'FEE';
478: l_std_bal_type CONSTANT igs_lookup_values.lookup_code%TYPE := 'STANDARD';
479:
480: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE := NULL;
481: l_last_conversion_date DATE := NULL;
482: l_version_number igs_fi_balance_rules.version_number%TYPE := NULL;

Line 911: l_std_bal igs_lookup_values.lookup_code%TYPE := 'STANDARD';

907: -------------------------------------------------------------------------------
908: l_fee_type igs_fi_inv_int_v.fee_type%TYPE;
909: l_credit_type_id igs_fi_credits_v.credit_type_id%TYPE;
910: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE := p_balance_rule_id;
911: l_std_bal igs_lookup_values.lookup_code%TYPE := 'STANDARD';
912: l_sysdate DATE := TRUNC(SYSDATE);
913: l_lkp_type igs_lookup_values.lookup_type%TYPE := 'IGS_FI_BALANCE_TYPE';
914:
915: CURSOR c_bal_type(cp_balance_type igs_fi_balance_rules.balance_name%TYPE) IS

Line 913: l_lkp_type igs_lookup_values.lookup_type%TYPE := 'IGS_FI_BALANCE_TYPE';

909: l_credit_type_id igs_fi_credits_v.credit_type_id%TYPE;
910: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE := p_balance_rule_id;
911: l_std_bal igs_lookup_values.lookup_code%TYPE := 'STANDARD';
912: l_sysdate DATE := TRUNC(SYSDATE);
913: l_lkp_type igs_lookup_values.lookup_type%TYPE := 'IGS_FI_BALANCE_TYPE';
914:
915: CURSOR c_bal_type(cp_balance_type igs_fi_balance_rules.balance_name%TYPE) IS
916: SELECT 'X'
917: FROM igs_lookup_values

Line 917: FROM igs_lookup_values

913: l_lkp_type igs_lookup_values.lookup_type%TYPE := 'IGS_FI_BALANCE_TYPE';
914:
915: CURSOR c_bal_type(cp_balance_type igs_fi_balance_rules.balance_name%TYPE) IS
916: SELECT 'X'
917: FROM igs_lookup_values
918: WHERE lookup_type = l_lkp_type
919: AND lookup_code = cp_balance_type
920: AND lookup_code NOT IN ('INSTALLMENT','OTHER')
921: AND enabled_flag = 'Y'