APPS.GMD_SS_TEST_WF_PKG dependencies on GMD_STABILITY_STUDIES

Line 56: from gmd_stability_studies_b

52:
53: cursor C1 is
54: select NOTIFICATION_LEAD_TIME , NOTIFICATION_LEAD_TIME_UNIT,
55: TESTING_GRACE_PERIOD , TESTING_GRACE_PERIOD_UNIT
56: from gmd_stability_studies_b
57: where ss_id = l_event_key ;
58:
59: cursor C2 is
60: select distinct time.time_point_id , time.scheduled_date, time.wf_sent, time.sampling_event_id

Line 64: gmd_stability_studies ss

60: select distinct time.time_point_id , time.scheduled_date, time.wf_sent, time.sampling_event_id
61: from gmd_ss_time_points time ,
62: gmd_ss_variants variant ,
63: gmd_ss_material_sources sources,
64: gmd_stability_studies ss
65: where time.variant_id = variant.variant_id
66: and sources.source_id = variant.material_source_id
67: and variant.ss_id = l_event_key
68: and ss.ss_id = variant.ss_id