APPS.AMW_PROC_ORG_HIERARCHY_PVT dependencies on AMW_RCM_ORG_INTERFACE

Line 1054: from amw_rcm_org_interface

1050: select risk_likelihood_code,
1051: risk_impact_code,
1052: upper(material) as material,
1053: decode(nvl(upper(material),'N'),'N',null,material_value) as material_value
1054: from amw_rcm_org_interface
1055: where batch_id=p_batch_id
1056: and rcm_org_interface_id=p_rcm_org_intf_id;
1057:
1058: cursor c2(p_batch_id in number, p_rcm_org_intf_id in number) is

Line 1062: from amw_rcm_org_interface

1058: cursor c2(p_batch_id in number, p_rcm_org_intf_id in number) is
1059: select ap_name,
1060: upper(nvl(design_effectiveness,'N')) as design_effectiveness,
1061: upper(nvl(op_effectiveness,'N')) as op_effectiveness
1062: from amw_rcm_org_interface
1063: where batch_id=p_batch_id
1064: and rcm_org_interface_id=p_rcm_org_intf_id;
1065:
1066: l_c1_type c1%rowtype;