415: IS
416: select distinct element_name, classification_name,piv.name
417: from pay_element_types_f pet,
418: pay_element_classifications pec,
419: pay_input_values_f piv
420: where pet.element_type_id = piv.element_type_id
421: and piv.uom = 'M'
422: and pet.classification_id = pec.classification_id
423: and pet.business_group_id = cp_business_group_id
426: and piv.input_value_id not in
427: (
428: select distinct piv.input_value_id
429: from pay_element_types_f pet,
430: pay_input_values_f piv,
431: pay_balance_feeds_f pbf,
432: pay_balance_types pbt,
433: pay_defined_balances pdb,
434: pay_balance_attributes pba,
479: lv_title VARCHAR2(1000);
480: lv_header_label VARCHAR2(1000);
481: lv_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;
482: lv_classification_name PAY_ELEMENT_CLASSIFICATIONS.CLASSIFICATION_NAME%TYPE;
483: lv_input_value_name PAY_INPUT_VALUES_F.NAME%TYPE;
484: lv_element_row VARCHAR2(1000);
485: lv_element_count NUMBER;
486: lv_legislation_code varchar2(100);
487: lv_element_info varchar2(200);