Line 112: if l_nationality_cd = UPPER(FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY')) then
108: and ASg.effective_end_date
109: and pa.effective_date between PER.effective_start_date
110: and PER.effective_end_date;
111: 112: if l_nationality_cd = UPPER(FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY')) then 113: p_source_number := 1;
114: else
115: p_source_number := 2;
116: end if;