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_IN_TAX_UTILS

Line 1: PACKAGE BODY pay_in_tax_utils AS

1: PACKAGE BODY pay_in_tax_utils AS
2: /* $Header: pyintxut.pkb 120.24.12010000.9 2008/08/28 12:21:58 mdubasi ship $ */
3:
4: type t_rent_paid is table of number index by binary_integer ;
5: type t_assact is table of number index by binary_integer ;

Line 11: g_package CONSTANT VARCHAR2(20):= 'pay_in_tax_utils.';

7: type t_bal_value is table of number index by binary_integer ;
8: type t_eff_date is table of date index by binary_integer ;
9:
10: g_debug boolean ;
11: g_package CONSTANT VARCHAR2(20):= 'pay_in_tax_utils.';
12:
13: --------------------------------------------------------------------------
14: -- Name : get_financial_year_start --
15: -- Type : Function --

Line 497: select paa.assignment_action_id,pay_in_tax_utils.get_period_number(ppa.payroll_id,ppa.date_earned),ppa.date_earned

493: l_procedure := g_package ||'get_monthly_max_assact';
494: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure, 10);
495:
496: /*Bug:3907894 Added ppa.effective_date in the select statement and fetched it in the table l_eff_date_tbl */
497: select paa.assignment_action_id,pay_in_tax_utils.get_period_number(ppa.payroll_id,ppa.date_earned),ppa.date_earned
498: bulk collect into l_assact_tbl,l_month_number_tbl,l_eff_date_tbl
499: from pay_payroll_Actions ppa,
500: pay_assignment_Actions paa,
501: per_assignments_f asg -- Added to remove NMV as per bug 4774108

Line 909: l_year_start := pay_in_tax_utils.get_financial_year_start(p_effective_date );

905: WHERE paa.assignment_id=b.assignment_id );
906:
907: -- get tax year start ,tax year end and assignment end date in case of terminations
908: --
909: l_year_start := pay_in_tax_utils.get_financial_year_start(p_effective_date );
910: l_year_end := pay_in_tax_utils.get_financial_year_end(p_effective_date );
911: l_check_date :=LEAST (l_asg_end_date,l_year_end);
912:
913: ------------------------------

Line 910: l_year_end := pay_in_tax_utils.get_financial_year_end(p_effective_date );

906:
907: -- get tax year start ,tax year end and assignment end date in case of terminations
908: --
909: l_year_start := pay_in_tax_utils.get_financial_year_start(p_effective_date );
910: l_year_end := pay_in_tax_utils.get_financial_year_end(p_effective_date );
911: l_check_date :=LEAST (l_asg_end_date,l_year_end);
912:
913: ------------------------------
914: /*To get current gre_id */

Line 1631: l_year_start := pay_in_tax_utils.get_financial_year_start(p_date_earned);

1627: pay_in_utils.trace('p_assignment_action_id',p_assignment_action_id);
1628: pay_in_utils.trace('p_date_earned',p_date_earned);
1629: END IF;
1630:
1631: l_year_start := pay_in_tax_utils.get_financial_year_start(p_date_earned);
1632: l_year_end := pay_in_tax_utils.get_financial_year_end(p_date_earned);
1633:
1634: l_curr_mon := to_char(p_date_earned,'MON');
1635:

Line 1632: l_year_end := pay_in_tax_utils.get_financial_year_end(p_date_earned);

1628: pay_in_utils.trace('p_date_earned',p_date_earned);
1629: END IF;
1630:
1631: l_year_start := pay_in_tax_utils.get_financial_year_start(p_date_earned);
1632: l_year_end := pay_in_tax_utils.get_financial_year_end(p_date_earned);
1633:
1634: l_curr_mon := to_char(p_date_earned,'MON');
1635:
1636: l_hri_entry_id := get_house_rent_info_entry_id(p_assignment_action_id,

Line 1938: l_procedure := 'pay_in_tax_utils.get_perquisite_details' ;

1934: l_message VARCHAR2(255);
1935:
1936: BEGIN
1937: g_debug := hr_utility.debug_enabled ;
1938: l_procedure := 'pay_in_tax_utils.get_perquisite_details' ;
1939: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1940: p_taxable_flag := 'Y';
1941:
1942: OPEN c_get_perk_details;

Line 2063: l_year_start := pay_in_tax_utils.get_financial_year_start(p_effective_date );

2059: l_curr_period_num := get_period_number(p_payroll_id,p_effective_date);
2060: l_def_bal_id := get_defined_balance('House Rent Allowance','_ASG_PTD');
2061: l_def_bal_id_advance := get_defined_balance('Adjusted Advance for HRA','_ASG_PTD');
2062: l_def_bal_id_80gg := get_defined_balance('Adjusted Total Income for 80GG','_ASG_PTD');
2063: l_year_start := pay_in_tax_utils.get_financial_year_start(p_effective_date );
2064: l_year_end := pay_in_tax_utils.get_financial_year_end(p_effective_date );
2065:
2066: IF l_year_start = to_date('01-04-2004','dd-mm-yyyy') THEN
2067: l_element_name :='Deductions under Chapter VI A';

Line 2064: l_year_end := pay_in_tax_utils.get_financial_year_end(p_effective_date );

2060: l_def_bal_id := get_defined_balance('House Rent Allowance','_ASG_PTD');
2061: l_def_bal_id_advance := get_defined_balance('Adjusted Advance for HRA','_ASG_PTD');
2062: l_def_bal_id_80gg := get_defined_balance('Adjusted Total Income for 80GG','_ASG_PTD');
2063: l_year_start := pay_in_tax_utils.get_financial_year_start(p_effective_date );
2064: l_year_end := pay_in_tax_utils.get_financial_year_end(p_effective_date );
2065:
2066: IF l_year_start = to_date('01-04-2004','dd-mm-yyyy') THEN
2067: l_element_name :='Deductions under Chapter VI A';
2068: l_input_name := 'Claim Exemption Sec 80GG';

Line 3367: l_year_start := pay_in_tax_utils.get_financial_year_start(p_effective_date );

3363: pay_in_utils.trace('p_context_value',p_context_value);
3364: END IF;
3365:
3366:
3367: l_year_start := pay_in_tax_utils.get_financial_year_start(p_effective_date );
3368:
3369: l_le_start_date := le_start_date(p_tax_unit_id
3370: ,p_assignment_id
3371: ,p_effective_date);

Line 3391: l_def_bal_id := pay_in_tax_utils.get_defined_balance(p_balance_name, p_dimension_name);

3387: RETURN 0;
3388: END IF;
3389: CLOSE csr_cyclic_gre;
3390:
3391: l_def_bal_id := pay_in_tax_utils.get_defined_balance(p_balance_name, p_dimension_name);
3392: pay_in_utils.set_location(g_debug, ' INDIA:l_def_bal_id '||l_def_bal_id,30);
3393:
3394: OPEN c_max_asact(l_pre_le_end_date);
3395: FETCH c_max_asact INTO p_assignment_action_id;

Line 3613: l_def_bal_id := pay_in_tax_utils.get_defined_balance(p_balance_name, '_ASG_LE_PTD');

3609:
3610: IF l_assignment_action_id IS NULL THEN
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

Line 4042: END pay_in_tax_utils ;

4038: RETURN 0;
4039:
4040: END bon_calculate_80g_gg;
4041:
4042: END pay_in_tax_utils ;