APPS.PER_HU_PENSION_OBJECTS dependencies on PAY_ELEMENT_TYPES_F

Line 745: l_element_type_id pay_element_types_f.element_type_id%TYPE;

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

Line 746: l_business_group_id pay_element_types_f.business_group_id%TYPE;

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

Line 750: SELECT business_group_id FROM pay_element_types_f

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

Line 773: l_ele_ovn pay_element_types_f.object_version_number%TYPE;

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