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