DBA Data[Home] [Help]

APPS.PY_ZA_TX dependencies on FF_GLOBALS_F

Line 627: FROM ff_globals_f

623: )
624: IS
625: SELECT effective_end_date,
626: global_value
627: FROM ff_globals_f
628: WHERE effective_end_date < p_ty_ed
629: AND effective_end_date > p_ty_sd
630: AND effective_end_date < p_cur_per_ed
631: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';

Line 733: FROM ff_globals_f

729: )
730: IS
731: SELECT effective_end_date,
732: global_value
733: FROM ff_globals_f
734: WHERE effective_end_date > p_asg_cal_max
735: AND effective_end_date < (p_ty_sd - 1)
736: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
737:

Line 821: FROM ff_globals_f glb

817:
818:
819: SELECT global_value
820: INTO l_value_at_year_st
821: FROM ff_globals_f glb
822: WHERE l_effec_date > glb.effective_start_date
823: AND l_effec_date < glb.effective_end_date
824: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
825: