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 FF_GLOBALS_F

Line 2689: from ff_globals_f ffg

2685:
2686: /* Cursor to find the the global value as on date earned */
2687: CURSOR c_global_value(l_global_name VARCHAR2) IS
2688: SELECT global_value
2689: from ff_globals_f ffg
2690: WHERE ffg.global_name = l_global_name
2691: AND p_date_earned BETWEEN ffg.effective_start_date AND ffg.effective_end_date;
2692:
2693: /* Cursor to find the count of LTC entries already processed in an LTC block,given the block start and end dates, the value of carry over flag and the value of exempted flag */

Line 3521: l_relief_ceiling ff_globals_f.global_name%TYPE;

3517: l_income_tax_wo_pan NUMBER;
3518: --End of Bug 12376004
3519:
3520: l_surcharge_applicable_amt NUMBER;
3521: l_relief_ceiling ff_globals_f.global_name%TYPE;
3522: l_relief_limit NUMBER;
3523: tax_on_mr_ceiling NUMBER;
3524:
3525: l_cess_percent NUMBER;

Line 3540: FROM ff_globals_f glb

3536: CURSOR csr_global_value(p_global_name IN VARCHAR2
3537: ,p_date IN DATE)
3538: IS
3539: SELECT fnd_number.canonical_to_number(glb.global_value)
3540: FROM ff_globals_f glb
3541: WHERE glb.global_name = p_global_name
3542: AND p_date BETWEEN glb.effective_start_date
3543: AND glb.effective_end_date
3544: AND glb.legislation_code='IN';

Line 3923: l_relief_ceiling ff_globals_f.global_name%TYPE;

3919: l_income_tax_wo_pan NUMBER;
3920: --End of Bug 12376004
3921:
3922: l_surcharge_applicable_amt NUMBER;
3923: l_relief_ceiling ff_globals_f.global_name%TYPE;
3924: l_relief_limit NUMBER;
3925: tax_on_mr_ceiling NUMBER;
3926:
3927: l_cess_percent NUMBER;

Line 3942: FROM ff_globals_f glb

3938: CURSOR csr_global_value(p_global_name IN VARCHAR2
3939: ,p_date IN DATE)
3940: IS
3941: SELECT fnd_number.canonical_to_number(glb.global_value)
3942: FROM ff_globals_f glb
3943: WHERE glb.global_name = p_global_name
3944: AND p_date BETWEEN glb.effective_start_date
3945: AND glb.effective_end_date
3946: AND glb.legislation_code='IN';

Line 4951: FROM ff_globals_f glb

4947: CURSOR csr_global_value(p_global_name IN VARCHAR2
4948: ,p_date IN DATE)
4949: IS
4950: SELECT fnd_number.canonical_to_number(glb.global_value)
4951: FROM ff_globals_f glb
4952: WHERE glb.global_name = p_global_name
4953: AND p_date BETWEEN glb.effective_start_date
4954: AND glb.effective_end_date
4955: AND glb.legislation_code='IN';