APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on FF_GLOBALS_F

Line 129: g_fbt_threshold ff_globals_f.global_value%TYPE ; /* Bug 5708255 */

125: g_attribute_id pay_balance_attributes.attribute_id%type; -- bug 7571101
126: g_taxable_etp number; /* Start 9226023 - Global varaibles to store Taxable and Tax Free portions of ETP */
127: g_tax_free_etp number; /* End 9226023 */
128:
129: g_fbt_threshold ff_globals_f.global_value%TYPE ; /* Bug 5708255 */
130: p_lump_sum_E_ptd_tab pay_balance_pkg.t_balance_value_tab; -- bug8711855
131:
132: /* Changes for 9147438 start */
133:

Line 1050: FROM ff_globals_f

1046: --------------------------------------------
1047: CURSOR c_get_fbt_global(c_year_end DATE)
1048: IS
1049: SELECT global_value
1050: FROM ff_globals_f
1051: WHERE global_name = 'FBT_THRESHOLD'
1052: AND legislation_code = 'AU'
1053: AND c_year_end BETWEEN effective_start_date
1054: AND effective_end_date ;

Line 2212: FROM ff_globals_f

2208: CURSOR c_get_global(c_name VARCHAR2
2209: ,c_year_end DATE)
2210: IS
2211: SELECT global_value
2212: FROM ff_globals_f
2213: WHERE global_name = c_name
2214: AND legislation_code = 'AU'
2215: AND c_year_end BETWEEN effective_start_date
2216: AND effective_end_date ;