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 752: hr_general.start_of_time) AND nvl(fnd_date.canonical_to_date(pap1.per_information19),

748: AND pap1.person_id = paa.person_id
749: AND o1.business_group_id = paa.business_group_id
750: AND p_effective_date BETWEEN paa.effective_start_date AND paa.effective_end_date
751: AND p_effective_date BETWEEN nvl(fnd_date.canonical_to_date(pap1.per_information18),
752: hr_general.start_of_time) AND nvl(fnd_date.canonical_to_date(pap1.per_information19),
753: hr_general.end_of_time)
754: AND paa.assignment_id = p_assignment_id;
755:
756: l_rec get_details%ROWTYPE;

Line 753: hr_general.end_of_time)

749: AND o1.business_group_id = paa.business_group_id
750: AND p_effective_date BETWEEN paa.effective_start_date AND paa.effective_end_date
751: AND p_effective_date BETWEEN nvl(fnd_date.canonical_to_date(pap1.per_information18),
752: hr_general.start_of_time) AND nvl(fnd_date.canonical_to_date(pap1.per_information19),
753: hr_general.end_of_time)
754: AND paa.assignment_id = p_assignment_id;
755:
756: l_rec get_details%ROWTYPE;
757: --