APPS.PER_HU_PENSION_OBJECTS dependencies on PAY_ELEMENT_TYPES_F

Line 746: l_element_type_id pay_element_types_f.element_type_id%TYPE;

742: ,p_effective_date DATE
743: ,p_object_version_number NUMBER
744: ) IS
745: --
746: l_element_type_id pay_element_types_f.element_type_id%TYPE;
747: l_business_group_id pay_element_types_f.business_group_id%TYPE;
748: l_object_version_number NUMBER;
749: --
750: CURSOR csr_del_element_value IS

Line 747: l_business_group_id pay_element_types_f.business_group_id%TYPE;

743: ,p_object_version_number NUMBER
744: ) IS
745: --
746: l_element_type_id pay_element_types_f.element_type_id%TYPE;
747: l_business_group_id pay_element_types_f.business_group_id%TYPE;
748: l_object_version_number NUMBER;
749: --
750: CURSOR csr_del_element_value IS
751: SELECT business_group_id FROM pay_element_types_f

Line 751: SELECT business_group_id FROM pay_element_types_f

747: l_business_group_id pay_element_types_f.business_group_id%TYPE;
748: l_object_version_number NUMBER;
749: --
750: CURSOR csr_del_element_value IS
751: SELECT business_group_id FROM pay_element_types_f
752: WHERE element_type_id=p_element_type_id
753: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
754:
755: -- For Input Values

Line 774: l_ele_ovn pay_element_types_f.object_version_number%TYPE;

770:
771: TYPE v_input_values IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
772:
773: l_input_values v_input_values;
774: l_ele_ovn pay_element_types_f.object_version_number%TYPE;
775: l_effective_start_date pay_input_values_f.effective_start_date%TYPE;
776: l_effective_end_date pay_input_values_f.effective_end_date%TYPE;
777: l_balance_feeds_warning boolean;
778: l_input_value_id pay_input_values_f.input_value_id%TYPE;