DBA Data[Home] [Help]

APPS.JTF_BRM_PVT dependencies on JTF_BRM_PROCESSES

Line 471: FROM jtf_brm_processes jbp,

467: jbr.rule_id,
468: jbp.rowid,
469: jbp.workflow_item_type,
470: jbp.workflow_process_name
471: FROM jtf_brm_processes jbp,
472: jtf_brm_rules_vl jbr
473: WHERE jbp.rule_id = jbr.rule_id
474: AND nvl(jbr.start_date_active, b_now + 1) <= b_now
475: AND nvl(jbr.end_date_active, b_now) >= b_now

Line 522: UPDATE jtf_brm_processes

518: -- Get the object_type and object_id for each object in each view
519: -- and launch the appropriate Workflow activity. The user-friendly
520: -- key will be , e.g., DF13579.
521: --
522: UPDATE jtf_brm_processes
523: SET last_brm_check_date = l_now
524: WHERE rowid = i.rowid;
525: --
526: l_query := 'SELECT object_type, object_id FROM ' || i.view_name;