APPS.PAY_DEL_PERSON_FORM dependencies on PER_PERSON_TYPES

Line 25: 24-Feb-99 J. Moyano 115.1 MLS changes. Reference to per_person_types_tl

21: fnd_installation.get in procedure
22: delete_validation to be in sync with the
23: latest version of FND_INSTALLATION package
24: for function GET. Bug #494239.
25: 24-Feb-99 J. Moyano 115.1 MLS changes. Reference to per_person_types_tl
26: base table added to cursor c2.
27: ---------------------------------------------------------------------------*/
28: procedure get_displayed_values(p_business_group_id NUMBER
29: ,p_title VARCHAR2

Line 42: from per_person_types_tl TYPE_TL,

38: and lookup_code = p_title;
39: --
40: cursor c2 is
41: select type_tl.user_person_type
42: from per_person_types_tl TYPE_TL,
43: per_person_types TYPE
44: where type_tl.person_type_id = type.person_type_id
45: and type.business_group_id + 0 = p_business_group_id
46: and type.person_type_id = p_person_type_id

Line 43: per_person_types TYPE

39: --
40: cursor c2 is
41: select type_tl.user_person_type
42: from per_person_types_tl TYPE_TL,
43: per_person_types TYPE
44: where type_tl.person_type_id = type.person_type_id
45: and type.business_group_id + 0 = p_business_group_id
46: and type.person_type_id = p_person_type_id
47: and userenv('LANG') = type_tl.language;