APPS.PAY_AU_PAYMENT_SUMMARY dependencies on FF_GLOBALS_F

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

290: g_package constant varchar2(30) := 'pay_au_payment_summary';
291: g_legislation_code constant varchar2(2) := 'AU';
292: g_dimension_id pay_balance_dimensions.balance_dimension_id%type;
293: g_balance_type_id pay_balance_types.balance_type_id%type; /*Bug#5591993*/
294: g_fbt_threshold ff_globals_f.global_value%TYPE ; /* Bug 5708255 */
295: g_attribute_id pay_balance_attributes.attribute_id%type; -- bug 7571001
296: g_termination_type varchar2(4); /*Bug#8315198 - Variable to store the termination type*/
297: --
298: /*

Line 597: FROM ff_globals_f

593: /* Bug 6470581 - Added the following to initialize the global g_fbt_threshold */
594: CURSOR c_get_fbt_global(c_year_end DATE)
595: IS
596: SELECT global_value
597: FROM ff_globals_f
598: WHERE global_name = 'FBT_THRESHOLD'
599: AND legislation_code = 'AU'
600: AND c_year_end BETWEEN effective_start_date
601: AND effective_end_date;

Line 1478: FROM ff_globals_f

1474: --------------------------------------------
1475: CURSOR c_get_fbt_global(c_year_end DATE)
1476: IS
1477: SELECT global_value
1478: FROM ff_globals_f
1479: WHERE global_name = 'FBT_THRESHOLD'
1480: AND legislation_code = 'AU'
1481: AND c_year_end BETWEEN effective_start_date
1482: AND effective_end_date ;

Line 2248: FROM ff_globals_f

2244: ,c_year_end DATE)
2245: IS
2246: SELECT global_value
2247: ,data_type
2248: FROM ff_globals_f
2249: WHERE global_name = c_name
2250: AND legislation_code = 'AU'
2251: AND c_year_end BETWEEN effective_start_date
2252: AND effective_end_date ;