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.PAY_BALANCE_PKG dependencies on PAY_DIMENSION_ROUTES

Line 117: balance_type_column pay_dimension_routes.balance_type_column%type,

113: expiry_check_code pay_balance_dimensions.expiry_checking_code%type,
114: expiry_check_lvl pay_balance_dimensions.expiry_checking_level%type,
115: dimension_name pay_balance_dimensions.dimension_name%type,
116: jurisdiction_lvl pay_balance_types.jurisdiction_level%type,
117: balance_type_column pay_dimension_routes.balance_type_column%type,
118: decode_required pay_dimension_routes.decode_required%type,
119: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
120: dimension_lvl pay_balance_dimensions.dimension_level%type,
121: period_type pay_balance_dimensions.period_type%type,

Line 118: decode_required pay_dimension_routes.decode_required%type,

114: expiry_check_lvl pay_balance_dimensions.expiry_checking_level%type,
115: dimension_name pay_balance_dimensions.dimension_name%type,
116: jurisdiction_lvl pay_balance_types.jurisdiction_level%type,
117: balance_type_column pay_dimension_routes.balance_type_column%type,
118: decode_required pay_dimension_routes.decode_required%type,
119: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
120: dimension_lvl pay_balance_dimensions.dimension_level%type,
121: period_type pay_balance_dimensions.period_type%type,
122: balance_type_id pay_balance_types.balance_type_id%type,

Line 123: dim_rou_rr_route_id pay_dimension_routes.route_id%type,

119: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
120: dimension_lvl pay_balance_dimensions.dimension_level%type,
121: period_type pay_balance_dimensions.period_type%type,
122: balance_type_id pay_balance_types.balance_type_id%type,
123: dim_rou_rr_route_id pay_dimension_routes.route_id%type,
124: tu_needed boolean,
125: jc_needed boolean,
126: si_needed boolean,
127: sn_needed boolean,

Line 151: priority pay_dimension_routes.priority%type,

147: --
148: type t_dim_rou_rec is record
149: (
150: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
151: priority pay_dimension_routes.priority%type,
152: route_type pay_dimension_routes.route_type%type,
153: run_def_bal_id pay_defined_balances.defined_balance_id%type,
154: retrieval_column pay_dimension_routes.retrieval_column%type
155: );

Line 152: route_type pay_dimension_routes.route_type%type,

148: type t_dim_rou_rec is record
149: (
150: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
151: priority pay_dimension_routes.priority%type,
152: route_type pay_dimension_routes.route_type%type,
153: run_def_bal_id pay_defined_balances.defined_balance_id%type,
154: retrieval_column pay_dimension_routes.retrieval_column%type
155: );
156: --

Line 154: retrieval_column pay_dimension_routes.retrieval_column%type

150: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
151: priority pay_dimension_routes.priority%type,
152: route_type pay_dimension_routes.route_type%type,
153: run_def_bal_id pay_defined_balances.defined_balance_id%type,
154: retrieval_column pay_dimension_routes.retrieval_column%type
155: );
156: --
157: type t_dim_rou_tab is table of t_dim_rou_rec index by binary_integer;
158: --

Line 793: from pay_dimension_routes pdr

789: , pdr.priority
790: , pdr.route_type
791: , null run_def_bal_id
792: , pdr.retrieval_column
793: from pay_dimension_routes pdr
794: , pay_defined_balances pdb -- balance defined balance
795: where pdb.balance_dimension_id = pdr.balance_dimension_id
796: and pdb.defined_balance_id = p_def_bal_id
797: and pdr.route_type = 'RR';

Line 806: from pay_dimension_routes pdr

802: , pdr.priority
803: , pdr.route_type
804: , rdb.defined_balance_id run_def_bal_id
805: , pdr.retrieval_column
806: from pay_dimension_routes pdr
807: , pay_defined_balances pdb -- balance defined balance
808: , pay_defined_balances rdb -- run defined balance
809: where pdb.balance_dimension_id = pdr.balance_dimension_id
810: and pdb.defined_balance_id = p_def_bal_id

