APPS.PER_CEL_BUS dependencies on PER_PEOPLE_F

Line 1107: l_date_of_birth per_people_f.date_of_birth%TYPE;

1103: l_start_date per_jobs.date_from%TYPE;
1104: l_end_date per_jobs.date_to%TYPE;
1105: l_start_date_2 per_jobs.date_from%TYPE;
1106: l_end_date_2 per_jobs.date_to%TYPE;
1107: l_date_of_birth per_people_f.date_of_birth%TYPE;
1108: l_exist varchar2(1);
1109: l_api_updating boolean;
1110: l_party_id per_competence_elements.party_id%TYPE; -- HR/TCA merge
1111: l_qualification_type_id per_competence_elements.qualification_type_id%TYPE;

Line 1158: from per_people_f

1154: --
1155:
1156: cursor csr_valid_person_id is
1157: select business_group_id,effective_start_date, effective_end_date
1158: from per_people_f
1159: where p_person_id = person_id;
1160: --and p_effective_date between
1161: -- effective_start_date and effective_end_date;
1162: --

Line 1170: from per_people_f

1166: -- for bug #794075
1167: --
1168: cursor csr_valid_date_of_birth is
1169: select min(date_of_birth)
1170: from per_people_f
1171: where p_person_id = person_id;
1172: --
1173: -- Cursor to check that the end_date is valid
1174: -- Removed (bug #794075)

Line 1178: -- from per_people_f

1174: -- Removed (bug #794075)
1175: --
1176: -- cursor csr_valid_person_end is
1177: -- select max(effective_end_date)
1178: -- from per_people_f
1179: -- where p_person_id = person_id;
1180: --
1181: -- Cursor to check that the position_id exists
1182: --