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;
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;
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;
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;
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
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;