Line 861: from pay_dimension_routes pdr

857: pdr.route_id
858: into g_defbal_cache(p_defined_balance_id).balance_type_column,
859: g_defbal_cache(p_defined_balance_id).decode_required,
860: g_defbal_cache(p_defined_balance_id).dim_rou_rr_route_id
861: from pay_dimension_routes pdr
862: , pay_defined_balances pdb
863: where pdb.balance_dimension_id = pdr.balance_dimension_id
864: and pdb.defined_balance_id = p_defined_balance_id
865: and pdr.route_type = 'RR';

Line 3060: l_route_id pay_dimension_routes.route_id%type;

3056: l_business_group_id ff_user_entities.business_group_id%type;
3057: l_legislation_code ff_user_entities.legislation_code%type;
3058: l_balance_list t_batch_list;
3059: l_balance_type_id pay_defined_balances.balance_type_id%type;
3060: l_route_id pay_dimension_routes.route_id%type;
3061: l_balance_type_column pay_dimension_routes.balance_type_column%type;
3062: l_retrieval_column pay_dimension_routes.retrieval_column%type;
3063: l_decode_required boolean;
3064: l_decode_required_chr pay_dimension_routes.decode_required%type;

Line 3061: l_balance_type_column pay_dimension_routes.balance_type_column%type;

3057: l_legislation_code ff_user_entities.legislation_code%type;
3058: l_balance_list t_batch_list;
3059: l_balance_type_id pay_defined_balances.balance_type_id%type;
3060: l_route_id pay_dimension_routes.route_id%type;
3061: l_balance_type_column pay_dimension_routes.balance_type_column%type;
3062: l_retrieval_column pay_dimension_routes.retrieval_column%type;
3063: l_decode_required boolean;
3064: l_decode_required_chr pay_dimension_routes.decode_required%type;
3065: l_jur_lvl pay_balance_types.jurisdiction_level%type;

Line 3062: l_retrieval_column pay_dimension_routes.retrieval_column%type;

3058: l_balance_list t_batch_list;
3059: l_balance_type_id pay_defined_balances.balance_type_id%type;
3060: l_route_id pay_dimension_routes.route_id%type;
3061: l_balance_type_column pay_dimension_routes.balance_type_column%type;
3062: l_retrieval_column pay_dimension_routes.retrieval_column%type;
3063: l_decode_required boolean;
3064: l_decode_required_chr pay_dimension_routes.decode_required%type;
3065: l_jur_lvl pay_balance_types.jurisdiction_level%type;
3066: --

Line 3064: l_decode_required_chr pay_dimension_routes.decode_required%type;

3060: l_route_id pay_dimension_routes.route_id%type;
3061: l_balance_type_column pay_dimension_routes.balance_type_column%type;
3062: l_retrieval_column pay_dimension_routes.retrieval_column%type;
3063: l_decode_required boolean;
3064: l_decode_required_chr pay_dimension_routes.decode_required%type;
3065: l_jur_lvl pay_balance_types.jurisdiction_level%type;
3066: --
3067: BEGIN
3068: if g_debug then

Line 3090: pay_dimension_routes pdr,

3086: l_retrieval_column,
3087: l_decode_required_chr,
3088: l_jur_lvl
3089: from pay_defined_balances pdb,
3090: pay_dimension_routes pdr,
3091: pay_balance_types pbt
3092: where pdb.defined_balance_id = p_def_bal_id
3093: and pdb.balance_dimension_id = pdr.balance_dimension_id
3094: and pbt.balance_type_id = pdb.balance_type_id

Line 3335: from pay_dimension_routes pdr

3331: select pdr.run_dimension_id
3332: , pdr.priority
3333: , pdr.route_type
3334: , rdb.defined_balance_id run_def_bal_id
3335: from pay_dimension_routes pdr
3336: , pay_defined_balances pdb -- balance defined balance
3337: , pay_defined_balances rdb -- run defined balance
3338: where pdb.balance_dimension_id = pdr.balance_dimension_id
3339: and pdb.defined_balance_id = p_def_bal_id