DBA Data[Home] [Help]

APPS.PAY_YEPP_MISS_ASSIGN_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 429: INDEX( pet PAY_ELEMENT_TYPES_F_PK) */

425: cp_legislation_code VARCHAR2
426: )
427: IS
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

Line 431: from pay_element_types_f pet,

427: IS
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

Line 493: lv_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;

489: l_pre_organization_id varchar2(50);
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;