APPS.HR_H2PI_VALIDATE dependencies on PAY_INPUT_VALUES_F

Line 1049: FROM pay_input_values_f iv,

1045:
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;

Line 1082: pay_input_values_f iv,

1078: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id
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

Line 1155: hr_h2pi_map.get_from_id(p_table_name=>'PAY_INPUT_VALUES_F',

1151: open csr_input_values;
1152: fetch csr_input_values into l_input_value1;
1153: fetch csr_input_values into l_input_value2;
1154: l_input_value1 :=
1155: hr_h2pi_map.get_from_id(p_table_name=>'PAY_INPUT_VALUES_F',
1156: p_to_id => l_input_value1,
1157: p_report_error => TRUE);
1158: l_input_value2 :=
1159: hr_h2pi_map.get_from_id(p_table_name=>'PAY_INPUT_VALUES_F',

Line 1159: hr_h2pi_map.get_from_id(p_table_name=>'PAY_INPUT_VALUES_F',

1155: hr_h2pi_map.get_from_id(p_table_name=>'PAY_INPUT_VALUES_F',
1156: p_to_id => l_input_value1,
1157: p_report_error => TRUE);
1158: l_input_value2 :=
1159: hr_h2pi_map.get_from_id(p_table_name=>'PAY_INPUT_VALUES_F',
1160: p_to_id => l_input_value2,
1161: p_report_error => TRUE);
1162:
1163: --