DBA Data[Home] [Help]

APPS.PER_ASG_AGGR dependencies on PER_PERSON_TYPES

Line 50: from per_person_types typ,

46:
47: cursor cur_person_type (c_person_id in number,
48: c_effective_date in date) is
49: select typ.system_person_type
50: from per_person_types typ,
51: per_all_people_f ppf
52: where ppf.person_id = c_person_id
53: and ppf.person_type_id = typ.person_type_id
54: and c_effective_date between