APPS.AMW_RISK_APPROVAL_PVT dependencies on AMW_RISKS_ALL_VL

Line 69: FROM amw_risks_all_vl

65: l_object_meaning VARCHAR2 (80);
66: l_requestor_name VARCHAR2 (260);
67: CURSOR c_risk_rec (p_risk_rev_id IN NUMBER) IS
68: SELECT risk_id, NAME, creation_date, requestor_id
69: FROM amw_risks_all_vl
70: WHERE risk_rev_id = p_risk_rev_id;
71: BEGIN
72: IF g_debug THEN
73: amw_utility_pvt.debug_message ( l_api_name

Line 237: FROM amw_risks_all_vl

233: l_approval_date DATE;
234: CURSOR c_risk_rec (p_risk_rev_id IN NUMBER) IS
235: SELECT risk_id, NAME, creation_date,
236: requestor_id -- --s hould be a name
237: FROM amw_risks_all_vl
238: WHERE risk_rev_id = p_risk_rev_id;
239: BEGIN
240: IF g_debug THEN
241: amw_utility_pvt.debug_message ( l_api_name

Line 403: FROM amw_risks_all_vl

399: l_object_meaning VARCHAR2 (80);
400: l_requestor_id NUMBER;
401: CURSOR c_risk_rec (p_risk_rev_id IN NUMBER) IS
402: SELECT risk_id, NAME, creation_date, requestor_id
403: FROM amw_risks_all_vl
404: WHERE risk_rev_id = p_risk_rev_id;
405: BEGIN
406: IF g_debug THEN
407: amw_utility_pvt.debug_message ( l_api_name

Line 569: FROM amw_risks_all_vl

565: l_requestor_id NUMBER;
566: CURSOR c_risk_rec (p_risk_rev_id IN NUMBER) IS
567: SELECT risk_id, NAME, creation_date,
568: requestor_id -- needs to be the name
569: FROM amw_risks_all_vl
570: WHERE risk_rev_id = p_risk_rev_id;
571: BEGIN
572: IF g_debug THEN
573: amw_utility_pvt.debug_message ( l_api_name

Line 748: FROM amw_risks_all_vl

744: l_object_meaning VARCHAR2 (80);
745: CURSOR c_risk_rec (p_risk_rev_id IN NUMBER) IS
746: SELECT risk_id, NAME,
747: creation_date requestor_id -- needs to be the name
748: FROM amw_risks_all_vl
749: WHERE risk_rev_id = p_risk_rev_id;
750: BEGIN
751: IF g_debug THEN
752: amw_utility_pvt.debug_message ( l_api_name

Line 937: FROM amw_risks_all_vl

933: l_string VARCHAR2 (3000);
934: l_lookup_meaning VARCHAR2 (240);
935: CURSOR c_risk_rec (p_risk_rev_id IN NUMBER) IS
936: SELECT risk_id, NAME, creation_date
937: FROM amw_risks_all_vl
938: WHERE risk_rev_id = p_risk_rev_id;
939: BEGIN
940: fnd_msg_pub.initialize;
941: l_object_id :=