[Home] [Help]
528: FROM hr_h2pi_id_mapping him,
529: hr_h2pi_element_types ele1
530: WHERE him.to_id = ele.element_type_id
531: AND ele1.element_type_id = him.from_id
532: AND him.table_name = 'PAY_ELEMENT_TYPES_F'
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
539: AND ele.element_type_id = p_element_type_id
540: AND NOT EXISTS (SELECT 'X'
541: FROM hr_h2pi_id_mapping him
542: WHERE him.to_id = ele.element_type_id
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;
560: FOR v_ud_rec IN csr_element_type LOOP
561: SAVEPOINT element_type_start;
562: hr_utility.set_location(l_proc, 20);
563: l_element_type_to_id := hr_h2pi_map.get_to_id
564: (p_table_name => 'PAY_ELEMENT_TYPES_F',
565: p_from_id => v_ud_rec.element_type_id);
566:
567: IF l_element_type_to_id = -1 THEN
568: hr_utility.set_location(l_proc, 30);
1046: -- Cursor to find out input_value_id for VERTEX and Worker Compensation
1047: CURSOR csr_input_values IS
1048: SELECT iv.input_value_id
1049: FROM pay_input_values_f iv,
1050: pay_element_types_f et
1051: WHERE et.element_name IN ('VERTEX','Workers Compensation')
1052: AND iv.name = 'Jurisdiction'
1053: AND iv.element_type_id = et.element_type_id;
1054:
1079: UNION ALL
1080: SELECT screen_entry_value jurisdiction_code
1081: FROM hr_h2pi_element_entry_values_v eev,
1082: pay_input_values_f iv,
1083: pay_element_types_f et
1084: WHERE screen_entry_value is NOT NULL
1085: AND iv.element_type_id = et.element_type_id
1086: AND eev.input_value_id = iv.input_value_id
1087: AND et.element_name IN ('VERTEX','Workers Compensation')