DBA Data[Home] [Help]

APPS.HR_H2PI_VALIDATE dependencies on HR_H2PI_ELEMENT_ENTRY_VALUES

Line 1061: FROM hr_h2pi_element_entry_values

1057: FROM hr_h2pi_city_tax_rules
1058: WHERE client_id = p_from_client_id
1059: UNION ALL
1060: SELECT screen_entry_value jurisdiction_code
1061: FROM hr_h2pi_element_entry_values
1062: WHERE input_value_id in ( l_input_value1, l_input_value2)
1063: AND screen_entry_value IS NOT NULL
1064: AND client_id = p_from_client_id;
1065:

Line 1081: FROM hr_h2pi_element_entry_values_v eev,

1077: FROM hr_h2pi_city_tax_rules_v
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