APPS.PAY_CA_USER_INIT_EARN dependencies on PAY_INPUT_VALUES_F

Line 203: FROM pay_input_values_f piv, pay_element_types_f pet

199:
200: CURSOR cur_input_id(p_element_name varchar2,
201: p_input_value_name varchar2) is
202: SELECT piv.input_value_id
203: FROM pay_input_values_f piv, pay_element_types_f pet
204: WHERE upper(pet.element_name) = upper(p_element_name)
205: AND pet.element_type_id = piv.element_type_id
206: AND upper(pet.legislation_code) = upper('CA')
207: AND upper(piv.name) = upper(p_input_value_name);

Line 213: FROM pay_input_values_f piv, pay_element_types_f pet

209: --
210: CURSOR cur_input_id2(p_element_type_id Number,
211: p_input_value_name varchar2) is
212: SELECT piv.input_value_id
213: FROM pay_input_values_f piv, pay_element_types_f pet
214: WHERE pet.element_type_id = p_element_type_id
215: AND pet.element_type_id = piv.element_type_id
216: /* AND upper(pet.legislation_code) = upper('CA') */
217: AND upper(piv.name) = upper(p_input_value_name);

Line 1207: FROM pay_input_values_f

1203: and legislation_code = 'CA';
1204:
1205: CURSOR c_input_value_id IS
1206: SELECT input_value_id, name
1207: FROM pay_input_values_f
1208: WHERE element_type_id = p_base_element_type_id;
1209:
1210: CURSOR c_seeded_elmt_id IS
1211: SELECT element_type_id

Line 1218: FROM pay_input_values_f

1214: AND legislation_code = 'CA';
1215:
1216: CURSOR c_seeded_elmt_iv_id(p_seed_ele_type_id number) IS
1217: SELECT input_value_id
1218: FROM pay_input_values_f
1219: WHERE element_type_id = p_seed_ele_type_id
1220: AND upper(name) = 'AMOUNT';
1221:
1222: CURSOR c_base_elmt_spr_id IS