127: AND pai.action_information7 IS NULL;
128:
129: CURSOR csr_elem_name IS
130: SELECT petl.element_name
131: FROM pay_element_types_f pet,
132: pay_element_types_f_tl petl
133: WHERE pet.element_name = p_element_name
134: AND pet.legislation_code = 'CN'
135: AND pet.element_type_id = petl.element_type_id
128:
129: CURSOR csr_elem_name IS
130: SELECT petl.element_name
131: FROM pay_element_types_f pet,
132: pay_element_types_f_tl petl
133: WHERE pet.element_name = p_element_name
134: AND pet.legislation_code = 'CN'
135: AND pet.element_type_id = petl.element_type_id
136: AND petl.language = userenv('LANG');
209: AND pai.action_information7 = p_input_value_name;
210:
211: CURSOR csr_elem_name IS
212: SELECT petl.element_name
213: FROM pay_element_types_f pet,
214: pay_element_types_f_tl petl
215: WHERE pet.element_name = p_element_name
216: AND pet.legislation_code = 'CN'
217: AND pet.element_type_id = petl.element_type_id
210:
211: CURSOR csr_elem_name IS
212: SELECT petl.element_name
213: FROM pay_element_types_f pet,
214: pay_element_types_f_tl petl
215: WHERE pet.element_name = p_element_name
216: AND pet.legislation_code = 'CN'
217: AND pet.element_type_id = petl.element_type_id
218: AND petl.language = userenv('LANG');