DBA Data[Home] [Help]

APPS.HR_GENERAL dependencies on PAY_LEGISLATIVE_FIELD_INFO

Line 2101: FROM pay_legislative_field_info

2097: ,p_validation_type IN VARCHAR2) return VARCHAR2 IS
2098: --
2099: CURSOR c_plfi IS
2100: SELECT validation_name
2101: FROM pay_legislative_field_info
2102: WHERE UPPER(target_location) = UPPER(p_target_location)
2103: AND UPPER(field_name) = UPPER(p_field_name)
2104: AND UPPER(legislation_code) = UPPER(p_legislation_code)
2105: AND UPPER(validation_type) = UPPER(p_validation_type);

Line 2107: l_validation_name pay_legislative_field_info.validation_name%TYPE;

2103: AND UPPER(field_name) = UPPER(p_field_name)
2104: AND UPPER(legislation_code) = UPPER(p_legislation_code)
2105: AND UPPER(validation_type) = UPPER(p_validation_type);
2106: --
2107: l_validation_name pay_legislative_field_info.validation_name%TYPE;
2108: --
2109: BEGIN
2110: --
2111: OPEN c_plfi;