APPS.BEN_ASSIGNMENT_INTERNAL dependencies on PER_PERSON_TYPES

Line 28: per_person_types ppt

24: --
25: cursor c1 is
26: select null
27: from per_person_type_usages_f ptu,
28: per_person_types ppt
29: where ptu.person_id = p_person_id
30: and p_effective_date
31: between ptu.effective_start_date
32: and ptu.effective_end_date

Line 91: from per_person_types

87: end if;
88: --
89: select person_type_id
90: into l_pet_id
91: from per_person_types
92: where business_group_id = p_business_group_id
93: and system_person_type = l_type
94: and default_flag = 'Y' ; -- Bug 3878962
95: --

Line 133: l_person_type per_person_types.system_person_type%TYPE;

129: ,p_type_exist out nocopy varchar2 )
130: is
131:
132: l_proc varchar2(72) := g_package||' chk_person_type';
133: l_person_type per_person_types.system_person_type%TYPE;
134: l_business_group_id per_person_types.business_group_id%TYPE;
135: l_person_type_id number;
136:
137: cursor csr_valid_person_type ( lc_person_type_id number)

Line 134: l_business_group_id per_person_types.business_group_id%TYPE;

130: is
131:
132: l_proc varchar2(72) := g_package||' chk_person_type';
133: l_person_type per_person_types.system_person_type%TYPE;
134: l_business_group_id per_person_types.business_group_id%TYPE;
135: l_person_type_id number;
136:
137: cursor csr_valid_person_type ( lc_person_type_id number)
138: is

Line 140: from per_person_types

136:
137: cursor csr_valid_person_type ( lc_person_type_id number)
138: is
139: select system_person_type ,business_group_id
140: from per_person_types
141: where person_type_id = lc_person_type_id;
142:
143: -- We are doing this check regardless of the enabled flag
144: -- as even old records must be used for this validation

Line 149: from per_person_types

145: cursor csr_check_uniqueness is
146: select person_type_usage_id
147: from per_person_type_usages_f
148: where person_type_id in ( select person_type_id
149: from per_person_types
150: where system_person_type = l_person_type
151: and business_group_id = l_business_group_id )
152: and person_id = p_person_id
153: and ((effective_start_date <= p_effective_date and

Line 322: per_person_types pet

318: bgp.legislation_code,
319: pet.system_person_type
320: from per_business_groups bgp,
321: per_all_people_f per,
322: per_person_types pet
323: where per.business_group_id = bgp.business_group_id
324: and per.person_type_id = pet.person_type_id
325: and per.person_id = c_person_id
326: and c_effective_date between per.effective_start_date -- Bug No 4451864 Removed -1 from the c_effective_date

Line 353: per_person_types pet

349: from per_contact_relationships ctr
350: where exists
351: (select null
352: from per_person_type_usages_f ptu,
353: per_person_types pet
354: where ctr.contact_person_id = ptu.person_id
355: and ptu.person_type_id = pet.person_type_id
356: and pet.system_person_type = 'DPNT'
357: and c_eff_date between ptu.effective_start_date and ptu.effective_end_date)

Line 504: from per_person_types pet

500: ,c_pet_spt in varchar2
501: )
502: Is
503: select pet.person_type_id
504: from per_person_types pet
505: where pet.business_group_id = c_bgp_id
506: and pet.system_person_type = c_pet_spt
507: and pet.default_flag = 'Y';
508: --

Line 516: from per_person_type_usages_f ptu, per_person_types pet

512: ,c_type_cd in varchar2 default null
513: )
514: Is
515: select pet.system_person_type
516: from per_person_type_usages_f ptu, per_person_types pet
517: where ptu.person_type_id = pet.person_type_id
518: and ptu.person_id = c_per_id
519: ---- added to test a particular type avaialble # 2852514
520: and pet.system_person_type = nvl(c_type_cd,pet.system_person_type )