DBA Data[Home] [Help]

APPS.HR_GENERAL dependencies on PAY_LEGISLATIVE_FIELD_INFO

Line 2099: FROM pay_legislative_field_info

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

Line 2105: l_validation_name pay_legislative_field_info.validation_name%TYPE;

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