APPS.PQH_FR_VALIDATIONS_SWI dependencies on PQH_FR_VALIDATION_PERIODS

Line 18: select validation_period_id, object_version_number from pqh_fr_validation_periods

14: ,p_return_status out nocopy varchar2
15: ) is
16:
17: cursor c_vp is
18: select validation_period_id, object_version_number from pqh_fr_validation_periods
19: where validation_id = p_validation_id;
20:
21: cursor c_ve is
22: select validation_event_id, object_version_number from pqh_fr_validation_events

Line 56: pqh_fr_validation_periods_api.delete_validation_period

52: --
53: -- Call API
54: --
55: for vlp in c_vp loop
56: pqh_fr_validation_periods_api.delete_validation_period
57: (p_validation_period_id => vlp.validation_period_id
58: ,p_object_version_number => vlp.object_version_number);
59: end loop;
60: