APPS.GMD_SS_TIMEPOINT_WF_PKG dependencies on GMD_SS_TIME_POINTS

Line 92: gmd_ss_time_points c,

88: d.concatenated_segments item_no, d.description item_desc1, e.revision,
89: c.sampling_event_id, e.owner , c.name
90: from gmd_ss_material_sources a,
91: gmd_Qc_status b,
92: gmd_ss_time_points c,
93: mtl_system_items_b_kfv d,
94: gmd_stability_studies_b e ,
95: gmd_stability_studies_tl f ,
96: gmd_ss_variants h,

Line 379: update gmd_ss_time_points

375: select application_id into l_application_id
376: from fnd_application where application_short_name='GMD';
377:
378: /*Update the wf_sent column to show that a notification has been sent */
379: update gmd_ss_time_points
380: set wf_sent = 'Y'
381: where time_point_id = l_event_key;
382:
383: ame_api.getNextApprover(applicationIdIn => l_application_id,

Line 444: update gmd_ss_time_points

440: ITEMKEY => l_itemkey);
441:
442:
443: /* update the wf_sent back to N */
444: update gmd_ss_time_points
445: set wf_sent = 'N'
446: where time_point_id = p_timepoint;
447:
448: /* Return Success */