DBA Data[Home] [Help]

APPS.PAY_IN_TAX_UTILS dependencies on FF_GLOBALS_F

Line 2253: from ff_globals_f ffg

2249:
2250: /* Cursor to find the the global value as on date earned */
2251: CURSOR c_global_value(l_global_name VARCHAR2) IS
2252: SELECT global_value
2253: from ff_globals_f ffg
2254: WHERE ffg.global_name = l_global_name
2255: AND p_date_earned BETWEEN ffg.effective_start_date AND ffg.effective_end_date;
2256:
2257: /* 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 3074: l_relief_ceiling ff_globals_f.global_name%TYPE;

3070: l_reduced_amount NUMBER;
3071: l_income_tax NUMBER;
3072:
3073: l_surcharge_applicable_amt NUMBER;
3074: l_relief_ceiling ff_globals_f.global_name%TYPE;
3075: l_relief_limit NUMBER;
3076: tax_on_mr_ceiling NUMBER;
3077:
3078: l_cess_percent NUMBER;

Line 3088: FROM ff_globals_f glb

3084: CURSOR csr_global_value(p_global_name IN VARCHAR2
3085: ,p_date IN DATE)
3086: IS
3087: SELECT fnd_number.canonical_to_number(glb.global_value)
3088: FROM ff_globals_f glb
3089: WHERE glb.global_name = p_global_name
3090: AND p_date BETWEEN glb.effective_start_date
3091: AND glb.effective_end_date
3092: AND glb.legislation_code='IN';

Line 3892: FROM ff_globals_f glb

3888: CURSOR csr_global_value(p_global_name IN VARCHAR2
3889: ,p_date IN DATE)
3890: IS
3891: SELECT fnd_number.canonical_to_number(glb.global_value)
3892: FROM ff_globals_f glb
3893: WHERE glb.global_name = p_global_name
3894: AND p_date BETWEEN glb.effective_start_date
3895: AND glb.effective_end_date
3896: AND glb.legislation_code='IN';