DBA Data[Home] [Help]

APPS.AMS_ITEM_OWNER_PVT dependencies on AMS_TEMPL_RESPONSIBILITY

Line 1751: FROM ams_templ_responsibility tr

1747: CURSOR c_get_template_id ( p_resp_id IN NUMBER
1748: , p_flag IN VARCHAR2)
1749: IS
1750: SELECT tr.template_id
1751: FROM ams_templ_responsibility tr
1752: , ams_prod_templates_b tb
1753: WHERE responsibility_id = p_resp_id
1754: AND tr.template_id = tb.template_id
1755: AND tb.product_service_flag = p_flag;