APPS.PER_ASSIGNMENTS_F2_PKG dependencies on HR_PERSON_TYPE_USAGE_INFO

Line 521: IF ( hr_person_type_usage_info.is_person_of_type

517: -- nulled under certain conditions. p_person_id2 is never null.
518: --
519: -- #3609019 Added the clause of p_assignment_type
520: --
521: IF ( hr_person_type_usage_info.is_person_of_type
522: (p_person_id => p_person_id2
523: ,p_effective_date => p_sess_date
524: ,p_system_person_type => 'EMP')
525: and (nvl(p_assignment_type,'E') = 'E')) THEN

Line 534: ELSIF ( hr_person_type_usage_info.is_person_of_type

530: P_NO_SCL := 'Y';
531: end if;
532: close scl;
533: -- Start of fix 2885212
534: ELSIF ( hr_person_type_usage_info.is_person_of_type
535: (p_person_id => p_person_id2
536: ,p_effective_date => p_sess_date
537: ,p_system_person_type => 'EX_EMP')
538: and (nvl(p_assignment_type,'E') = 'E')) THEN

Line 547: ELSIF ( hr_person_type_usage_info.is_person_of_type

543: P_NO_SCL := 'Y';
544: end if;
545: close scl;
546: -- End of 2885212
547: ELSIF ( hr_person_type_usage_info.is_person_of_type
548: (p_person_id => p_person_id2
549: ,p_effective_date => p_sess_date
550: ,p_system_person_type => 'CWK')
551: and (nvl(p_assignment_type,'C') = 'C'))THEN