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 1042: p_hra_tbl(i) := pay_balance_pkg.get_value(l_hra_alw_bal_id , l_assact_tbl(i)) +

1038: end if ;
1039:
1040: for i in 1..l_assact_tbl.count loop
1041: IF l_assact_tbl(i) > 0 THEN
1042: p_hra_tbl(i) := pay_balance_pkg.get_value(l_hra_alw_bal_id , l_assact_tbl(i)) +
1043: pay_balance_pkg.get_value(l_hra_advance_alw_bal_id , l_assact_tbl(i));
1044: p_hra_sal_tbl(i) := pay_balance_pkg.get_value(l_hra_sal_bal_id , l_assact_tbl(i)) ;
1045: ELSE
1046: p_hra_tbl(i) := 0 ;

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

1039:
1040: for i in 1..l_assact_tbl.count loop
1041: IF l_assact_tbl(i) > 0 THEN
1042: p_hra_tbl(i) := pay_balance_pkg.get_value(l_hra_alw_bal_id , l_assact_tbl(i)) +
1043: pay_balance_pkg.get_value(l_hra_advance_alw_bal_id , l_assact_tbl(i));
1044: p_hra_sal_tbl(i) := pay_balance_pkg.get_value(l_hra_sal_bal_id , l_assact_tbl(i)) ;
1045: ELSE
1046: p_hra_tbl(i) := 0 ;
1047: p_hra_sal_tbl(i) := 0 ;

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

1040: for i in 1..l_assact_tbl.count loop
1041: IF l_assact_tbl(i) > 0 THEN
1042: p_hra_tbl(i) := pay_balance_pkg.get_value(l_hra_alw_bal_id , l_assact_tbl(i)) +
1043: pay_balance_pkg.get_value(l_hra_advance_alw_bal_id , l_assact_tbl(i));
1044: p_hra_sal_tbl(i) := pay_balance_pkg.get_value(l_hra_sal_bal_id , l_assact_tbl(i)) ;
1045: ELSE
1046: p_hra_tbl(i) := 0 ;
1047: p_hra_sal_tbl(i) := 0 ;
1048: END IF;

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

