[Home] [Help]
77: forced the index pay_action_information_n2
78: to avoid FTS on pay_action_information.
79: 23-Jan-2004 schauhan 115.18 3395312 Changed the type for the local variable
80: lv_address_line to the same type as column
81: address_line of pay_us_employee_action_info_v
82: The cursor c_employee populates this variable
83: 12-APR-2005 ahanda 115.19 4294918 Changed local variable length to make sure
84: it matches the db coulmn length.
85: 23-aug-2005 sackumar 115.20 4559897 Introduce the missing "if lv_found = 'N' then"
1001: address_line, town_or_city, county, state,
1002: postal_code,country,
1003: tax_unit_id, gre_name, fed_ein, org_name, location_code,
1004: action_type, person_id, effective_date
1005: FROM pay_us_employee_action_info_v peav
1006: WHERE peav.effective_date between cp_beginning_date and cp_end_date
1007: and nvl(cp_business_group_id,peav.business_group_id)
1008: = peav.business_group_id
1009: and nvl(cp_location_id,peav.location_id) = peav.location_id
1025: ,cp_location_id in number
1026: ,cp_business_group_id in number
1027: ) is
1028: SELECT person_id, last_name, action_number
1029: FROM pay_us_employee_action_info_v peav
1030: WHERE peav.effective_date between cp_beginning_date and cp_end_date
1031: and nvl(cp_business_group_id,peav.business_group_id)
1032: = peav.business_group_id
1033: and nvl(cp_location_id,peav.location_id) = peav.location_id
1234: lv_middle_name per_all_people_f.middle_names%type;
1235: lv_employee_number per_all_people_f.employee_number%type;
1236: lv_assignment_number per_all_assignments_f.assignment_number%type;
1237: lv_national_identifier per_all_people_f.national_identifier%type;
1238: lv_address_line pay_us_employee_action_info_v.address_line%type;
1239:
1240: lv_town_or_city varchar2(150);
1241: lv_county varchar2(150);
1242: lv_state varchar2(150);