APPS.HR_H2PI_BG_UPLOAD dependencies on PAY_ELEMENT_TYPES_F

Line 895: l_ele_type_id pay_element_types_f.element_type_id%TYPE;

891: WHERE client_id = p_bg_id
892: AND (status IS NULL OR status <> 'C');
893:
894: l_ud_ele_name hr_h2pi_element_names%ROWTYPE;
895: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
896: l_element_name pay_element_types_f.element_name%TYPE;
897: l_encoded_message VARCHAR2(200);
898: l_ovn NUMBER(9);
899:

Line 896: l_element_name pay_element_types_f.element_name%TYPE;

892: AND (status IS NULL OR status <> 'C');
893:
894: l_ud_ele_name hr_h2pi_element_names%ROWTYPE;
895: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
896: l_element_name pay_element_types_f.element_name%TYPE;
897: l_encoded_message VARCHAR2(200);
898: l_ovn NUMBER(9);
899:
900: l_proc VARCHAR2(72) := g_package||'upload_element_name';

Line 912: (p_table_name => 'PAY_ELEMENT_TYPES_F',

908:
909: BEGIN
910: hr_utility.set_location(l_proc, 30);
911: l_ele_type_id := hr_h2pi_map.get_to_id
912: (p_table_name => 'PAY_ELEMENT_TYPES_F',
913: p_from_id => v_ud_ele_name.element_type_id,
914: p_report_error => TRUE);
915:
916: hr_utility.set_location(l_proc, 50);

Line 919: FROM pay_element_types_f elt

915:
916: hr_utility.set_location(l_proc, 50);
917: SELECT elt.element_name
918: INTO l_element_name
919: FROM pay_element_types_f elt
920: WHERE elt.element_type_id = l_ele_type_id
921: AND SYSDATE BETWEEN elt.effective_start_date
922: AND elt.effective_end_date;
923: