DBA Data[Home] [Help]

APPS.PAY_AU_SGC_PKG dependencies on FF_GLOBALS_F

Line 41: ff_globals_f where global_name in ('SUPER_MONTHLY_EARNINGS',

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')

Line 66: l_name ff_globals_f.global_name%type;

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:

Line 67: l_value ff_globals_f.global_value%type;

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