APPS.HR_H2PI_VALIDATE dependencies on HR_H2PI_ELEMENT_LINKS_V

Line 847: FROM hr_h2pi_element_links_v

843: AND et.client_id = p_from_client_id;
844:
845: CURSOR csr_pay_element_link IS
846: SELECT element_link_id
847: FROM hr_h2pi_element_links_v
848: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
849:
850: CURSOR csr_hr_data_removed (p_element_link_id NUMBER) IS
851: SELECT element_link_id

Line 852: FROM hr_h2pi_element_links_v ele

848: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
849:
850: CURSOR csr_hr_data_removed (p_element_link_id NUMBER) IS
851: SELECT element_link_id
852: FROM hr_h2pi_element_links_v ele
853: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_Id
854: AND ele.element_link_id = p_element_link_id
855: AND NOT EXISTS (SELECT 'X'
856: FROM hr_h2pi_id_mapping him,

Line 865: FROM hr_h2pi_element_links_v ele

861: AND him.to_business_group_id = ele.business_group_id);
862:
863: CURSOR csr_payroll_data_added(p_element_link_id NUMBER) IS
864: SELECT element_link_id
865: FROM hr_h2pi_element_links_v ele
866: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_id
867: AND ele.element_link_id = p_element_link_id
868: AND NOT EXISTS (SELECT 'X'
869: FROM hr_h2pi_id_mapping him

Line 875: l_ed_rec hr_h2pi_element_links_v%ROWTYPE;

871: AND him.table_name = 'PAY_ELEMENT_LINKS_F'
872: AND him.to_business_group_id =
873: hr_h2pi_upload.g_to_business_group_id);
874:
875: l_ed_rec hr_h2pi_element_links_v%ROWTYPE;
876: l_element_link_to_id hr_h2pi_element_links.element_link_id%TYPe;
877: l_counter BINARY_INTEGER ;
878: l_element_link_id hr_h2pi_element_links.element_link_id%TYPE;
879: l_payroll_id hr_h2pi_element_links.payroll_id%TYPE;

Line 909: FROM hr_h2pi_element_links_v

905: BEGIN
906: hr_utility.set_location(l_proc, 40);
907: SELECT *
908: INTO l_ed_rec
909: FROM hr_h2pi_element_links_v
910: WHERE element_link_id = l_element_link_to_id
911: AND effective_start_date = v_ud_rec.effective_start_date
912: AND effective_end_date = v_ud_rec.effective_end_date;
913: