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_IN_TAX_UTILS dependencies on PAY_BALANCE_PKG

Line 731: p_hra_tbl(i) := pay_balance_pkg.get_value(l_hra_alw_bal_id , l_assact_tbl(i)) +

727: end if ;
728:
729: for i in 1..l_assact_tbl.count loop
730: IF l_assact_tbl(i) > 0 THEN
731: p_hra_tbl(i) := pay_balance_pkg.get_value(l_hra_alw_bal_id , l_assact_tbl(i)) +
732: pay_balance_pkg.get_value(l_hra_advance_alw_bal_id , l_assact_tbl(i));
733: p_hra_sal_tbl(i) := pay_balance_pkg.get_value(l_hra_sal_bal_id , l_assact_tbl(i)) ;
734: ELSE
735: p_hra_tbl(i) := 0 ;

Line 732: pay_balance_pkg.get_value(l_hra_advance_alw_bal_id , l_assact_tbl(i));

728:
729: for i in 1..l_assact_tbl.count loop
730: IF l_assact_tbl(i) > 0 THEN
731: p_hra_tbl(i) := pay_balance_pkg.get_value(l_hra_alw_bal_id , l_assact_tbl(i)) +
732: pay_balance_pkg.get_value(l_hra_advance_alw_bal_id , l_assact_tbl(i));
733: p_hra_sal_tbl(i) := pay_balance_pkg.get_value(l_hra_sal_bal_id , l_assact_tbl(i)) ;
734: ELSE
735: p_hra_tbl(i) := 0 ;
736: p_hra_sal_tbl(i) := 0 ;

Line 733: p_hra_sal_tbl(i) := pay_balance_pkg.get_value(l_hra_sal_bal_id , l_assact_tbl(i)) ;

729: for i in 1..l_assact_tbl.count loop
730: IF l_assact_tbl(i) > 0 THEN
731: p_hra_tbl(i) := pay_balance_pkg.get_value(l_hra_alw_bal_id , l_assact_tbl(i)) +
732: pay_balance_pkg.get_value(l_hra_advance_alw_bal_id , l_assact_tbl(i));
733: p_hra_sal_tbl(i) := pay_balance_pkg.get_value(l_hra_sal_bal_id , l_assact_tbl(i)) ;
734: ELSE
735: p_hra_tbl(i) := 0 ;
736: p_hra_sal_tbl(i) := 0 ;
737: END IF;

