APPS.HR_AE_VALIDATE_PKG dependencies on PER_DISABILITIES_F

Line 1158: FROM per_disabilities_f

1154: IF p_dis_information_category = 'AE' and NVL(p_dis_information1,'N') = 'Y' THEN
1155: /*Check that Relevant to Social Security is not set to Yes for more than 1 disability in the same period*/
1156: SELECT COUNT(*)
1157: INTO l_count
1158: FROM per_disabilities_f
1159: WHERE person_id = p_person_id
1160: AND p_effective_date BETWEEN effective_start_date AND effective_end_date
1161: AND dis_information_category = 'AE'
1162: AND dis_information1 = 'Y';

Line 1189: FROM per_disabilities_f

1185:
1186: l_count := 0;
1187: SELECT person_id
1188: INTO l_person_id
1189: FROM per_disabilities_f
1190: WHERE disability_id = p_disability_id
1191: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1192: IF p_dis_information_category = 'AE' and NVL(p_dis_information1,'N') = 'Y' THEN
1193: /*Check that Relevant to Social Security is not set to Yes for more than 1 disability in the same period*/

Line 1196: FROM per_disabilities_f

1192: IF p_dis_information_category = 'AE' and NVL(p_dis_information1,'N') = 'Y' THEN
1193: /*Check that Relevant to Social Security is not set to Yes for more than 1 disability in the same period*/
1194: SELECT COUNT(*)
1195: INTO l_count
1196: FROM per_disabilities_f
1197: WHERE person_id = l_person_id
1198: AND disability_id <> p_disability_id
1199: AND p_effective_date BETWEEN effective_start_date AND effective_end_date
1200: AND dis_information_category = 'AE'