APPS.HXC_SELF_SERVICE_TIMECARD dependencies on PER_ALL_PEOPLE_F

Line 3934: p_person_id IN per_all_people_f.person_id%TYPE

3930: End request_lock;
3931:
3932:
3933: FUNCTION get_name(
3934: p_person_id IN per_all_people_f.person_id%TYPE
3935: )
3936: RETURN VARCHAR2
3937: IS
3938: CURSOR c_person_name(

Line 3939: p_person_id per_all_people_f.person_id%TYPE

3935: )
3936: RETURN VARCHAR2
3937: IS
3938: CURSOR c_person_name(
3939: p_person_id per_all_people_f.person_id%TYPE
3940: )
3941: IS
3942: SELECT full_name
3943: FROM per_all_people_f ppf

Line 3943: FROM per_all_people_f ppf

3939: p_person_id per_all_people_f.person_id%TYPE
3940: )
3941: IS
3942: SELECT full_name
3943: FROM per_all_people_f ppf
3944: WHERE person_id = p_person_id
3945: AND TRUNC(SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
3946:
3947: l_person_name per_all_people_f.full_name%TYPE := NULL;

Line 3947: l_person_name per_all_people_f.full_name%TYPE := NULL;

3943: FROM per_all_people_f ppf
3944: WHERE person_id = p_person_id
3945: AND TRUNC(SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
3946:
3947: l_person_name per_all_people_f.full_name%TYPE := NULL;
3948:
3949: BEGIN
3950: IF p_person_id IS NULL
3951: THEN

Line 4070: l_approver_id per_all_people_f.person_id%TYPE;

4066: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
4067: l_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE;
4068: l_app_status VARCHAR2(500);
4069: l_app_recipient fnd_application_tl.application_name%TYPE;
4070: l_approver_id per_all_people_f.person_id%TYPE;
4071: l_attribute_index NUMBER;
4072: l_dummy varchar2(1);
4073: l_time_category_id number;
4074: l_row_data hxc_trans_display_key_utils.translation_row_used;