Line 1065: l_taxable_hra_asg_ytd := pay_balance_pkg.get_value(l_taxable_hra_def_bal_id,

1061: --
1062: -- There is no update on the rent paid information this year
1063: hr_utility.trace('INHRA: --tax_unit_id =>'||l_current_gre);
1064:
1065: l_taxable_hra_asg_ytd := pay_balance_pkg.get_value(l_taxable_hra_def_bal_id,
1066: p_assact_id ,
1067: null,
1068: null,
1069: null,

Line 1126: l_taxable_hra_asg_ptd := pay_balance_pkg.get_value(l_taxable_hra_ptd_bal_id,

1122: END LOOP ;
1123:
1124: l_taxable_hra_ptd_bal_id := get_defined_balance('Taxable House Rent Allowance', '_ASG_PTD') ;
1125:
1126: l_taxable_hra_asg_ptd := pay_balance_pkg.get_value(l_taxable_hra_ptd_bal_id,
1127: p_assact_id ,
1128: null,
1129: null,
1130: null,

Line 1139: l_taxable_hra_proj_ptd := pay_balance_pkg.get_value(l_taxable_hra_proj_bal_id,

1135: 'TRUE');
1136:
1137: l_taxable_hra_proj_bal_id := get_defined_balance('Taxable House Rent Allowance for Projection', '_ASG_PTD') ;
1138:
1139: l_taxable_hra_proj_ptd := pay_balance_pkg.get_value(l_taxable_hra_proj_bal_id,
1140: p_assact_id ,
1141: null,
1142: null,
1143: null,

Line 2123: l_hra := pay_balance_pkg.get_value(l_def_bal_id,l_assact_tbl(i))

2119: END IF;
2120: /* Bug 4224201 Ends */
2121: CLOSE c_claim_80gg_flag;
2122:
2123: l_hra := pay_balance_pkg.get_value(l_def_bal_id,l_assact_tbl(i))
2124: + pay_balance_pkg.get_value(l_def_bal_id_advance,l_assact_tbl(i));
2125:
2126: l_adj_tot_inc := pay_balance_pkg.get_value(l_def_bal_id_80gg,l_assact_tbl(i));
2127: l_25percent_adj_tot_inc := 0.25 * l_adj_tot_inc;

Line 2124: + pay_balance_pkg.get_value(l_def_bal_id_advance,l_assact_tbl(i));

2120: /* Bug 4224201 Ends */
2121: CLOSE c_claim_80gg_flag;
2122:
2123: l_hra := pay_balance_pkg.get_value(l_def_bal_id,l_assact_tbl(i))
2124: + pay_balance_pkg.get_value(l_def_bal_id_advance,l_assact_tbl(i));
2125:
2126: l_adj_tot_inc := pay_balance_pkg.get_value(l_def_bal_id_80gg,l_assact_tbl(i));
2127: l_25percent_adj_tot_inc := 0.25 * l_adj_tot_inc;
2128: l_10percent_adj_tot_inc := p_std_exem_percent * l_adj_tot_inc;

Line 2126: l_adj_tot_inc := pay_balance_pkg.get_value(l_def_bal_id_80gg,l_assact_tbl(i));

2122:
2123: l_hra := pay_balance_pkg.get_value(l_def_bal_id,l_assact_tbl(i))
2124: + pay_balance_pkg.get_value(l_def_bal_id_advance,l_assact_tbl(i));
2125:
2126: l_adj_tot_inc := pay_balance_pkg.get_value(l_def_bal_id_80gg,l_assact_tbl(i));
2127: l_25percent_adj_tot_inc := 0.25 * l_adj_tot_inc;
2128: l_10percent_adj_tot_inc := p_std_exem_percent * l_adj_tot_inc;
2129:
2130: IF l_hra = 0 AND l_80gg_flag = 'Y' THEN

Line 2565: l_balance_value := pay_balance_pkg.get_value

2561: END IF;
2562:
2563: IF p_context_name = 'NULL' THEN
2564: pay_in_utils.set_location(g_debug,l_procedure, 30);
2565: l_balance_value := pay_balance_pkg.get_value
2566: (p_assignment_action_id => p_assignment_action_id
2567: ,p_defined_balance_id => l_def_bal_id
2568: ,p_tax_unit_id => null
2569: ,p_jurisdiction_code => null

Line 2591: pay_balance_pkg.set_context(p_context_name, p_context_value);

2587: pay_in_utils.set_location(g_debug,l_procedure, 50);
2588: l_balance_value := -1;
2589: ELSE
2590: pay_in_utils.set_location(g_debug,l_procedure, 60);
2591: pay_balance_pkg.set_context(p_context_name, p_context_value);
2592: IF p_context_name = 'SOURCE_ID' THEN
2593: pay_in_utils.set_location(g_debug,l_procedure, 70);
2594: l_balance_value := pay_balance_pkg.get_value
2595: (p_assignment_action_id => p_assignment_action_id

Line 2594: l_balance_value := pay_balance_pkg.get_value

2590: pay_in_utils.set_location(g_debug,l_procedure, 60);
2591: pay_balance_pkg.set_context(p_context_name, p_context_value);
2592: IF p_context_name = 'SOURCE_ID' THEN
2593: pay_in_utils.set_location(g_debug,l_procedure, 70);
2594: l_balance_value := pay_balance_pkg.get_value
2595: (p_assignment_action_id => p_assignment_action_id
2596: ,p_defined_balance_id => l_def_bal_id
2597: ,p_tax_unit_id => null
2598: ,p_jurisdiction_code => null

Line 2610: l_balance_value := pay_balance_pkg.get_value

2606: ,p_source_number => null
2607: );
2608: ELSIF p_context_name = 'SOURCE_TEXT' THEN
2609: pay_in_utils.set_location(g_debug,l_procedure, 80);
2610: l_balance_value := pay_balance_pkg.get_value
2611: (p_assignment_action_id => p_assignment_action_id
2612: ,p_defined_balance_id => l_def_bal_id
2613: ,p_tax_unit_id => null
2614: ,p_jurisdiction_code => null

Line 2626: l_balance_value := pay_balance_pkg.get_value

2622: ,p_source_number => null
2623: );
2624: ELSIF p_context_name = 'SOURCE_TEXT2' THEN
2625: pay_in_utils.set_location(g_debug,l_procedure, 90);
2626: l_balance_value := pay_balance_pkg.get_value
2627: (p_assignment_action_id => p_assignment_action_id
2628: ,p_defined_balance_id => l_def_bal_id
2629: ,p_tax_unit_id => null
2630: ,p_jurisdiction_code => null

Line 2642: l_balance_value := pay_balance_pkg.get_value

2638: ,p_source_number => null
2639: );
2640: ELSIF p_context_name = 'JURISDICTION_CODE' THEN
2641: pay_in_utils.set_location(g_debug,l_procedure, 100);
2642: l_balance_value := pay_balance_pkg.get_value
2643: (p_assignment_action_id => p_assignment_action_id
2644: ,p_defined_balance_id => l_def_bal_id
2645: ,p_tax_unit_id => null
2646: ,p_jurisdiction_code => p_context_value

Line 2658: l_balance_value := pay_balance_pkg.get_value

2654: ,p_source_number => null
2655: );
2656: ELSIF p_context_name = 'TAX_UNIT_ID' THEN
2657: pay_in_utils.set_location(g_debug,l_procedure, 110);
2658: l_balance_value := pay_balance_pkg.get_value
2659: (p_assignment_action_id => p_assignment_action_id
2660: ,p_defined_balance_id => l_def_bal_id
2661: ,p_tax_unit_id => TO_NUMBER(p_context_value)
2662: ,p_jurisdiction_code => null

Line 3275: pay_balance_pkg.set_context('IN',p_context_name, p_context_value);

3271: pay_in_utils.trace('p_context_name',p_context_name);
3272: pay_in_utils.trace('p_context_value',p_context_value);
3273: END IF;
3274:
3275: pay_balance_pkg.set_context('IN',p_context_name, p_context_value);
3276:
3277: pay_in_utils.trace('**************************************************','********************');
3278: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
3279:

Line 3403: l_balance_value := pay_balance_pkg.get_value

3399:
3400:
3401: IF p_context_name = 'SOURCE_TEXT2' THEN
3402:
3403: l_balance_value := pay_balance_pkg.get_value
3404: (p_assignment_action_id => p_assignment_action_id
3405: ,p_defined_balance_id => l_def_bal_id
3406: ,p_tax_unit_id => p_tax_unit_id
3407: ,p_jurisdiction_code => null

Line 3419: l_balance_value := pay_balance_pkg.get_value

3415: ,p_source_number => null
3416: );
3417: ELSIF p_context_name = 'TAX_UNIT_ID' THEN
3418:
3419: l_balance_value := pay_balance_pkg.get_value
3420: (p_assignment_action_id => p_assignment_action_id
3421: ,p_defined_balance_id => l_def_bal_id
3422: ,p_tax_unit_id => p_tax_unit_id
3423: ,p_jurisdiction_code => null

Line 3615: l_balance_value := pay_balance_pkg.get_value

3611: l_balance_value :=0;
3612: ELSE
3613: l_def_bal_id := pay_in_tax_utils.get_defined_balance(p_balance_name, '_ASG_LE_PTD');
3614:
3615: l_balance_value := pay_balance_pkg.get_value
3616: (p_assignment_action_id => l_assignment_action_id
3617: ,p_defined_balance_id => l_def_bal_id
3618: ,p_tax_unit_id => p_tax_unit_id
3619: ,p_jurisdiction_code => null