APPS.HR_FI_UTILITY dependencies on HR_GENERAL

Line 57: l_title := hr_general.decode_lookup('TITLE',p_title);

53: if p_middle_names is not null then
54: l_full_name := l_full_name|| p_middle_names||' ';
55: end if;
56: if p_title is not null then
57: l_title := hr_general.decode_lookup('TITLE',p_title);
58:
59: l_full_name := l_full_name|| l_title||' ';
60: end if;
61: if p_known_as is not null then

Line 891: hr_general.start_of_time) AND nvl(fnd_date.canonical_to_date(pap1.per_information19),

887: AND pap1.person_id = paa.person_id
888: AND o1.business_group_id = paa.business_group_id
889: AND p_effective_date BETWEEN paa.effective_start_date AND paa.effective_end_date
890: AND p_effective_date BETWEEN nvl(fnd_date.canonical_to_date(pap1.per_information18),
891: hr_general.start_of_time) AND nvl(fnd_date.canonical_to_date(pap1.per_information19),
892: hr_general.end_of_time)
893: AND paa.assignment_id = p_assignment_id;
894:
895: l_rec get_details%ROWTYPE;

Line 892: hr_general.end_of_time)

888: AND o1.business_group_id = paa.business_group_id
889: AND p_effective_date BETWEEN paa.effective_start_date AND paa.effective_end_date
890: AND p_effective_date BETWEEN nvl(fnd_date.canonical_to_date(pap1.per_information18),
891: hr_general.start_of_time) AND nvl(fnd_date.canonical_to_date(pap1.per_information19),
892: hr_general.end_of_time)
893: AND paa.assignment_id = p_assignment_id;
894:
895: l_rec get_details%ROWTYPE;
896: --