APPS.HR_H2PI_VALIDATE dependencies on HR_H2PI_ELEMENT_TYPES_V

Line 519: FROM hr_h2pi_element_types_v

515: AND legislation_code IS NULL;
516:
517: CURSOR csr_pay_element_type IS
518: SELECT element_type_id
519: FROM hr_h2pi_element_types_v
520: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
521:
522: CURSOR csr_hr_data_removed (p_element_type_id NUMBER) IS
523: SELECT element_type_id

Line 524: FROM hr_h2pi_element_types_v ele

520: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
521:
522: CURSOR csr_hr_data_removed (p_element_type_id NUMBER) IS
523: SELECT element_type_id
524: FROM hr_h2pi_element_types_v ele
525: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_Id
526: AND ele.element_type_id = p_element_type_id
527: AND NOT EXISTS (SELECT 'X'
528: FROM hr_h2pi_id_mapping him,

Line 537: FROM hr_h2pi_element_types_v ele

533: AND him.to_business_group_id = ele.business_group_id);
534:
535: CURSOR csr_payroll_data_added(p_element_type_id NUMBER) IS
536: SELECT element_type_id
537: FROM hr_h2pi_element_types_v ele
538: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_id
539: AND ele.element_type_id = p_element_type_id
540: AND NOT EXISTS (SELECT 'X'
541: FROM hr_h2pi_id_mapping him

Line 547: l_ed_rec hr_h2pi_element_types_v%ROWTYPE;

543: AND him.table_name = 'PAY_ELEMENT_TYPES_F'
544: AND him.to_business_group_id =
545: hr_h2pi_upload.g_to_business_group_id);
546:
547: l_ed_rec hr_h2pi_element_types_v%ROWTYPE;
548: l_element_type_to_id hr_h2pi_element_types.element_type_id%TYPe;
549: l_counter BINARY_INTEGER ;
550: l_element_type_id hr_h2pi_element_types.element_type_id%TYPE;
551: l_record_ok BOOLEAN;

Line 578: FROM hr_h2pi_element_types_v

574: BEGIN
575: hr_utility.set_location(l_proc, 40);
576: SELECT *
577: INTO l_ed_rec
578: FROM hr_h2pi_element_types_v
579: WHERE element_type_id = l_element_type_to_id
580: AND effective_start_date = v_ud_rec.effective_start_date
581: AND effective_end_date = v_ud_rec.effective_end_date;
582: