[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"
1152: address_line, town_or_city, county, state,
1153: postal_code,country,
1154: tax_unit_id, gre_name, fed_ein, org_name, location_code,
1155: action_type, person_id, effective_date
1156: FROM pay_us_employee_action_info_v peav
1157: WHERE peav.effective_date between cp_beginning_date and cp_end_date
1158: and nvl(cp_business_group_id,peav.business_group_id)
1159: = peav.business_group_id
1160: and nvl(cp_location_id,peav.location_id) = peav.location_id
1176: ,cp_location_id in number
1177: ,cp_business_group_id in number
1178: ) is
1179: SELECT person_id, last_name, action_number
1180: FROM pay_us_employee_action_info_v peav
1181: WHERE peav.effective_date between cp_beginning_date and cp_end_date
1182: and nvl(cp_business_group_id,peav.business_group_id)
1183: = peav.business_group_id
1184: and nvl(cp_location_id,peav.location_id) = peav.location_id
1462: lv_middle_name per_all_people_f.middle_names%type;
1463: lv_employee_number per_all_people_f.employee_number%type;
1464: lv_assignment_number per_all_assignments_f.assignment_number%type;
1465: lv_national_identifier per_all_people_f.national_identifier%type;
1466: lv_address_line pay_us_employee_action_info_v.address_line%type;
1467:
1468: lv_town_or_city varchar2(150);
1469: lv_county varchar2(150);
1470: lv_state varchar2(150);