37: as
38: cursor c_global(c_effective_date date,
39: c_legislation_code pay_balance_types.legislation_code%type) is
40: select global_name,global_value from
41: ff_globals_f where global_name in ('SUPER_MONTHLY_EARNINGS',
42: 'SUPER_MAX_AGE',
43: 'SUPER_MIN_AGE',
44: 'SUPER_MIN_HOURS',
45: 'SUPER_MAX_BASE_QTR')
62: AND pbt.balance_type_id = pdb.balance_type_id
63: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
64:
65:
66: l_name ff_globals_f.global_name%type;
67: l_value ff_globals_f.global_value%type;
68:
69:
70:
63: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
64:
65:
66: l_name ff_globals_f.global_name%type;
67: l_value ff_globals_f.global_value%type;
68:
69:
70:
71: begin