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 319: FROM pay_defined_balances pdb

315: is
316: CURSOR csr_def_bal_id
317: IS
318: SELECT pdb.defined_balance_id
319: FROM pay_defined_balances pdb
320: ,pay_balance_types pbt
321: ,pay_balance_dimensions pbd
322: WHERE pbt.balance_name = p_balance_type
323: AND pbd.dimension_name = p_dimension_name

Line 330: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

326: AND ( pbd.legislation_code = 'IN' OR pbd.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
327: AND ( pdb.legislation_code = 'IN' OR pdb.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
328: AND pdb.balance_dimension_id = pbd.balance_dimension_id;
329:
330: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
331: l_message VARCHAR2(255);
332: l_procedure VARCHAR2(100);
333:
334: BEGIN

Line 705: l_hra_sal_bal_id pay_defined_balances.defined_balance_id%type;

701: p_eff_date_tbl out nocopy t_eff_date )
702: is
703: l_assact_tbl t_assact ;
704: l_eff_date_tbl t_eff_date;
705: l_hra_sal_bal_id pay_defined_balances.defined_balance_id%type;
706: l_hra_alw_bal_id pay_defined_balances.defined_balance_id%type;
707: l_hra_advance_alw_bal_id pay_defined_balances.defined_balance_id%type;
708: l_procedure VARCHAR2(100);
709: l_message VARCHAR2(250);

Line 706: l_hra_alw_bal_id pay_defined_balances.defined_balance_id%type;

702: is
703: l_assact_tbl t_assact ;
704: l_eff_date_tbl t_eff_date;
705: l_hra_sal_bal_id pay_defined_balances.defined_balance_id%type;
706: l_hra_alw_bal_id pay_defined_balances.defined_balance_id%type;
707: l_hra_advance_alw_bal_id pay_defined_balances.defined_balance_id%type;
708: l_procedure VARCHAR2(100);
709: l_message VARCHAR2(250);
710:

Line 707: l_hra_advance_alw_bal_id pay_defined_balances.defined_balance_id%type;

703: l_assact_tbl t_assact ;
704: l_eff_date_tbl t_eff_date;
705: l_hra_sal_bal_id pay_defined_balances.defined_balance_id%type;
706: l_hra_alw_bal_id pay_defined_balances.defined_balance_id%type;
707: l_hra_advance_alw_bal_id pay_defined_balances.defined_balance_id%type;
708: l_procedure VARCHAR2(100);
709: l_message VARCHAR2(250);
710:
711: BEGIN

Line 822: l_taxable_hra_def_bal_id pay_defined_balances.defined_balance_id%type;

818: l_taxable_hra_proj NUMBER ;
819: l_exemption_on_hra NUMBER ;
820: l_metro_status varchar2(1);
821: l_hri_entry_id pay_element_entries_f.element_entry_id%type;
822: l_taxable_hra_def_bal_id pay_defined_balances.defined_balance_id%type;
823: l_taxable_hra_ptd_bal_id pay_defined_balances.defined_balance_id%type;
824: l_taxable_hra_proj_bal_id pay_defined_balances.defined_balance_id%type;
825: l_current_gre hr_soft_coding_keyflex.segment1%type;
826: l_gre hr_soft_coding_keyflex.segment1%type;

Line 823: l_taxable_hra_ptd_bal_id pay_defined_balances.defined_balance_id%type;

819: l_exemption_on_hra NUMBER ;
820: l_metro_status varchar2(1);
821: l_hri_entry_id pay_element_entries_f.element_entry_id%type;
822: l_taxable_hra_def_bal_id pay_defined_balances.defined_balance_id%type;
823: l_taxable_hra_ptd_bal_id pay_defined_balances.defined_balance_id%type;
824: l_taxable_hra_proj_bal_id pay_defined_balances.defined_balance_id%type;
825: l_current_gre hr_soft_coding_keyflex.segment1%type;
826: l_gre hr_soft_coding_keyflex.segment1%type;
827: l_entry_type_flag varchar2(2) ;

Line 824: l_taxable_hra_proj_bal_id pay_defined_balances.defined_balance_id%type;

820: l_metro_status varchar2(1);
821: l_hri_entry_id pay_element_entries_f.element_entry_id%type;
822: l_taxable_hra_def_bal_id pay_defined_balances.defined_balance_id%type;
823: l_taxable_hra_ptd_bal_id pay_defined_balances.defined_balance_id%type;
824: l_taxable_hra_proj_bal_id pay_defined_balances.defined_balance_id%type;
825: l_current_gre hr_soft_coding_keyflex.segment1%type;
826: l_gre hr_soft_coding_keyflex.segment1%type;
827: l_entry_type_flag varchar2(2) ;
828: l_entry_end_date DATE;

Line 2003: l_def_bal_id pay_defined_balances.defined_balance_id%type;

1999: l_80_exem number;
2000: l_10percent_adj_tot_inc number;
2001: l_25percent_adj_tot_inc number;
2002: l_adj_tot_inc number;
2003: l_def_bal_id pay_defined_balances.defined_balance_id%type;
2004: l_def_bal_id_80gg pay_defined_balances.defined_balance_id%type;
2005: l_def_bal_id_advance pay_defined_balances.defined_balance_id%type;
2006: l_assact_tbl t_assact ;
2007: l_eff_date_tbl t_eff_date;

Line 2004: l_def_bal_id_80gg pay_defined_balances.defined_balance_id%type;

2000: l_10percent_adj_tot_inc number;
2001: l_25percent_adj_tot_inc number;
2002: l_adj_tot_inc number;
2003: l_def_bal_id pay_defined_balances.defined_balance_id%type;
2004: l_def_bal_id_80gg pay_defined_balances.defined_balance_id%type;
2005: l_def_bal_id_advance pay_defined_balances.defined_balance_id%type;
2006: l_assact_tbl t_assact ;
2007: l_eff_date_tbl t_eff_date;
2008: l_hra number;

Line 2005: l_def_bal_id_advance pay_defined_balances.defined_balance_id%type;

2001: l_25percent_adj_tot_inc number;
2002: l_adj_tot_inc number;
2003: l_def_bal_id pay_defined_balances.defined_balance_id%type;
2004: l_def_bal_id_80gg pay_defined_balances.defined_balance_id%type;
2005: l_def_bal_id_advance pay_defined_balances.defined_balance_id%type;
2006: l_assact_tbl t_assact ;
2007: l_eff_date_tbl t_eff_date;
2008: l_hra number;
2009: l_curr_period_num number;