APPS.PER_FR_D2_PKG dependencies on PER_PERSON_TYPES_TL

Line 1220: per_person_types_tl ppttl

1216: --
1217: cursor csr_get_person_type_usages is
1218: select ppttl.user_person_type
1219: from per_person_type_usages_f pptu,
1220: per_person_types_tl ppttl
1221: where pptu.person_id = l_person_id
1222: and ppttl.person_type_id = pptu.person_type_id
1223: and p_start_date between pptu.effective_start_date
1224: and pptu.effective_end_date

Line 1227: l_user_person_type per_person_types_tl.user_person_type%TYPE;

1223: and p_start_date between pptu.effective_start_date
1224: and pptu.effective_end_date
1225: and ppttl.language = userenv('LANG');
1226: --
1227: l_user_person_type per_person_types_tl.user_person_type%TYPE;
1228: begin
1229: --
1230: i := p_block_table.last;
1231: if i is null then