DBA Data[Home] [Help]

APPS.PER_HU_PENSION_OBJECTS dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 765: FROM pay_element_type_extra_info

761:
762: -- For Extra information
763: CURSOR csr_ele_extra_info IS
764: SELECT element_type_extra_info_id,object_version_number
765: FROM pay_element_type_extra_info
766: WHERE eei_information_category = 'HU_PENSION_SCHEME_INFO'
767: AND element_type_id = p_element_type_id;--l_element_type_id;
768:
769:

Line 779: l_element_extra_info_id pay_element_type_extra_info.element_type_extra_info_id%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;
778: l_inp_ovn pay_input_values_f.object_version_number%TYPE;
779: l_element_extra_info_id pay_element_type_extra_info.element_type_extra_info_id%TYPE;
780: l_extra_info_ovn pay_element_type_extra_info.object_version_number%TYPE;
781: l_processing_rules_warning boolean;
782:
783: BEGIN

Line 780: l_extra_info_ovn pay_element_type_extra_info.object_version_number%TYPE;

776: l_balance_feeds_warning boolean;
777: l_input_value_id pay_input_values_f.input_value_id%TYPE;
778: l_inp_ovn pay_input_values_f.object_version_number%TYPE;
779: l_element_extra_info_id pay_element_type_extra_info.element_type_extra_info_id%TYPE;
780: l_extra_info_ovn pay_element_type_extra_info.object_version_number%TYPE;
781: l_processing_rules_warning boolean;
782:
783: BEGIN
784: