APPS.BEN_ASSIGNMENT_INTERNAL dependencies on PER_PERSON_TYPES

Line 234: per_person_types ppt

230: --
231: cursor c1 is
232: select null
233: from per_person_type_usages_f ptu,
234: per_person_types ppt
235: where ptu.person_id = p_person_id
236: and p_effective_date
237: between ptu.effective_start_date
238: and ptu.effective_end_date

Line 297: from per_person_types

293: end if;
294: --
295: select person_type_id
296: into l_pet_id
297: from per_person_types
298: where business_group_id = p_business_group_id
299: and system_person_type = l_type
300: and default_flag = 'Y' ; -- Bug 3878962
301: --

Line 339: l_person_type per_person_types.system_person_type%TYPE;

335: ,p_type_exist out nocopy varchar2 )
336: is
337:
338: l_proc varchar2(72) := g_package||' chk_person_type';
339: l_person_type per_person_types.system_person_type%TYPE;
340: l_business_group_id per_person_types.business_group_id%TYPE;
341: l_person_type_id number;
342:
343: cursor csr_valid_person_type ( lc_person_type_id number)

Line 340: l_business_group_id per_person_types.business_group_id%TYPE;

336: is
337:
338: l_proc varchar2(72) := g_package||' chk_person_type';
339: l_person_type per_person_types.system_person_type%TYPE;
340: l_business_group_id per_person_types.business_group_id%TYPE;
341: l_person_type_id number;
342:
343: cursor csr_valid_person_type ( lc_person_type_id number)
344: is

Line 346: from per_person_types

342:
343: cursor csr_valid_person_type ( lc_person_type_id number)
344: is
345: select system_person_type ,business_group_id
346: from per_person_types
347: where person_type_id = lc_person_type_id;
348:
349: -- We are doing this check regardless of the enabled flag
350: -- as even old records must be used for this validation

Line 355: from per_person_types

351: cursor csr_check_uniqueness is
352: select person_type_usage_id
353: from per_person_type_usages_f
354: where person_type_id in ( select person_type_id
355: from per_person_types
356: where system_person_type = l_person_type
357: and business_group_id = l_business_group_id )
358: and person_id = p_person_id
359: and ((effective_start_date <= p_effective_date and

Line 528: per_person_types pet

524: bgp.legislation_code,
525: pet.system_person_type
526: from per_business_groups bgp,
527: per_all_people_f per,
528: per_person_types pet
529: where per.business_group_id = bgp.business_group_id
530: and per.person_type_id = pet.person_type_id
531: and per.person_id = c_person_id
532: and c_effective_date between per.effective_start_date -- Bug No 4451864 Removed -1 from the c_effective_date

Line 559: per_person_types pet

555: from per_contact_relationships ctr
556: where exists
557: (select null
558: from per_person_type_usages_f ptu,
559: per_person_types pet
560: where ctr.contact_person_id = ptu.person_id
561: and ptu.person_type_id = pet.person_type_id
562: and pet.system_person_type = 'DPNT'
563: and c_eff_date between ptu.effective_start_date and ptu.effective_end_date)

Line 710: from per_person_types pet

706: ,c_pet_spt in varchar2
707: )
708: Is
709: select pet.person_type_id
710: from per_person_types pet
711: where pet.business_group_id = c_bgp_id
712: and pet.system_person_type = c_pet_spt
713: and pet.default_flag = 'Y';
714: --

Line 722: from per_person_type_usages_f ptu, per_person_types pet

718: ,c_type_cd in varchar2 default null
719: )
720: Is
721: select pet.system_person_type
722: from per_person_type_usages_f ptu, per_person_types pet
723: where ptu.person_type_id = pet.person_type_id
724: and ptu.person_id = c_per_id
725: ---- added to test a particular type avaialble # 2852514
726: and pet.system_person_type = nvl(c_type_cd,pet.system_person_type )