DBA Data[Home] [Help]

APPS.PQH_WORKFLOW dependencies on PQH_ROLE_TEMPLATES

Line 280: from pqh_role_templates

276:
277: function get_role_template(p_role_id in number,
278: p_transaction_category_id in number) return number is
279: cursor c1 is select template_id
280: from pqh_role_templates
281: where role_id = p_role_id
282: and transaction_category_id = p_transaction_category_id
283: and enable_flag = 'Y';
284: l_template_id pqh_role_templates.template_id%type;

Line 284: l_template_id pqh_role_templates.template_id%type;

280: from pqh_role_templates
281: where role_id = p_role_id
282: and transaction_category_id = p_transaction_category_id
283: and enable_flag = 'Y';
284: l_template_id pqh_role_templates.template_id%type;
285: l_role_name pqh_roles.role_name%type;
286: l_transaction_category_name pqh_transaction_categories.name%type;
287: begin
288: open c1;