APPS.HR_H2PI_BG_UPLOAD dependencies on HR_H2PI_ELEMENT_NAMES

Line 890: FROM hr_h2pi_element_names

886: PROCEDURE upload_element_type (p_from_client_id NUMBER) AS
887:
888: CURSOR csr_ele_names (p_bg_id NUMBER) IS
889: SELECT *
890: FROM hr_h2pi_element_names
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;

Line 894: l_ud_ele_name hr_h2pi_element_names%ROWTYPE;

890: FROM hr_h2pi_element_names
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);

Line 938: UPDATE hr_h2pi_element_names

934: ,x_owner => 'OWNER'
935: ,x_business_group_id => hr_h2pi_upload.g_to_business_group_id);
936: */
937:
938: UPDATE hr_h2pi_element_names
939: SET status = 'C'
940: WHERE element_type_id = v_ud_ele_name.element_type_id
941: AND client_id = p_from_client_id;
942: