[Home] [Help]
607: ,per.date_of_death
608: -- fix for bug 4957699 starts here.
609: ,npw_number
610: from hr_lookups t
611: ,per_person_types_tl pttl
612: ,per_person_types pt
613: ,per_all_people_f per
614: where pt.person_type_id = pttl.person_type_id
615: and t.lookup_type(+) = 'TITLE'
608: -- fix for bug 4957699 starts here.
609: ,npw_number
610: from hr_lookups t
611: ,per_person_types_tl pttl
612: ,per_person_types pt
613: ,per_all_people_f per
614: where pt.person_type_id = pttl.person_type_id
615: and t.lookup_type(+) = 'TITLE'
616: and t.lookup_code(+) = per.title
760: /* Drive of person type usages table */
761: /*
762: CURSOR C is
763: select 'Y'
764: from per_all_people_f papf, per_person_types ppt
765: where papf.person_id = p_person_id
766: and papf.person_type_id = ppt.person_type_id
767: and ppt.system_person_type = 'OTHER'
768: and papf.effective_end_date = hr_general.end_of_time;*/
774:
775: CURSOR c IS
776: SELECT 'Y'
777: FROM per_person_type_usages_f ptu,
778: per_person_types ppt
779: WHERE ( ppt.system_person_type like '%EMP%'
780: or ppt.system_person_type like '%APL%'
781: or ppt.system_person_type like '%CWK%')
782: AND ppt.person_type_Id = ptu.person_type_id
807: CURSOR c is
808: select pt.person_type_id
809: , pttl.user_person_type
810: , pt.system_person_type
811: from per_person_types_tl pttl,
812: per_person_types pt
813: where pt.system_person_type = 'OTHER'
814: and pt.default_flag = 'Y'
815: and pt.active_flag = 'Y'
808: select pt.person_type_id
809: , pttl.user_person_type
810: , pt.system_person_type
811: from per_person_types_tl pttl,
812: per_person_types pt
813: where pt.system_person_type = 'OTHER'
814: and pt.default_flag = 'Y'
815: and pt.active_flag = 'Y'
816: and pt.business_group_id = p_business_group_id