DBA Data[Home] [Help]

APPS.PAY_PAYWSMEE2_PKG dependencies on PAY_INPUT_VALUES_F

Line 5: g_coverage constant pay_input_values_f.name%type := 'Coverage';

1: package body PAY_PAYWSMEE2_PKG as
2: /* $Header: pywsmee2.pkb 115.5 2003/02/13 17:17:30 swinton ship $ */
3: --
4: --------------------------------------------------------------------------------
5: g_coverage constant pay_input_values_f.name%type := 'Coverage';
6: g_ee_contributions constant pay_input_values_f.name%type := 'EE Contr';
7: g_er_contributions constant pay_input_values_f.name%type := 'ER Contr';
8: --------------------------------------------------------------------------------
9:

Line 6: g_ee_contributions constant pay_input_values_f.name%type := 'EE Contr';

2: /* $Header: pywsmee2.pkb 115.5 2003/02/13 17:17:30 swinton ship $ */
3: --
4: --------------------------------------------------------------------------------
5: g_coverage constant pay_input_values_f.name%type := 'Coverage';
6: g_ee_contributions constant pay_input_values_f.name%type := 'EE Contr';
7: g_er_contributions constant pay_input_values_f.name%type := 'ER Contr';
8: --------------------------------------------------------------------------------
9:
10: procedure lock_row (

Line 7: g_er_contributions constant pay_input_values_f.name%type := 'ER Contr';

3: --
4: --------------------------------------------------------------------------------
5: g_coverage constant pay_input_values_f.name%type := 'Coverage';
6: g_ee_contributions constant pay_input_values_f.name%type := 'EE Contr';
7: g_er_contributions constant pay_input_values_f.name%type := 'ER Contr';
8: --------------------------------------------------------------------------------
9:
10: procedure lock_row (
11: --

Line 532: from pay_input_values_f TYPE,

528: p_input_currency_code,
529: type.lookup_type,
530: type.value_set_id) DEFAULT_VALUE
531: --
532: from pay_input_values_f TYPE,
533: pay_input_values_f_tl TYPE_TL,
534: pay_link_input_values_f LINK
535: --
536: where type_tl.input_value_id = type.input_value_id

Line 533: pay_input_values_f_tl TYPE_TL,

529: type.lookup_type,
530: type.value_set_id) DEFAULT_VALUE
531: --
532: from pay_input_values_f TYPE,
533: pay_input_values_f_tl TYPE_TL,
534: pay_link_input_values_f LINK
535: --
536: where type_tl.input_value_id = type.input_value_id
537: and userenv('LANG') = type_tl.language