DBA Data[Home] [Help]

APPS.CST_MGD_MSTR_BOOK_RPT dependencies on MTL_ABC_ASSIGNMENT_GROUPS

Line 644: FROM mtl_abc_assignment_groups

640: IF p_abc_group_id IS NOT NULL THEN
641: BEGIN
642: SELECT assignment_group_name
643: INTO gc_abc_group_name
644: FROM mtl_abc_assignment_groups
645: WHERE assignment_group_id = p_abc_group_id;
646: EXCEPTION
647: WHEN NO_DATA_FOUND THEN
648: gc_abc_group_name := NULL;

Line 2760: ,mtl_abc_assignment_groups MAG ';

2756:
2757: IF p_abc_group_id IS NOT NULL AND p_abc_class_id IS NOT NULL THEN
2758: v_from_clause := v_from_clause || ',mtl_abc_classes MAC
2759: ,mtl_abc_assignments MAA
2760: ,mtl_abc_assignment_groups MAG ';
2761:
2762: v_where_clause := v_where_clause || ' AND MAC.abc_class_id = MAA.abc_class_id
2763: AND MAA.assignment_group_id = MAG.assignment_group_id
2764: AND MAG.assignment_group_id = ' || p_abc_group_id ||