APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on FF_GLOBALS_F

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

82: g_start_date date;
83: g_tax_unit_id pay_assignment_actions.tax_unit_id%type;
84:
85: g_balance_type_tab g_bal_type_tab; /* TO Store the Allowances Balance Type IDs */
86: g_fbt_threshold ff_globals_f.global_value%TYPE ; /* Bug 5708255 */
87:
88: --------------------------------------------------------------------
89: -- Name : range_code
90: -- Type : Proedure

Line 676: FROM ff_globals_f

672: --------------------------------------------
673: CURSOR c_get_fbt_global(c_year_end DATE)
674: IS
675: SELECT global_value
676: FROM ff_globals_f
677: WHERE global_name = 'FBT_THRESHOLD'
678: AND legislation_code = 'AU'
679: AND c_year_end BETWEEN effective_start_date
680: AND effective_end_date ;

Line 1427: FROM ff_globals_f

1423: CURSOR c_get_global(c_name VARCHAR2
1424: ,c_year_end DATE)
1425: IS
1426: SELECT global_value
1427: FROM ff_globals_f
1428: WHERE global_name = c_name
1429: AND legislation_code = 'AU'
1430: AND c_year_end BETWEEN effective_start_date
1431: AND effective_end_date ;