APPS.HR_AE_VALIDATE_PKG dependencies on PER_DISABILITIES_F

Line 1220: FROM per_disabilities_f

1216: IF p_dis_information_category = 'AE' and NVL(p_dis_information1,'N') = 'Y' THEN
1217: /*Check that Relevant to Social Security is not set to Yes for more than 1 disability in the same period*/
1218: SELECT COUNT(*)
1219: INTO l_count
1220: FROM per_disabilities_f
1221: WHERE person_id = p_person_id
1222: AND p_effective_date BETWEEN effective_start_date AND effective_end_date
1223: AND dis_information_category = 'AE'
1224: AND dis_information1 = 'Y';

Line 1251: FROM per_disabilities_f

1247:
1248: l_count := 0;
1249: SELECT person_id
1250: INTO l_person_id
1251: FROM per_disabilities_f
1252: WHERE disability_id = p_disability_id
1253: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1254: IF p_dis_information_category = 'AE' and NVL(p_dis_information1,'N') = 'Y' THEN
1255: /*Check that Relevant to Social Security is not set to Yes for more than 1 disability in the same period*/

Line 1258: FROM per_disabilities_f

1254: IF p_dis_information_category = 'AE' and NVL(p_dis_information1,'N') = 'Y' THEN
1255: /*Check that Relevant to Social Security is not set to Yes for more than 1 disability in the same period*/
1256: SELECT COUNT(*)
1257: INTO l_count
1258: FROM per_disabilities_f
1259: WHERE person_id = l_person_id
1260: AND disability_id <> p_disability_id
1261: AND p_effective_date BETWEEN effective_start_date AND effective_end_date
1262: AND dis_information_category = 'AE'