DBA Data[Home] [Help]

APPS.HXT_TIME_COLLECTION dependencies on PER_PEOPLE_F

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

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

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

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

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

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

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

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

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

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

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

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