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 670: from pay_input_values_f

666: --
667: Cursor C_formula
668: is
669: select formula_id
670: from pay_input_values_f
671: where input_value_id = p_input_value_id
672: and p_effective_date between effective_start_date
673: and effective_end_date;
674: --

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

952:
953: l_dummy varchar2(1);
954:
955: l_proc varchar2(72) := g_package||'chk_upd_name';
956: l_name pay_input_values_f.name%type := p_name;
957: l_boolean boolean;
958: l_chk_name pay_input_values_f.name%type;
959:
960: l_count number;

Line 958: l_chk_name pay_input_values_f.name%type;

954:
955: l_proc varchar2(72) := g_package||'chk_upd_name';
956: l_name pay_input_values_f.name%type := p_name;
957: l_boolean boolean;
958: l_chk_name pay_input_values_f.name%type;
959:
960: l_count number;
961:
962: BEGIN

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

1249: from pay_element_types_f
1250: where element_type_id = p_element_type_id);
1251:
1252: l_boolean boolean;
1253: l_name pay_input_values_f.name%type := p_name;
1254: l_dummy varchar2(100);
1255:
1256: l_proc varchar2(72) := g_package||'chk_name';
1257:

Line 1813: from pay_input_values_f

1809: cursor csr_pay_basis is
1810: select 1 pay
1811: from per_pay_bases
1812: where input_value_id in ( select input_value_id
1813: from pay_input_values_f
1814: where element_type_id = p_element_type_id);
1815:
1816: l_dummy varchar2(1);
1817: l_proc varchar2(72) := g_package||'chk_other_insert_val';

Line 2046: from pay_input_values_f

2042: and effective_end_date);
2043:
2044: cursor csr_name is
2045: select 'X'
2046: from pay_input_values_f
2047: where input_value_id = p_input_value_id
2048: and upper(name) in ('COVERAGE','EE CONTR','ER CONTR');
2049:
2050: l_dummy varchar2(100);