1396: --
1397: -- There is no update on the rent paid information this year
1398: hr_utility.trace('INHRA: --tax_unit_id =>'||l_current_gre);
1399:
1400: l_taxable_hra_asg_ytd := pay_balance_pkg.get_value(l_taxable_hra_def_bal_id,
1401: p_assact_id ,
1402: null,
1403: null,
1404: null,

Line 1412: l_ret_tax_hra_asg_ytd := pay_balance_pkg.get_value(l_ret_tax_hra_def_bal_id,

1408: null,
1409: 'TRUE');
1410: -- Start of Bug 11821281
1411:
1412: l_ret_tax_hra_asg_ytd := pay_balance_pkg.get_value(l_ret_tax_hra_def_bal_id,
1413: p_assact_id ,
1414: null,
1415: null,
1416: null,

Line 1482: l_taxable_hra_ASG_DE_PTD := pay_balance_pkg.get_value(l_taxable_hra_ptd_bal_id,

1478: END IF;
1479:
1480: l_taxable_hra_ptd_bal_id := get_defined_balance('Taxable House Rent Allowance', '_ASG_DE_PTD') ;
1481:
1482: l_taxable_hra_ASG_DE_PTD := pay_balance_pkg.get_value(l_taxable_hra_ptd_bal_id,
1483: p_assact_id ,
1484: null,
1485: null,
1486: null,

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

1491: 'TRUE');
1492:
1493: l_taxable_hra_proj_bal_id := get_defined_balance('Taxable House Rent Allowance for Projection', '_ASG_DE_PTD') ;
1494:
1495: l_taxable_hra_proj_ptd := pay_balance_pkg.get_value(l_taxable_hra_proj_bal_id,
1496: p_assact_id ,
1497: null,
1498: null,
1499: null,

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

2554: END IF;
2555: /* Bug 4224201 Ends */
2556: CLOSE c_80gg_flag;
2557:
2558: l_hra := pay_balance_pkg.get_value(l_def_bal_id,l_assact_tbl(i))
2559: + pay_balance_pkg.get_value(l_def_bal_id_advance,l_assact_tbl(i));
2560:
2561: l_adj_tot_inc := pay_balance_pkg.get_value(l_def_bal_id_80gg,l_assact_tbl(i));
2562: l_25percent_adj_tot_inc := 0.25 * l_adj_tot_inc;

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

2555: /* Bug 4224201 Ends */
2556: CLOSE c_80gg_flag;
2557:
2558: l_hra := pay_balance_pkg.get_value(l_def_bal_id,l_assact_tbl(i))
2559: + pay_balance_pkg.get_value(l_def_bal_id_advance,l_assact_tbl(i));
2560:
2561: l_adj_tot_inc := pay_balance_pkg.get_value(l_def_bal_id_80gg,l_assact_tbl(i));
2562: l_25percent_adj_tot_inc := 0.25 * l_adj_tot_inc;
2563: l_10percent_adj_tot_inc := p_std_exem_percent * l_adj_tot_inc;

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

2557:
2558: l_hra := pay_balance_pkg.get_value(l_def_bal_id,l_assact_tbl(i))
2559: + pay_balance_pkg.get_value(l_def_bal_id_advance,l_assact_tbl(i));
2560:
2561: l_adj_tot_inc := pay_balance_pkg.get_value(l_def_bal_id_80gg,l_assact_tbl(i));
2562: l_25percent_adj_tot_inc := 0.25 * l_adj_tot_inc;
2563: l_10percent_adj_tot_inc := p_std_exem_percent * l_adj_tot_inc;
2564:
2565: IF l_hra = 0 AND l_80gg_flag = 'Y' THEN

Line 3001: l_balance_value := pay_balance_pkg.get_value

2997: END IF;
2998:
2999: IF p_context_name = 'NULL' THEN
3000: pay_in_utils.set_location(g_debug,l_procedure, 30);
3001: l_balance_value := pay_balance_pkg.get_value
3002: (p_assignment_action_id => p_assignment_action_id
3003: ,p_defined_balance_id => l_def_bal_id
3004: ,p_tax_unit_id => null
3005: ,p_jurisdiction_code => null

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

3023: pay_in_utils.set_location(g_debug,l_procedure, 50);
3024: l_balance_value := -1;
3025: ELSE
3026: pay_in_utils.set_location(g_debug,l_procedure, 60);
3027: pay_balance_pkg.set_context(p_context_name, p_context_value);
3028: IF p_context_name = 'SOURCE_ID' THEN
3029: pay_in_utils.set_location(g_debug,l_procedure, 70);
3030: l_balance_value := pay_balance_pkg.get_value
3031: (p_assignment_action_id => p_assignment_action_id

Line 3030: l_balance_value := pay_balance_pkg.get_value

3026: pay_in_utils.set_location(g_debug,l_procedure, 60);
3027: pay_balance_pkg.set_context(p_context_name, p_context_value);
3028: IF p_context_name = 'SOURCE_ID' THEN
3029: pay_in_utils.set_location(g_debug,l_procedure, 70);
3030: l_balance_value := pay_balance_pkg.get_value
3031: (p_assignment_action_id => p_assignment_action_id
3032: ,p_defined_balance_id => l_def_bal_id
3033: ,p_tax_unit_id => null
3034: ,p_jurisdiction_code => null

Line 3046: l_balance_value := pay_balance_pkg.get_value

3042: ,p_source_number => null
3043: );
3044: ELSIF p_context_name = 'SOURCE_TEXT' THEN
3045: pay_in_utils.set_location(g_debug,l_procedure, 80);
3046: l_balance_value := pay_balance_pkg.get_value
3047: (p_assignment_action_id => p_assignment_action_id
3048: ,p_defined_balance_id => l_def_bal_id
3049: ,p_tax_unit_id => null
3050: ,p_jurisdiction_code => null

Line 3062: l_balance_value := pay_balance_pkg.get_value

3058: ,p_source_number => null
3059: );
3060: ELSIF p_context_name = 'SOURCE_TEXT2' THEN
3061: pay_in_utils.set_location(g_debug,l_procedure, 90);
3062: l_balance_value := pay_balance_pkg.get_value
3063: (p_assignment_action_id => p_assignment_action_id
3064: ,p_defined_balance_id => l_def_bal_id
3065: ,p_tax_unit_id => null
3066: ,p_jurisdiction_code => null

Line 3078: l_balance_value := pay_balance_pkg.get_value

3074: ,p_source_number => null
3075: );
3076: ELSIF p_context_name = 'JURISDICTION_CODE' THEN
3077: pay_in_utils.set_location(g_debug,l_procedure, 100);
3078: l_balance_value := pay_balance_pkg.get_value
3079: (p_assignment_action_id => p_assignment_action_id
3080: ,p_defined_balance_id => l_def_bal_id
3081: ,p_tax_unit_id => null
3082: ,p_jurisdiction_code => p_context_value

Line 3094: l_balance_value := pay_balance_pkg.get_value

3090: ,p_source_number => null
3091: );
3092: ELSIF p_context_name = 'TAX_UNIT_ID' THEN
3093: pay_in_utils.set_location(g_debug,l_procedure, 110);
3094: l_balance_value := pay_balance_pkg.get_value
3095: (p_assignment_action_id => p_assignment_action_id
3096: ,p_defined_balance_id => l_def_bal_id
3097: ,p_tax_unit_id => TO_NUMBER(p_context_value)
3098: ,p_jurisdiction_code => null

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

4324: pay_in_utils.trace('p_context_name',p_context_name);
4325: pay_in_utils.trace('p_context_value',p_context_value);
4326: END IF;
4327:
4328: pay_balance_pkg.set_context('IN',p_context_name, p_context_value);
4329:
4330: pay_in_utils.trace('**************************************************','********************');
4331: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
4332:

Line 4456: l_balance_value := pay_balance_pkg.get_value

4452:
4453:
4454: IF p_context_name = 'SOURCE_TEXT2' THEN
4455:
4456: l_balance_value := pay_balance_pkg.get_value
4457: (p_assignment_action_id => p_assignment_action_id
4458: ,p_defined_balance_id => l_def_bal_id
4459: ,p_tax_unit_id => p_tax_unit_id
4460: ,p_jurisdiction_code => null

Line 4472: l_balance_value := pay_balance_pkg.get_value

4468: ,p_source_number => null
4469: );
4470: ELSIF p_context_name = 'TAX_UNIT_ID' THEN
4471:
4472: l_balance_value := pay_balance_pkg.get_value
4473: (p_assignment_action_id => p_assignment_action_id
4474: ,p_defined_balance_id => l_def_bal_id
4475: ,p_tax_unit_id => p_tax_unit_id
4476: ,p_jurisdiction_code => null

Line 4668: l_balance_value := pay_balance_pkg.get_value

4664: l_balance_value :=0;
4665: ELSE
4666: l_def_bal_id := pay_in_tax_utils.get_defined_balance(p_balance_name, '_ASG_LE_DE_PTD');
4667:
4668: l_balance_value := pay_balance_pkg.get_value
4669: (p_assignment_action_id => l_assignment_action_id
4670: ,p_defined_balance_id => l_def_bal_id
4671: ,p_tax_unit_id => p_tax_unit_id
4672: ,p_jurisdiction_code => null