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_DEFINED_BALANCES

Line 447: FROM pay_defined_balances pdb

443: is
444: CURSOR csr_def_bal_id
445: IS
446: SELECT pdb.defined_balance_id
447: FROM pay_defined_balances pdb
448: ,pay_balance_types pbt
449: ,pay_balance_dimensions pbd
450: WHERE pbt.balance_name = p_balance_type
451: AND pbd.dimension_name = p_dimension_name

Line 458: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

454: AND ( pbd.legislation_code = 'IN' OR pbd.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
455: AND ( pdb.legislation_code = 'IN' OR pdb.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
456: AND pdb.balance_dimension_id = pbd.balance_dimension_id;
457:
458: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
459: l_message VARCHAR2(255);
460: l_procedure VARCHAR2(100);
461:
462: BEGIN

Line 1016: l_hra_sal_bal_id pay_defined_balances.defined_balance_id%type;

1012: p_eff_date_tbl out nocopy t_eff_date )
1013: is
1014: l_assact_tbl t_assact ;
1015: l_eff_date_tbl t_eff_date;
1016: l_hra_sal_bal_id pay_defined_balances.defined_balance_id%type;
1017: l_hra_alw_bal_id pay_defined_balances.defined_balance_id%type;
1018: l_hra_advance_alw_bal_id pay_defined_balances.defined_balance_id%type;
1019: l_procedure VARCHAR2(100);
1020: l_message VARCHAR2(250);

Line 1017: l_hra_alw_bal_id pay_defined_balances.defined_balance_id%type;

1013: is
1014: l_assact_tbl t_assact ;
1015: l_eff_date_tbl t_eff_date;
1016: l_hra_sal_bal_id pay_defined_balances.defined_balance_id%type;
1017: l_hra_alw_bal_id pay_defined_balances.defined_balance_id%type;
1018: l_hra_advance_alw_bal_id pay_defined_balances.defined_balance_id%type;
1019: l_procedure VARCHAR2(100);
1020: l_message VARCHAR2(250);
1021:

Line 1018: l_hra_advance_alw_bal_id pay_defined_balances.defined_balance_id%type;

1014: l_assact_tbl t_assact ;
1015: l_eff_date_tbl t_eff_date;
1016: l_hra_sal_bal_id pay_defined_balances.defined_balance_id%type;
1017: l_hra_alw_bal_id pay_defined_balances.defined_balance_id%type;
1018: l_hra_advance_alw_bal_id pay_defined_balances.defined_balance_id%type;
1019: l_procedure VARCHAR2(100);
1020: l_message VARCHAR2(250);
1021:
1022: BEGIN

Line 1137: l_ret_tax_hra_def_bal_id pay_defined_balances.defined_balance_id%type; -- Bug 11821281

1133: l_taxable_hra_proj NUMBER ;
1134: l_exemption_on_hra NUMBER ;
1135: l_metro_status varchar2(1);
1136: l_hri_entry_id pay_element_entries_f.element_entry_id%type;
1137: l_ret_tax_hra_def_bal_id pay_defined_balances.defined_balance_id%type; -- Bug 11821281
1138: l_taxable_hra_def_bal_id pay_defined_balances.defined_balance_id%type;
1139: l_taxable_hra_ptd_bal_id pay_defined_balances.defined_balance_id%type;
1140: l_taxable_hra_proj_bal_id pay_defined_balances.defined_balance_id%type;
1141: l_current_gre hr_soft_coding_keyflex.segment1%type;

Line 1138: l_taxable_hra_def_bal_id pay_defined_balances.defined_balance_id%type;

1134: l_exemption_on_hra NUMBER ;
1135: l_metro_status varchar2(1);
1136: l_hri_entry_id pay_element_entries_f.element_entry_id%type;
1137: l_ret_tax_hra_def_bal_id pay_defined_balances.defined_balance_id%type; -- Bug 11821281
1138: l_taxable_hra_def_bal_id pay_defined_balances.defined_balance_id%type;
1139: l_taxable_hra_ptd_bal_id pay_defined_balances.defined_balance_id%type;
1140: l_taxable_hra_proj_bal_id pay_defined_balances.defined_balance_id%type;
1141: l_current_gre hr_soft_coding_keyflex.segment1%type;
1142: l_gre hr_soft_coding_keyflex.segment1%type;

Line 1139: l_taxable_hra_ptd_bal_id pay_defined_balances.defined_balance_id%type;

1135: l_metro_status varchar2(1);
1136: l_hri_entry_id pay_element_entries_f.element_entry_id%type;
1137: l_ret_tax_hra_def_bal_id pay_defined_balances.defined_balance_id%type; -- Bug 11821281
1138: l_taxable_hra_def_bal_id pay_defined_balances.defined_balance_id%type;
1139: l_taxable_hra_ptd_bal_id pay_defined_balances.defined_balance_id%type;
1140: l_taxable_hra_proj_bal_id pay_defined_balances.defined_balance_id%type;
1141: l_current_gre hr_soft_coding_keyflex.segment1%type;
1142: l_gre hr_soft_coding_keyflex.segment1%type;
1143: l_entry_type_flag varchar2(2) ;

Line 1140: l_taxable_hra_proj_bal_id pay_defined_balances.defined_balance_id%type;

1136: l_hri_entry_id pay_element_entries_f.element_entry_id%type;
1137: l_ret_tax_hra_def_bal_id pay_defined_balances.defined_balance_id%type; -- Bug 11821281
1138: l_taxable_hra_def_bal_id pay_defined_balances.defined_balance_id%type;
1139: l_taxable_hra_ptd_bal_id pay_defined_balances.defined_balance_id%type;
1140: l_taxable_hra_proj_bal_id pay_defined_balances.defined_balance_id%type;
1141: l_current_gre hr_soft_coding_keyflex.segment1%type;
1142: l_gre hr_soft_coding_keyflex.segment1%type;
1143: l_entry_type_flag varchar2(2) ;
1144: l_entry_end_date DATE;

Line 2414: l_def_bal_id pay_defined_balances.defined_balance_id%type;

2410: l_80_exem number;
2411: l_10percent_adj_tot_inc number;
2412: l_25percent_adj_tot_inc number;
2413: l_adj_tot_inc number;
2414: l_def_bal_id pay_defined_balances.defined_balance_id%type;
2415: l_def_bal_id_80gg pay_defined_balances.defined_balance_id%type;
2416: l_def_bal_id_advance pay_defined_balances.defined_balance_id%type;
2417: l_assact_tbl t_assact ;
2418: l_eff_date_tbl t_eff_date;

Line 2415: l_def_bal_id_80gg pay_defined_balances.defined_balance_id%type;

2411: l_10percent_adj_tot_inc number;
2412: l_25percent_adj_tot_inc number;
2413: l_adj_tot_inc number;
2414: l_def_bal_id pay_defined_balances.defined_balance_id%type;
2415: l_def_bal_id_80gg pay_defined_balances.defined_balance_id%type;
2416: l_def_bal_id_advance pay_defined_balances.defined_balance_id%type;
2417: l_assact_tbl t_assact ;
2418: l_eff_date_tbl t_eff_date;
2419: l_hra number;

Line 2416: l_def_bal_id_advance pay_defined_balances.defined_balance_id%type;

2412: l_25percent_adj_tot_inc number;
2413: l_adj_tot_inc number;
2414: l_def_bal_id pay_defined_balances.defined_balance_id%type;
2415: l_def_bal_id_80gg pay_defined_balances.defined_balance_id%type;
2416: l_def_bal_id_advance pay_defined_balances.defined_balance_id%type;
2417: l_assact_tbl t_assact ;
2418: l_eff_date_tbl t_eff_date;
2419: l_hra number;
2420: l_curr_period_num number;