APPS.PAY_YEPP_MISS_ASSIGN_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 432: pay_element_classifications pec

428: select /*+ USE_NL(pet, pec)
429: INDEX( pet PAY_ELEMENT_TYPES_F_PK) */
430: distinct pet.element_name, pec.classification_name
431: from pay_element_types_f pet,
432: pay_element_classifications pec
433: where pet.classification_id = pec.classification_id
434: and pet.business_group_id = cp_business_group_id
435: and hr_api.return_legislation_code(cp_business_group_id) = cp_legislation_code
436: and ((pec.legislation_code = cp_legislation_code and pec.business_group_id is null) or

Line 494: lv_classification_name PAY_ELEMENT_CLASSIFICATIONS.CLASSIFICATION_NAME%TYPE;

490:
491: lv_title VARCHAR2(1000);
492: lv_header_label VARCHAR2(1000);
493: lv_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;
494: lv_classification_name PAY_ELEMENT_CLASSIFICATIONS.CLASSIFICATION_NAME%TYPE;
495: --lv_input_value_name PAY_INPUT_VALUES_F.NAME%TYPE;
496: lv_element_row VARCHAR2(1000);
497: lv_element_count NUMBER;
498: lv_legislation_code varchar2(100);