APPS.HXC_SELF_SERVICE_TIMECARD dependencies on PER_ALL_PEOPLE_F

Line 4270: p_person_id IN per_all_people_f.person_id%TYPE

4266: End request_lock;
4267:
4268:
4269: FUNCTION get_name(
4270: p_person_id IN per_all_people_f.person_id%TYPE
4271: )
4272: RETURN VARCHAR2
4273: IS
4274: CURSOR c_person_name(

Line 4275: p_person_id per_all_people_f.person_id%TYPE

4271: )
4272: RETURN VARCHAR2
4273: IS
4274: CURSOR c_person_name(
4275: p_person_id per_all_people_f.person_id%TYPE
4276: )
4277: IS
4278: SELECT full_name
4279: FROM per_all_people_f ppf

Line 4279: FROM per_all_people_f ppf

4275: p_person_id per_all_people_f.person_id%TYPE
4276: )
4277: IS
4278: SELECT full_name
4279: FROM per_all_people_f ppf
4280: WHERE person_id = p_person_id
4281: AND TRUNC(SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
4282:
4283: l_person_name per_all_people_f.full_name%TYPE := NULL;

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

4279: FROM per_all_people_f ppf
4280: WHERE person_id = p_person_id
4281: AND TRUNC(SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
4282:
4283: l_person_name per_all_people_f.full_name%TYPE := NULL;
4284:
4285: BEGIN
4286: IF p_person_id IS NULL
4287: THEN

Line 4406: l_approver_id per_all_people_f.person_id%TYPE;

4402: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
4403: l_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE;
4404: l_app_status VARCHAR2(500);
4405: l_app_recipient fnd_application_tl.application_name%TYPE;
4406: l_approver_id per_all_people_f.person_id%TYPE;
4407: l_attribute_index NUMBER;
4408: l_dummy varchar2(1);
4409: l_time_category_id number;
4410: l_row_data hxc_trans_display_key_utils.translation_row_used;