DBA Data[Home] [Help]

APPS.PAY_US_YEPP_MISS_ASSIGN_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 418: pay_element_classifications pec,

414: )
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

Line 482: lv_classification_name PAY_ELEMENT_CLASSIFICATIONS.CLASSIFICATION_NAME%TYPE;

478:
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);