APPS.PAY_ELEMENT_TYPES_MIG dependencies on PAY_ELEMENT_TYPES_F_TL

Line 141: l_language_code pay_element_types_f_tl.language%type;

137: l_processing_priority pay_element_types_f.processing_priority%type;
138: l_input_value_id pay_input_values_f.input_value_id%type;
139: l_iv_object_version_number pay_input_values_f.object_version_number%type;
140: l_formula_message fnd_new_messages.message_text%type;
141: l_language_code pay_element_types_f_tl.language%type;
142:
143: --
144: Cursor c_non_payments
145: is

Line 393: -- Create default entries in pay_element_types_f_tl table

389: ,p_processing_priority_warning => l_processing_priority_warning
390: );
391:
392: --
393: -- Create default entries in pay_element_types_f_tl table
394: --
395: pay_ett_ins.ins_tl
396: (p_language_code => l_language_code
397: ,p_element_type_id => l_element_type_id

Line 803: l_current_rec pay_element_types_f_tl%rowtype;

799: l_datetrack_update_mode varchar2(30) := p_datetrack_update_mode;
800: l_object_version_number pay_element_types_f.object_version_number%type;
801: l_comment_id pay_element_types_f.comment_id%type;
802: l_old_rec pay_element_types_f%rowtype;
803: l_current_rec pay_element_types_f_tl%rowtype;
804: l_base_element_name pay_element_types_f.element_name%type;
805: l_recreate_db_items varchar2(1) := 'N';
806: l_language_code pay_element_types_f_tl.language%type;
807:

Line 806: l_language_code pay_element_types_f_tl.language%type;

802: l_old_rec pay_element_types_f%rowtype;
803: l_current_rec pay_element_types_f_tl%rowtype;
804: l_base_element_name pay_element_types_f.element_name%type;
805: l_recreate_db_items varchar2(1) := 'N';
806: l_language_code pay_element_types_f_tl.language%type;
807:
808:
809: Cursor c_old_rec (v_effective_date date)
810: is

Line 820: FROM pay_element_types_f_tl ett

816: --
817: CURSOR elem_cursor (p_language_code in varchar2)
818: IS
819: SELECT source_lang, element_name, element_type_id
820: FROM pay_element_types_f_tl ett
821: WHERE ett.element_type_id = p_element_type_id
822: AND ett.language = nvl(p_language_code,ett.language);
823:
824: begin