APPS.PER_ASSIGNMENTS_F2_PKG dependencies on HR_PERSON_TYPE_USAGE_INFO

Line 517: IF ( hr_person_type_usage_info.is_person_of_type

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

Line 530: ELSIF ( hr_person_type_usage_info.is_person_of_type

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

Line 543: ELSIF ( hr_person_type_usage_info.is_person_of_type

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