DBA Data[Home] [Help]

APPS.HR_ELEMENTS dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 959: from pay_element_classifications

955: -- Cursor to get classifications by business_group
956: --
957: CURSOR get_sub_classifications(p_classification_id number) IS
958: select classification_id
959: from pay_element_classifications
960: where parent_classification_id = p_classification_id
961: and nvl(business_group_id, nvl(p_business_group_id, 0)) = nvl(p_business_group_id, 0)
962: and nvl(legislation_code, nvl(p_legislation_code, ' ')) = nvl(p_legislation_code, ' ')
963: and create_by_default_flag = 'Y'