43: ,p_program_update_date in date
44: ) is
45:
46: cursor cur_eff is select effective_start_date,
47: effective_end_date from pqp_vehicle_repository_f
48: where vehicle_repository_id = p_vehicle_repository_id;
49: l_effective_start_date date;
50: l_effective_end_date date;
51:
114: ,p_program_update_date in date
115: ) is
116:
117: cursor cur_eff is select effective_start_date,
118: effective_end_date from pqp_vehicle_repository_f
119: where vehicle_repository_id = p_vehicle_repository_id;
120: l_effective_start_date date;
121: l_effective_end_date date;
122: