APPS.PAY_IVL_BUS dependencies on PAY_INPUT_VALUES_F

Line 17: select count(*) from pay_input_values_f

13: g_legislation_code varchar2(150) default null;
14: g_input_value_id number default null;
15:
16: cursor csr_row_count is
17: select count(*) from pay_input_values_f
18: where input_value_id = pay_ivl_shd.g_old_rec.input_value_id;
19: --
20: -- ---------------------------------------------------------------------------
21: -- |----------------------< set_security_group_id >--------------------------|

Line 35: , pay_input_values_f ivl

31: --
32: cursor csr_sec_grp is
33: select pbg.security_group_id
34: from per_business_groups pbg
35: , pay_input_values_f ivl
36: where ivl.input_value_id = p_input_value_id
37: and pbg.business_group_id = ivl.business_group_id;
38: --
39: -- Declare local variables

Line 102: , pay_input_values_f ivl

98: cursor csr_leg_code is
99: select pbg.legislation_code
100:
101: from per_business_groups pbg
102: , pay_input_values_f ivl
103: where ivl.input_value_id = p_input_value_id
104: and pbg.business_group_id (+) = ivl.business_group_id;
105: --
106: -- Declare local variables

Line 602: from pay_input_values_f

598: --
599: Cursor C_formula
600: is
601: select formula_id
602: from pay_input_values_f
603: where input_value_id = p_input_value_id
604: and p_effective_date between effective_start_date
605: and effective_end_date;
606: --

Line 888: l_name pay_input_values_f.name%type := p_name;

884:
885: l_dummy varchar2(1);
886:
887: l_proc varchar2(72) := g_package||'chk_upd_name';
888: l_name pay_input_values_f.name%type := p_name;
889: l_boolean boolean;
890: l_chk_name pay_input_values_f.name%type;
891:
892: l_count number;

Line 890: l_chk_name pay_input_values_f.name%type;

886:
887: l_proc varchar2(72) := g_package||'chk_upd_name';
888: l_name pay_input_values_f.name%type := p_name;
889: l_boolean boolean;
890: l_chk_name pay_input_values_f.name%type;
891:
892: l_count number;
893:
894: BEGIN

Line 1185: l_name pay_input_values_f.name%type := p_name;

1181: from pay_element_types_f
1182: where element_type_id = p_element_type_id);
1183:
1184: l_boolean boolean;
1185: l_name pay_input_values_f.name%type := p_name;
1186: l_dummy varchar2(100);
1187:
1188: l_proc varchar2(72) := g_package||'chk_name';
1189:

Line 1682: from pay_input_values_f

1678: cursor csr_pay_basis is
1679: select 1 pay
1680: from per_pay_bases
1681: where input_value_id in ( select input_value_id
1682: from pay_input_values_f
1683: where element_type_id = p_element_type_id);
1684:
1685: l_dummy varchar2(1);
1686: l_proc varchar2(72) := g_package||'chk_other_insert_val';

Line 1915: from pay_input_values_f

1911: and effective_end_date);
1912:
1913: cursor csr_name is
1914: select 'X'
1915: from pay_input_values_f
1916: where input_value_id = p_input_value_id
1917: and upper(name) in ('COVERAGE','EE CONTR','ER CONTR');
1918:
1919: l_dummy varchar2(100);