APPS.PAY_CA_USER_INIT_EARN dependencies on PAY_INPUT_VALUES_F

Line 198: FROM pay_input_values_f piv, pay_element_types_f pet

194:
195: CURSOR cur_input_id(p_element_name varchar2,
196: p_input_value_name varchar2) is
197: SELECT piv.input_value_id
198: FROM pay_input_values_f piv, pay_element_types_f pet
199: WHERE upper(pet.element_name) = upper(p_element_name)
200: AND pet.element_type_id = piv.element_type_id
201: AND upper(pet.legislation_code) = upper('CA')
202: AND upper(piv.name) = upper(p_input_value_name);

Line 208: FROM pay_input_values_f piv, pay_element_types_f pet

204: --
205: CURSOR cur_input_id2(p_element_type_id Number,
206: p_input_value_name varchar2) is
207: SELECT piv.input_value_id
208: FROM pay_input_values_f piv, pay_element_types_f pet
209: WHERE pet.element_type_id = p_element_type_id
210: AND pet.element_type_id = piv.element_type_id
211: /* AND upper(pet.legislation_code) = upper('CA') */
212: AND upper(piv.name) = upper(p_input_value_name);

Line 1199: FROM pay_input_values_f

1195: and legislation_code = 'CA';
1196:
1197: CURSOR c_input_value_id IS
1198: SELECT input_value_id, name
1199: FROM pay_input_values_f
1200: WHERE element_type_id = p_base_element_type_id;
1201:
1202: CURSOR c_seeded_elmt_id IS
1203: SELECT element_type_id

Line 1210: FROM pay_input_values_f

1206: AND legislation_code = 'CA';
1207:
1208: CURSOR c_seeded_elmt_iv_id(p_seed_ele_type_id number) IS
1209: SELECT input_value_id
1210: FROM pay_input_values_f
1211: WHERE element_type_id = p_seed_ele_type_id
1212: AND upper(name) = 'AMOUNT';
1213:
1214: CURSOR c_base_elmt_spr_id IS