DBA Data[Home] [Help]

APPS.HXT_TIME_COLLECTION dependencies on PER_PEOPLE_F

Line 470: l_person_id per_people_f.person_id%TYPE DEFAULT NULL;

466: p_city_name IN VARCHAR2 DEFAULT NULL,
467: p_zip_code IN VARCHAR2 DEFAULT NULL
468: )
469: IS
470: l_person_id per_people_f.person_id%TYPE DEFAULT NULL;
471: l_last_name per_people_f.last_name%TYPE DEFAULT NULL;
472: l_first_name per_people_f.first_name%TYPE DEFAULT NULL;
473: l_approver_id per_people_f.person_id%TYPE DEFAULT NULL;
474: l_appr_last_name per_people_f.last_name%TYPE DEFAULT NULL;

Line 471: l_last_name per_people_f.last_name%TYPE DEFAULT NULL;

467: p_zip_code IN VARCHAR2 DEFAULT NULL
468: )
469: IS
470: l_person_id per_people_f.person_id%TYPE DEFAULT NULL;
471: l_last_name per_people_f.last_name%TYPE DEFAULT NULL;
472: l_first_name per_people_f.first_name%TYPE DEFAULT NULL;
473: l_approver_id per_people_f.person_id%TYPE DEFAULT NULL;
474: l_appr_last_name per_people_f.last_name%TYPE DEFAULT NULL;
475: l_appr_first_name per_people_f.first_name%TYPE DEFAULT NULL;

Line 472: l_first_name per_people_f.first_name%TYPE DEFAULT NULL;

468: )
469: IS
470: l_person_id per_people_f.person_id%TYPE DEFAULT NULL;
471: l_last_name per_people_f.last_name%TYPE DEFAULT NULL;
472: l_first_name per_people_f.first_name%TYPE DEFAULT NULL;
473: l_approver_id per_people_f.person_id%TYPE DEFAULT NULL;
474: l_appr_last_name per_people_f.last_name%TYPE DEFAULT NULL;
475: l_appr_first_name per_people_f.first_name%TYPE DEFAULT NULL;
476: l_timecard_id hxt_timecards.ID%TYPE DEFAULT NULL;

Line 473: l_approver_id per_people_f.person_id%TYPE DEFAULT NULL;

469: IS
470: l_person_id per_people_f.person_id%TYPE DEFAULT NULL;
471: l_last_name per_people_f.last_name%TYPE DEFAULT NULL;
472: l_first_name per_people_f.first_name%TYPE DEFAULT NULL;
473: l_approver_id per_people_f.person_id%TYPE DEFAULT NULL;
474: l_appr_last_name per_people_f.last_name%TYPE DEFAULT NULL;
475: l_appr_first_name per_people_f.first_name%TYPE DEFAULT NULL;
476: l_timecard_id hxt_timecards.ID%TYPE DEFAULT NULL;
477: l_date_worked DATE DEFAULT NULL;

Line 474: l_appr_last_name per_people_f.last_name%TYPE DEFAULT NULL;

470: l_person_id per_people_f.person_id%TYPE DEFAULT NULL;
471: l_last_name per_people_f.last_name%TYPE DEFAULT NULL;
472: l_first_name per_people_f.first_name%TYPE DEFAULT NULL;
473: l_approver_id per_people_f.person_id%TYPE DEFAULT NULL;
474: l_appr_last_name per_people_f.last_name%TYPE DEFAULT NULL;
475: l_appr_first_name per_people_f.first_name%TYPE DEFAULT NULL;
476: l_timecard_id hxt_timecards.ID%TYPE DEFAULT NULL;
477: l_date_worked DATE DEFAULT NULL;
478: l_element_type_id pay_element_types_f.element_type_id%TYPE

Line 475: l_appr_first_name per_people_f.first_name%TYPE DEFAULT NULL;

471: l_last_name per_people_f.last_name%TYPE DEFAULT NULL;
472: l_first_name per_people_f.first_name%TYPE DEFAULT NULL;
473: l_approver_id per_people_f.person_id%TYPE DEFAULT NULL;
474: l_appr_last_name per_people_f.last_name%TYPE DEFAULT NULL;
475: l_appr_first_name per_people_f.first_name%TYPE DEFAULT NULL;
476: l_timecard_id hxt_timecards.ID%TYPE DEFAULT NULL;
477: l_date_worked DATE DEFAULT NULL;
478: l_element_type_id pay_element_types_f.element_type_id%TYPE
479: DEFAULT NULL;