APPS.FEM_REFRESH_UTIL_PKG dependencies on FEM_DIM_ATTR_GRPS

Line 256: delete from fem_dim_attr_grps

252: and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'
253: and A1.attribute_varchar_label in ('FE_DATA_GROUPING_CODE'
254: ,'DIVISIBLE_FLAG'));
255:
256: delete from fem_dim_attr_grps
257: where attribute_id in (select attribute_id
258: from fem_dim_attributes_b A1, fem_dimensions_b D1
259: where A1.dimension_id = D1.dimension_id
260: and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'

Line 345: delete from fem_dim_attr_grps

341: ,'ACTIVATION_FLAG'
342: ,'OFFSET_CCTR_ORG'
343: ));
344:
345: delete from fem_dim_attr_grps
346: where attribute_id in (select attribute_id
347: from fem_dim_attributes_b A1, fem_dimensions_b D1
348: where A1.dimension_id = D1.dimension_id
349: and D1.dimension_varchar_label = 'LINE_ITEM'

Line 413: delete from fem_dim_attr_grps

409: where A1.dimension_id = D1.dimension_id
410: and D1.dimension_varchar_label = 'PRODUCT'
411: and A1.attribute_varchar_label in ('HIDDEN_FLAG'));
412:
413: delete from fem_dim_attr_grps
414: where attribute_id in (select attribute_id
415: from fem_dim_attributes_b A1, fem_dimensions_b D1
416: where A1.dimension_id = D1.dimension_id
417: and D1.dimension_varchar_label = 'PRODUCT'

Line 469: delete from fem_dim_attr_grps

465: where A1.dimension_id = D1.dimension_id
466: and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'
467: and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG'));
468:
469: delete from fem_dim_attr_grps
470: where attribute_id in (select attribute_id
471: from fem_dim_attributes_b A1, fem_dimensions_b D1
472: where A1.dimension_id = D1.dimension_id
473: and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'

Line 523: delete from fem_dim_attr_grps

519: where A1.dimension_id = D1.dimension_id
520: and D1.dimension_varchar_label = 'LEDGER'
521: and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG'));
522:
523: delete from fem_dim_attr_grps
524: where attribute_id in (select attribute_id
525: from fem_dim_attributes_b A1, fem_dimensions_b D1
526: where A1.dimension_id = D1.dimension_id
527: and D1.dimension_varchar_label = 'LEDGER'

Line 629: delete from fem_dim_attr_grps

625:
626: delete from fem_dim_attributes_b
627: where attribute_id = attr.attribute_id;
628:
629: delete from fem_dim_attr_grps
630: where attribute_id=attr.attribute_id;
631:
632: delete from fem_dim_attributes_priv
633: where attribute_id = attr.attribute_id;

Line 661: delete from fem_dim_attr_grps

657:
658: delete from fem_dim_attributes_b
659: where attribute_id = attr.attribute_id;
660:
661: delete from fem_dim_attr_grps
662: where attribute_id=attr.attribute_id;
663:
664: delete from fem_dim_attributes_priv
665: where attribute_id = attr.attribute_id;

Line 693: delete from fem_dim_attr_grps

689:
690: delete from fem_dim_attributes_b
691: where attribute_id = attr.attribute_id;
692:
693: delete from fem_dim_attr_grps
694: where attribute_id=attr.attribute_id;
695:
696: delete from fem_dim_attributes_priv
697: where attribute_id = attr.attribute_id;

Line 725: delete from fem_dim_attr_grps

721:
722: delete from fem_dim_attributes_b
723: where attribute_id = attr.attribute_id;
724:
725: delete from fem_dim_attr_grps
726: where attribute_id=attr.attribute_id;
727:
728: delete from fem_dim_attributes_priv
729: where attribute_id = attr.attribute_id;

Line 757: delete from fem_dim_attr_grps

753:
754: delete from fem_dim_attributes_b
755: where attribute_id = attr.attribute_id;
756:
757: delete from fem_dim_attr_grps
758: where attribute_id=attr.attribute_id;
759:
760: delete from fem_dim_attributes_priv
761: where attribute_id = attr.attribute_id;