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